On Wed, 08 Oct 2008 13:14:43 +0200, Gilles Ganault <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
>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 text? >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 NULL, address TEXT); >CREATE TABLE support (id INTEGER PRIMARY KEY AUTOINCREMENT, name >TEXT); >COMMIT; I think MySQL uses AUTO_INCREMENT. You will have to dive into the documentation to make sure. A mailing list is not a manual lookup service. >Thank you. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
