|List:||General Discussion||« Previous MessageNext Message »|
|From:||Alan R Anderson||Date:||December 11 2002 1:14pm|
|Subject:||RE: ADO Bulk Inserts|
|View as plain text|
> From: Michael She [mailto:michael.she@stripped] > ...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.