Questions tagged [db-browser-sqlite]
104 questions
-1
votes
1 answer
Why DB Browser have an order I can't replicate?
I have an issue I really don't understand. In fact, I have a database of movies where there's a table for actors,containing two colums (movie id and name).
For example, then I enter the movie id of Django Unchained, the first result is Jamie Fox…
Elias
- 77
- 7
-1
votes
1 answer
how to get specific records from two tables
I have 2 tables, table one contains phone numbers and owner name, and table two have phone , name and also its have city and street. the problem in table two is that the owner name is the name of the one who pays for the phone number and not the…
davidla
- 85
- 1
- 11
-1
votes
1 answer
Mutiple PK's in where clause
In my table I have (LocID) which is my PK and I am trying to narrow it down to specific 4, however when I run the query below I get only one answer. What needs to be fixed in this query?
-- second we find out the name of the locations
select name…
Vij
- 59
- 5
-1
votes
2 answers
What sql formula am I missing?
I need to find out the busiest location by check in for a query.
select name
from checkin join location on checkin.locid = location.LocID
order by name
This query gives me the result but I cannot figure how to group it by numbers.
If I put count…
Vij
- 59
- 5
-1
votes
1 answer
Add Computed Columns in SQL to the table
I am using DB Browser for SQLite. Feel free to recommend another free GUI or software that uses SQL if SQLite is the problem.
I need to take the values from the percent_rank() function and use them for a later calculation. This could be done by…
JimK
- 1
-1
votes
3 answers
sqlite remove square meters symbol from column
Let's say i have a column 'Sqr'
39 м²
48 м²
50 м²
15 м²
38 м²
38 м²
35 м²
And I want to remove square meters so that my column will look like this:
39
48
50
15
38
38
35
I've tried this query, but it didn't work
SELECT…
Andrew 76868
- 394
- 1
- 4
- 14
-1
votes
2 answers
Discrepancy between my SQL python data and the DB Browser
I am using sqlite combined with tkinter to write and delete records within my Python program. The deletion works perfectly fine in my program and also when I restart the program, the record does not exist anymore.
However, I always cross check using…
Bahlsen
- 177
- 1
- 9
-1
votes
1 answer
SQLite Exists Database
I want to display all the data from my database created in DB Browser, but I get these errors. I cannot find a solution. Please help me, this is very important to my project. Maybe there's a typo mistake.
05-27 13:54:22.584…
Ada
- 39
- 5
-2
votes
2 answers
Can't import northwind sql file onto DB Browser for SQLite
I seem to get this error message.
[Error importing data: Error in statement #1: near "S":syntax error. Aborting execution and rolling back.]
(https://i.stack.imgur.com/IzRvb.png)
I looked into the SQL file. These are the first few lines:
Select *…
-2
votes
1 answer
how can i connect java to sqlite db browser
I am trying to connect sqlite db browser with java using nano editor i am very new here. i have
followed some youtube videos but i am stacking at mid can anyone please help
here is my code.
import java.sql.Connection;
import…
-2
votes
1 answer
Showing several sentences for a given category in a SQLite database
I am developing an app quote and I am using a local database to import the quotes.
I have an issue here as you can see in the picture I want to put multiple quotes in one title.
For example, The title "Life" when I clicked it in the app it only…
Hicham louzali
- 3
- 1
-3
votes
1 answer
SQLite different execution time for same result
I've got a database with movies, and I wanted to extract every person, who starred in movies from the year 2004, ordered by birth. I've tried different querys which are doing the same, but the first one takes more than 10 times longer to execute…
Kanexxy
- 17
- 6
-3
votes
1 answer
SQLite; Is there a parameter to rewrite a single record each time
Right now, I can write records one by another, as it's shown below.
How do I rewrite a single record each time? For example only first one.
Code Behind:
public static List LoadPeople()
{
using (IDbConnection cnn = new…
Msorich
- 113
- 1
- 10
-5
votes
1 answer
How to get the day of the week from a date in mm/dd/yyyy format?
I am using DB Broswer for SQLite. I would like to retrieve information about the month and the day of the week for each sample.
SELECT Date
FROM Xtrain
returns
Date
26/04/2018
2/4/2018
I have tried using the TO_DATE statement.
Just to…
ReidG94
- 1
- 1