sqlite> DELETE FROM mails WHERE (`id` = 71); SQL error: database is locked How do I unlock the database so this will work? 38 Answers 38 In windows you can try this program http://www.nirsoft.net/utils/opened_files_view.html to find out the process is handling db file. Try closed that program for unlock database In Linux and macOS you … Read more
I want to create a table in a SQLite database only if doesn’t exist already. Is there any way to do this? I don’t want to drop the table if it exists, only create it if it doesn’t. 2 Answers 2
I would need to rename a few columns in some tables in a SQLite database. I know that a similar question has been asked on stackoverflow previously, but it was for SQL in general, and the case of SQLite was not mentioned. From the SQLite documentation for ALTER TABLE, I gather that it’s not possible … Read more
I’ve found a few “would be” solutions for the classic “How do I insert a new record or update one if it already exists” but I cannot get any of them to work in SQLite. I have a table defined as follows: CREATE TABLE Book ID INTEGER PRIMARY KEY AUTOINCREMENT, Name VARCHAR(60) UNIQUE, TypeID INTEGER, … Read more
What is the type for a BOOL value in SQLite? I want to store in my table TRUE/FALSE values. I could create a column of INTEGER and store in it values 0 or 1, but it won’t be the best way to implement BOOL type. Is there a way? 9 Answers 9
I want to select records from sqlite3 database by string matching. But if I use ‘=’ in the where clause, I found that sqlite3 is case sensitive. Can anyone tell me how to use string comparing case-insensitive? 11 Answers 11
I have tried this which did not work. select top 5 * from [Table_Name] 7 Answers 7
I have a table with columns name, qty, rate. Now I need to add a new column COLNew in between the name and qty columns. How do I add a new column in between two columns? 7 Answers 7
I want to migrate my iPhone app to a new database version. Since I don’t have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select SELECT sql FROM sqlite_master WHERE tbl_name=”table_name” AND type=”table” and parse the result. Is that the common way? Alternatives? 22 s … Read more
What is the syntax for specifying a primary key on more than 1 column in SQLITE ? 9 s 9 According to the documentation, it’s CREATE TABLE something ( column1, column2, column3, PRIMARY KEY (column1, column2) );
