List:General Discussion« Previous MessageNext Message »
From:Fernando Grijalba Date:December 10 2002 5:55pm
Subject:RE: ADO Bulk Inserts
View as plain text  
Have you try this:

dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1,
val2),(val1,val2),(val1,vla2);")

JFernando
** sql **

-----Original Message-----
From: Michael She [mailto:michael.she@stripped]
Sent: December 10, 2002 12:08
To: Fernando Grijalba
Cc: MySQL Help
Subject: RE: ADO Bulk Inserts


Same table, but it shouldn't matter right?

I'm getting a SQL syntax error once I start combining my statements
together.  If I submit the statements separately they're OK.



At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote:
>Are the inserts to the same table or different tables and columns?
>
>JFernando
>** sql **
>
>-----Original Message-----
>From: Michael She [mailto:michael.she@stripped]
>Sent: December 9, 2002 14:56
>To: MySQL List
>Subject: ADO Bulk Inserts
>
>
>Hi All,
>
>
>Does MySQL allow for Bulk Inserts via ADO?
>
>I can get a single insert statement to be inserted, but if I try t
>concatenate multiple inserts, I get a sytax error.
>
>I tried putting a space between each statement, return charater,
>semi-colon, etc, but it doesn't work.
>
>I'm doing the inserts through a ADODB.Connection.
>
>Thanks.
>--
>Michael She  : michael.she@stripped
>Mobile       : (519) 589-7309
>WWW Homepage : http://www.binaryio.com/
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread127036@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread127109@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-michael.she=binaryio.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Michael She  : michael.she@stripped
Mobile       : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



---------------------------------------------------------------------
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 <mysql-thread127124@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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