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
