List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 11 2002 6:28pm
Subject:RE: ADO Bulk Inserts
View as plain text  
At 1:31 -0500 12/11/02, Michael She wrote:
>At 11:00 PM 12/10/2002 -0600, Paul DuBois wrote:
>>Yes, a single bulk insert will be faster.
>>
>>Also, the reason your "multiple statements separated by semicolons"
>>approach fails with a syntax error is that the client server
>>protocol does not allow you to send multiple statements in the
>>same string.  Indeed, you might even get a syntax error by adding
>>a semicolon to the end of a string containing a *single* query,
>>because semicolons are not actually part of any SQL statement syntax.
>
>
>Shoot, this is what I thought.  I tried it without a semi-colon as 
>well but it didn't work.  So are you saying that the Windows ODBC 
>MySQL driver doesn't support multiple statements?

No, I'm saying that the client server protocol itself doesn't support that.
In other words, the server doesn't allow it, so it doesn't make any difference
what driver you use, whether it's ODBC, JDBC, or whatever.

MySQL 4.1 will support multiple statements, I believe, but that's still
under development.

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