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
For some reason I can’t find a way to get the equivalents of sqlite’s interactive shell commands: .tables .dump using the Python sqlite3 API. Is there anything like that? 12 Answers 12
How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)? The dump should be in SQL format, as it should be easily re-entered into the database later and should be done from the command line. Something like sqlite3 db .dump but … 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
Is it possible in a sqlite database to craete a table that has a timestamp column that default to DATETIME(‘now’) ? Like this: CREATE TABLE test ( id INTEGER PRIMARY KEY AUTOINCREMENT, t TIMESTAMP DEFAULT DATETIME(‘now’) ); This gives an error… How to resolve? 9 Answers 9
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
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to … Read more
How to retrieve inserted id after inserting row in SQLite using Python? I have table like this: id INT AUTOINCREMENT PRIMARY KEY, username VARCHAR(50), password VARCHAR(50) I insert a new row with example data username=”test” and password=”test”. How do I retrieve the generated id in a transaction safe way? This is for a website solution, … Read more
