Thanks for the Insert Sytax! I'll give this a go!
At 08:14 AM 12/11/2002 -0500, Anderson, Alan R wrote:
> From: Michael She [mailto:[EMAIL PROTECTED]]
> ...So are you saying that the Windows ODBC MySQL driver
> doesn't support multiple statements?
So far as I know, *no* drivers support multiple statements.
However, that's not what you want for "bulk inserts". What you want is multiple value sets in one INSERT statement:
INSERT INTO tablename(col1, col2) VALUES (val1a, val2a), (val1b, val2b), (val1c, val2c)
That's what you're doing already, right? So I don't understand your issue.
-- 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
