Converting MySQL database dump into SQLite - INSERT syntax

Question

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?

Line 82: INSERT INTO files (file_id,file_name) VALUES, line 83: (31, 'file_name.pdf'),. — syntagma
– syntagma, Commented Sep 9, 2012 at 15:20
can you still post lines before and after line 83? i need to see how your records are formatted. — John Woo
– John Woo, Commented Sep 9, 2012 at 15:22
In this table ('files'), all the values are formatted in the same way and the last line with values to insert is: (55, 'filexxx.pdf');. — syntagma
– syntagma, Commented Sep 9, 2012 at 15:25

CL. · Accepted Answer · 2012-09-09 16:36:12Z

1

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.

answered Sep 9, 2012 at 16:36

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting MySQL database dump into SQLite - INSERT syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related