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 : [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] Web: http://www.brisnet.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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
