Hi,

If my SQL script file Test.sql contains the 3 lines:
SELECT * FROM Table1;
QUIT;
SELECT * FROM Table2;

and I run the script from a Mysql prompt like:
mysql> SOURCE Test.sql;

then the QUIT is treated as an error rather than a command.

Any suggestions?

Thanks,
Joe

On 14-02-11 14:47, Joe Hesse wrote:
First, the semi-colon at the end of QUIT should be removed.
The semi-colon is only to end a SQL statement, and not an internal
statement for the client.

i.e. 'system echo TEST' will work, and do the system shell command 'echo
TEST'....


mysql <Test.sql
will end the client on the line containing the 'QUIT'


--
Luuk