Re: [sqlite] Exporting to MySQL?

[Kees Nuyt]

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 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

[sqlite] Exporting to MySQL?

[Gilles Ganault]

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 NULL, address TEXT);
CREATE TABLE support (id INTEGER PRIMARY KEY AUTOINCREMENT, name
TEXT);
COMMIT;

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users