-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists
But, I thnk I am missing some information on the syntax of INSERT ...
VALUES.
This may be what
Hi James,
INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6);
is an example of inserting multiple rows with one insert statement,
instead of these 2:
INSERT INTO table (a,b,c) VALUES (1,2,3);
INSERT INTO table (a,b,c) VALUES (4,5,6);
That should give you enough to work with.
-Sheeri
On
James Black [EMAIL PROTECTED] wrote on 12/08/2005 01:07:15 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists
But, I thnk I am