Running multiple queries in Query Browser 1

[dave755]

What is the magic word to get query browser to execute a string of queries?

Example:

insert into X (a, b) values (1, 2);
insert into X (a, b) values (3, 4);
... etc ...

Individually, each query runs fine. When I try to combine them into a script, I get a syntax error.

Dave Gee

 

[TonyGroves]

Looks like it can only handle one query at a time.
MySQL Control Centre can handle a sequence of queries separated by semicolons.

 

[dunamin]

QueryBrowser can do more than one statement at a time only in a script. Try File>>New Script Tab.

 

[dave755]

Thank you for the tip. I just wish that the error message was more helpful. The message spoke about a syntax error, so I was scrutinizing my SQL, when that was not the problem at all.

Dave Gee