Re: [sqlite] Exporting to MySQL?

On Wed, 08 Oct 2008 13:14:43 +0200, Gilles Ganault <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >Hello > >I'm no MySQL expert, and am having some syntax errors when trying to >export data from SQLite 3 into MySQL 5. What's the error number and

[sqlite] Exporting to MySQL?

Hello I'm no MySQL expert, and am having some syntax errors when trying to export data from SQLite 3 into MySQL 5. Before I dive into MySQL's documentation, does someone know how I should rewrite this type of SQL to keep MySQL happy? BEGIN TRANSACTION; CREATE TABLE dummy (id TEXT PRIMARY KEY NOT