> 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. --------------------------------------------------------------------- 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