Chris W. Parker wrote:
Hello,
I searched the archives, looked through the manual, and searched google
for info on how to actually perform a multi-row INSERT but didn't find
an answer.
Would someone please show me the syntax for this please?
I could just do a loop and INSERT the data that way but according to the
manual, a multi-row INSERT is faster.
I think you're looking for something like
INSERT INTO table [ (x, y, z) ] VALUES (a, b, c),
(d, e, f),
(h, i, j);
--
Jonathan Wright <mail at djnauk dot co dot uk>
Life has no meaning unless we can enjoy what we've been given
--
Running on Gentoo Linux
(2.6.10-gentoo-r7-djnauk-b03 i686 AMD Athlon(tm) XP 2100+ GNU/Linux)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
