RE: Multi Line SQL Statements
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
Re: Multi Line SQL Statements
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
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
RE: Multi Line SQL Statements
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