MySQL Query Browser Multiple Statements

Question

So, I'm using MySQL Query Browser to connect to a remote mysql server and trying to execute multiple statements. But it appears to only execute one statement at a time. For instance, it looks like the query browser is only executing a highlighted line and none of the other statements. Is there any way to execute all the statements in a tab?

Phil Ross · Accepted Answer · 2009-11-24 23:59:51Z

21

The default Resultset tabs only execute the statement the cursor is on.

To execute multiple statements at a time you need to use a Script tab. Select New Script Tab from the File menu. Note that you won't see the results of any queries in the Script tab.

edited Nov 24, 2009 at 23:59

answered Nov 24, 2009 at 23:50

Phil Ross

26.2k9 gold badges71 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tarekahf Over a year ago

Thanks! But how I can view the results of the statement execution?

Nandita Sahu · Accepted Answer · 2017-12-13 14:18:57Z

0

In your system save all the queries in .sql file.In MySQL Query Browser go to Tools > MySQL Command Line Client. In the command line connect to your database using the below command: use [your db name]. example:use test (test is DB name) Once connected to your db execute the following command: source [your .sql file path] example: source C:\Users\100390\Desktop\select.sql (select.sql is my saved .sql file)

edited Dec 13, 2017 at 14:18

answered Dec 13, 2017 at 12:57

Nandita Sahu

891 silver badge7 bronze badges

1 Comment

Mathews Sunny Over a year ago

These doesn't form qualified answer

Collectives™ on Stack Overflow

MySQL Query Browser Multiple Statements

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related