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:mmgrover@stripped]
Sent: Wednesday, April 24, 2002 7:51 PM
To: Gerald R. Jensen
Cc: mysql@stripped
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" <mmgrover@stripped>
> To: <mysql@stripped>
> 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 <mysql-thread107044@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-autodata=execpc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
