Actually, no that isn't how I was doing it - I was concatenating multiple
inserts together like you do on SQL server. (ie Insert... Insert... Insert...)
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: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.
--
Michael She : michael.she@stripped
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
