Hi !! > -----Original Message----- > From: Michael Grover [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 5:51 PM > To: Gerald R. Jensen > Cc: [EMAIL PROTECTED] > Subject: Re: Multi Line SQL Statements > > > It's The MySQL Control Center program. > I can take and save the sql statements from Mycc to a text file and > call "MySql > c:\sql.txt" and it runs fine... >
MySQL 4.1 will have a better solution for this, which allows multi query execution directly in server side. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > "Gerald R. Jensen" wrote: > > > > Michael ... > > > > Works for me ... at the console: > > > > mysql> create table zipsta2 (zip char(5), state char(2)); > > Query OK, 0 rows affected (0.06 sec) > > > > mysql> create table zipstates (state char(2), zip char (5)); > > Query OK, 0 rows affected (0.06 sec) > > > > Put the same query in a script piped into MySQL with same results. > > > > How are you entering a multiple SQL statement? > > > > Gerald Jensen > > > > ----- Original Message ----- > > From: "Michael Grover" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, April 24, 2002 6:59 PM > > Subject: Multi Line SQL Statements > > > > I have a dumb Question... > > > > When I try to enter a Multiple line SQL statement like: > > > > create table ZIPSTA2 (zip char(5), state char(2)) ; > > create table ZIPSTATES (state char(2), zip char(5)); > > > > I get this error: > > > > [root@localhost:3306] ERROR 1064: You have an error in your > SQL syntax > > near '; create table ZIPSTATES (state char(2), zip > char(5))' at line 1 > > > > What am I doing wrong? > > > > mike > > > > ps: > > > > I am using MySQL Control Center 0.8.2 alpha > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php