| 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ña | 5 Mar |
| • Re: Error 1030 ? | sinisa@mysql.com | 5 Mar |
| • Multiple Inserts | S. R. | 6 Mar |
| • Re: Multiple Inserts | sinisa@mysql.com | 6 Mar |
| • Re: Error 1030 ? | C. Javier Castro Peña | 6 Mar |
| • Re: Error 1030 ? | sinisa@mysql.com | 6 Mar |
| • Re: Error 1030 ? | C. Javier Castro Peña | 6 Mar |
| • Re: Multiple Inserts | S. R. | 6 Mar |
| • Re: Multiple Inserts | Peter Carter | 7 Mar |
| • Re: Multiple Inserts | S. R. | 8 Mar |
| • Re: Multiple Inserts | sinisa@mysql.com | 8 Mar |
| • RE: Multiple Inserts | José Ostos Turner | 9 Mar |
