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
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 12/8/05,
-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
