List:MySQL on Win32« Previous MessageNext Message »
From:S. R. Date:March 6 2000 12:11am
Subject:Multiple Inserts
View as plain text  
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.

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