List:MySQL on Win32« Previous MessageNext Message »
From:Peter Carter Date:March 7 2000 1:26am
Subject:Re: Multiple Inserts
View as plain text  
Don't feel bad. I read the entire thread and did not pick that up ;)

on 3/6/00 9:16 AM, S. R. at sraley@stripped wrote:

> Now I feel stupid
> 
> ----- Original Message -----
> From: <sinisa@stripped>
> To: "S. R." <sraley@stripped>; <win32@stripped>
> Sent: Monday, March 06, 2000 9:07 AM
> Subject: Re: Multiple Inserts
> 
> 
>> On Mon, 06 Mar 2000, S. R. wrote:
>>> I'm trying to run a script with multiple inserts.
>>> I used a script to convert an msaccess db to mysql
>>> 
>>> the script has:
>>> 
>>> insert into alias (20, 35, 'ABC')\g
>>> insert into alias (1, 325, 'ABCD')\g
>>> insert into alias (22, 25, 'ABCDE')\g
>>> insert into alias (230, 315, 'ABCDEF')\g
>>> I get errors on line 2 for the \g
>>> 
>>> If I replace these with ; I get an error online 2 for ;
>>> I've tried without the ; and I have tried only putting the last line with
> ;
>>> and I still can't get this script to work. What am I doing wrong? If I do
>>> one line at a time the insert statements work.
>> 
>> HI!
>> 
>> First of all, you need values keyword.
>> 
>> 
>> Second, if you are on 3.22.7 or higher, you can use:
>> 
>> insert into alias values (...),(...),(...),....
>> 
>> Regards,
>> 
>> Sinisa
>> 
>> +----------------------------------------------------------------------+
>> | TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
>> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
>> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
>> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
>> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
>> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
>> |             /*/             \*\                Developers Team       |
>> +----------------------------------------------------------------------+
>> 
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> posting. To request this thread, e-mail win32-thread1717@stripped
>> 
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail win32-unsubscribe@stripped instead.
>> 
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread1720@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.

Thread
Error 1030 ?C. Javier Castro Peña5 Mar
  • Re: Error 1030 ?sinisa@mysql.com5 Mar
  • Multiple InsertsS. R.6 Mar
    • Re: Multiple Insertssinisa@mysql.com6 Mar
  • Re: Error 1030 ?C. Javier Castro Peña6 Mar
    • Re: Error 1030 ?sinisa@mysql.com6 Mar
  • Re: Error 1030 ?C. Javier Castro Peña6 Mar
  • Re: Multiple InsertsS. R.6 Mar
    • Re: Multiple InsertsPeter Carter7 Mar
  • Re: Multiple InsertsS. R.8 Mar
    • Re: Multiple Insertssinisa@mysql.com8 Mar
RE: Multiple InsertsJosé Ostos Turner9 Mar