RE: Multi Line SQL Statements

2002-04-25 Thread Gerald R. Jensen
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.

RE: Multi Line SQL Statements

2002-04-24 Thread Venu
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 progra

Re: Multi Line SQL Statements

2002-04-24 Thread Michael Grover
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

Re: Multi Line SQL Statements

2002-04-24 Thread Gerald R. Jensen
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 sam