I have a sql script that issues a bunch of truncate statements to purge
a database in development. The script looks like:
truncate table table_1;
truncate table tabel_2;
truncate table table_3;
and so on...
I can load this script as a single query in the old mysql_front (version
2.2) GUI and it runs fine. However the same query loaded into MySQL
Query Browser fails after the first line. Is there a way to structure
the syntax differently so I can run the multiple truncates in one query
via Qeury Browser?
Any advice is appreciated,
|• query syntax in new mysql query browser||Eben||9 Dec|