List:General Discussion« Previous MessageNext Message »
From:Michael She Date:December 11 2002 5:54pm
Subject:RE: ADO Bulk Inserts
View as plain text  
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/


Thread
Select * From table where name Like 'help'; HelpBeauford.20039 Dec
  • Re: Select * From table where name Like 'help'; HelpJocelyn Fournier9 Dec
  • Re: Select * From table where name Like 'help'; HelpRobert Citek9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • ADO Bulk InsertsMichael She10 Dec
        • RE: ADO Bulk InsertsFernando Grijalba10 Dec
          • RE: ADO Bulk InsertsMichael She10 Dec
            • RE: ADO Bulk InsertsFernando Grijalba10 Dec
              • RE: ADO Bulk InsertsMichael She10 Dec
                • RE: ADO Bulk InsertsFernando Grijalba10 Dec
                  • RE: ADO Bulk InsertsMichael She10 Dec
                    • RE: ADO Bulk InsertsPaul DuBois11 Dec
                      • RE: ADO Bulk InsertsMichael She11 Dec
                        • RE: ADO Bulk Insertsed11 Dec
                        • RE: ADO Bulk InsertsPaul DuBois11 Dec
      • Re: OT Select * From table where name Like 'help'; HelpMichael T. Babcock10 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpRobert Citek10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
  • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
RE: ADO Bulk InsertsAlan R Anderson11 Dec
  • RE: ADO Bulk InsertsMichael She11 Dec