List:MySQL on Win32« Previous MessageNext Message »
From:sinisa@mysql.com Date:March 6 2000 2:07pm
Subject:Re: Multiple Inserts
View as plain text  
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       |
+----------------------------------------------------------------------+
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