Converting MySQL database dump into SQLite - INSERT syntax
I'm trying to adapt my database dump into SQLite format, using the following command: cat db.sql | sqlite3 sqlite.db
I get the following error: Error: near line 82: near ",": syntax error , where line 82 stands for: INSERT INTO files (file_id,file_name) VALUES (the insert data in the following format (31, 'file_name.pdf'), come after that in the following lines).
According to this tutorial it is correct SQLite syntax for INSERT. What am I doing wrong?
Having more than one record in one INSERT command is not standard SQL.
If you use this syntax, you'd need at least SQLite 3.7.11.