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.
