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, James Black <[EMAIL PROTECTED]> wrote: > -----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 I am looking for, as I want to see if sending 100 > inserts at one time is faster than doing 100 inserts, one at a time. I > expect it is, but I would like to get some numbers for my query. > > Thank you for any help. > > - -- > "Love is mutual self-giving that ends in self-recovery." Fulton Sheen > James Black [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDmHZTikQgpVn8xrARAnFKAJ9Co+SEny8Xl3q/NaHW528qv+JawwCeOjgj > jCma5KTtC6w7f51LnmgECHY= > =HIjc > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
