Questions tagged [db-browser-sqlite]
104 questions
0
votes
2 answers
SUM CASE WHEN (SQL)
I want to apply a simple SUM CASE WHEN to a table I have created from CSV (in DB Browser for SQLite). At the moment I have the below code:
Select user_id,
CASE Overall_Result
WHEN 'Fail' then 0
WHEN 'Pass' then 1 else 0
END as "Case When"
from…
bz_2020
- 79
- 1
- 14
0
votes
1 answer
DB Browser for SQLite encoding?
I am using DB Browser for SQLite to analyse CSV data and I am trying to run a simple query that seems to be returning an odd result:
select MIN(created_at1) from Table
The above query is returning "01/06/2017 00:22" as the result, but this is not…
bz_2020
- 79
- 1
- 14
0
votes
1 answer
Can we view the Core data SQLite file from Oracle SQL Developer application in macOS?
I am using Core data in my application. I want to view the actual Sqlite db file for verifying my data. I know about DBBrowser for SQLite but can I use Oracle SQLDeveloper for this ?
subin272
- 733
- 6
- 24
0
votes
2 answers
Query to get rows for specific user where revenue > revenue of earliest date for that user
I have a table called user_revenue which looks like this
So the query I need, if ran for the user 'AAA' should only return the last row.
SELECT *
FROM user_revenue
WHERE user_Id = 'AAA' /*Change according to user_id*/
AND revenues > (SELECT…
lfc
- 185
- 6
0
votes
0 answers
Deleting fields in SQLite3 (dbBrowser) where id matches a certain input
I am trying to delete a row where the email address corresponds to the user input. However, it always throws back an error.
column_2 = 'Email'
table_name = 'Personal_Information'
cn = 'Email'
deleting_user = easygui.multenterbox(msg1, title,…
Beni billhardt
- 37
- 4
0
votes
1 answer
Create a database and add tables
I am new to sql so I have a problem where I am asked to create a database for a city. The database I created with DB Browser.
The database code is below. When I try to use the database to add anything to it or even see if it is created successfully…
c00kie_monster
- 87
- 9
0
votes
1 answer
Is there any problem with this query? why doesn't it work?
public ArrayList getQuietPlaces(String lng, String lat) {
ArrayList quietPlaces = new ArrayList();
SQLiteDatabase db = this.getReadableDatabase();
String quietPlacesLocation = "SELECT…
soupyc123
- 11
- 3
0
votes
0 answers
DB Browser for SQLite - Error Uploading CSV
I am trying to upload a csv to DB Browser for SQLite on my Macbook. I properly uploaded one table into my database, but the other two give me the same error:
Error importing data from record number 609. Inserting row failed: not an error
For both…
swatland610
- 1
- 2
0
votes
1 answer
How to fix error in DB Browser where foreign key instruction causing empty table?
Trying to build tables for a project in DB Browser and one of my tables is being created without any attribute columns, totally empty.
I've determined through trial, that the offending instruction is one of the foreign key assignments (specifically…
CoryK
- 31
- 3
0
votes
5 answers
SQL query SELECT time intervals
I'm trying to SELECT all the rows from a SQL database which are between an hour interval, for every day.
The datetime column is called "Dt" and has the following datetime format: 2019-10-17 16:03:43
I'd like to extract all the rows from this table…
arnaud405
- 1
- 1
- 2
0
votes
0 answers
Optimisiing SQLite DB file for android
I am converting xlxs to CSV table and then finally convert them to Sqlite DB file using DB Browser for SQLite.
My Sqlite DB file size is around 25 MB,with 92k records
On processing conversion to db file ,i remove empty/white spaces between columns…
Rakesh
- 14,997
- 13
- 42
- 62
0
votes
1 answer
How do I prepopulate image on knex migration and seed using db-browser for SQLite?
I am trying to prepopulate image using knex migration and seed. I am also using DB browser for SQLite. Here is what I have so far.
exports.up = function(knex, Promise) {
return knex.schema.createTable('shows', function(shows) {
…
0
votes
1 answer
SQL Error Regarding Foreign Key Restraint
I am currently getting the following error when trying to add to one of my tables:
Error adding record: FOREIGN KEY constraint failed: (INSERT INTO Stock(StockID,ItemName,MinAmountRequired,AmountInStock,Order?…
Sonny P.
- 105
- 2
- 11
0
votes
1 answer
SQL growth percentage how to
I know there are enough posts here about the percentage growth but nothing helped me.
I have a table with this columns:
Retailer country, retailer_type,
product_type, product, year, revenue,
quantity, gross_margin
I have to find…
Aylin
- 1
- 2
0
votes
1 answer
sqlite db which created by db browser does not work in android studio
I have created an SQLite database using DB Browser, when I move it to the assets folder and open it in the android studio it looks so bad and it doesn`t work. what is the solution ? :(
here is a screenshot
Noor
- 57
- 1
- 7