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 will work? … Read more
sqlite
Create table in SQLite only if it doesn’t exist already
I want to create a table in a SQLite database only if doesn’t exist already. Is there any way to do this? I … Read more
How do I rename a column in a SQLite database table?
I would need to rename a few columns in some tables in a SQLite database. I know that a similar question has been … Read more
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 if it already … Read more
Store boolean value in SQLite
What is the type for a BOOL value in SQLite? I want to store in my table TRUE/FALSE values. I could create a … Read more
How to set Sqlite3 to be case insensitive when string comparing?
I want to select records from sqlite3 database by string matching. But if I use ‘=’ in the where clause, I found that … Read more
How to get Top 5 records in SqLite?
I have tried this which did not work. select top 5 * from [Table_Name] 7 Answers 7
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 the name and … Read more
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 need to check … Read more
Sqlite primary key on multiple columns
What is the syntax for specifying a primary key on more than 1 column in SQLITE ? 9 s 9 According to the … Read more