Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 9 years ago. Improve this question I recently read this Question about SQLite vs MySQL and the answer pointed out that SQLite doesn’t scale well and the official website … Read more
I can find syntax “charts” on this on the SQLite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns. This is what I have that is causing an SQLiteException with the … Read more
I’m new to SQLite. Is there a way I can export the results of a query into a CSV file? 6 Answers 6
I wrote the database schema (only one table so far), and the INSERT statements for that table in one file. Then I created the database as follows: $ sqlite3 newdatabase.db SQLite version 3.4.0 Enter “.help” for instructions sqlite> .read ./schema.sql SQL error near line 16: near “s”: syntax error Line 16 of my file looks … Read more
I have an SQLite database. I am trying to insert values (users_id, lessoninfo_id) in table bookmarks, only if both do not exist before in a row. INSERT INTO bookmarks(users_id,lessoninfo_id) VALUES( (SELECT _id FROM Users WHERE User=””+$(“#user_lesson’).html()+”‘), (SELECT _id FROM lessoninfo WHERE Lesson=”+lesson_no+” AND cast(starttime AS int)=”+Math.floor(result_set.rows.item(markerCount-1).starttime)+”) WHERE NOT EXISTS ( SELECT users_id,lessoninfo_id from bookmarks WHERE … Read more
Does SQLite3 safely handle concurrent access by multiple processes reading/writing from the same DB? Are there any platform exceptions to that? 7 Answers 7
Is it somehow possible to create a stored procedure, when using SQLite? 5 Answers 5
Are there advantages or disadvantages to the file extension used for SQLite databases? It seems that SQLite itself does not require a naming convention, but there might be other reasons that a particular extension would be useful or problematic – for instance, certain tools, programming languages, installers, etc. Or end user considerations. The most common … Read more
This question already has answers here: Is there an SQLite equivalent to MySQL’s DESCRIBE [table]? (7 answers) Closed 6 years ago. How can I see the structure of table in SQLite as desc was in Oracle? 8 Answers 8
I want to delete or add column in sqlite database I am using following query to delete column. ALTER TABLE TABLENAME DROP COLUMN COLUMNNAME But it gives error System.Data.SQLite.SQLiteException: SQLite error near “DROP”: syntax error 22 Answers 22
