Michael: Then I would think the problem is with the application(s) you are using as opposed to MySQL.
It doesn't appear you are doing anything wrong. Gerald Jensen -----Original Message----- From: Michael Grover [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 7: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... wierd "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
