The proper way to do a bulk insert is:
INSERT INTO tablename
VALUES(field1,field2,field3),(field1,field2,field3),(field1,field2,fie
ld3),(field1,field2,field3) etc..
On 11 Dec 2002 at 1:31, Michael She wrote:
> At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote:
> >Yes, a single bulk insert will be faster.
> >
> >Also, the reason your "multiple statements separated by semicolons"
> >approach fails with a syntax error is that the client server
> >protocol does not allow you to send multiple statements in the
> >same string. Indeed, you might even get a syntax error by adding
> >a semicolon to the end of a string containing a *single* query,
> >because semicolons are not actually part of any SQL statement syntax.
>
>
> Shoot, this is what I thought. I tried it without a semi-colon as well but
> it didn't work. So are you saying that the Windows ODBC MySQL driver
> doesn't support multiple statements?
>
> Thanks.
> --
> Michael She : michael.she@stripped
> Mobile : (519) 589-7309
> WWW Homepage : http://www.binaryio.com/
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread127193@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ed=brisnet.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
Ed Pauley II
Bloodstock Research Information Services
Phone: (859) 223-4444 ext. 297
E-mail: ed@stripped
Web: http://www.brisnet.com
