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 |
+----------------------------------------------------------------------+
