Top "Sqlite" questions

Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP …

sql sqlite postgresql group-by greatest-n-per-group

How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file …

sql database sqlite metadata

How to get a list of column names on Sqlite3 database?

I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I …

sqlite

How do I check in SQLite whether a table exists?

How do I, reliably, check in SQLite, whether a particular user table exists? I am not asking for unreliable ways …

sqlite

INSERT IF NOT EXISTS ELSE UPDATE?

I've found a few "would be" solutions for the classic "How do I insert a new record or update one …

sqlite insert exists upsert merge-conflict-resolution

How do I unlock a SQLite database?

sqlite> DELETE FROM mails WHERE (`id` = 71); SQL error: database is locked How do I unlock the database so this …

sqlite

Improve INSERT-per-second performance of SQLite

Optimizing SQLite is tricky. Bulk-insert performance of a C application can vary from 85 inserts per second to over 96,000 inserts per …

c performance sqlite optimization

Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2…

sql sqlite syntax

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways …

java android sql eclipse sqlite

Insert new column into table in sqlite?

I have a table with columns name, qty, rate. Now I need to add a new column COLNew in between …

sqlite