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?

Answers


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.


Need Your Help

Castor and JAXB Marshaller

java jaxb castor

Currently I am using Castor framework to marshall the object into xml file it work greats

How can I move the position of a navbar logout button?

twitter-bootstrap navbar

I have a navbar with a welcome greeting for the user on the left, but I want to move my logout feature to the opposite side on the right. At the moment it sits beside the welcome. Any ideas on how to

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.