Geek Answers Handbook

MySQL Query Browser Multiple Applications

So, I am using MySQL Query Browser to connect to a remote mysql server and trying to execute several statements. But it seems that he only performs one statement at a time. For example, it looks like the query browser only executes the selected line and none of the other operators. Is there a way to follow all the instructions on the tab?

+6
database mysql
source share
2 answers

On the Default Settings tabs, only the statement in which the cursor is located is executed.

To execute multiple statements at a time, you need to use the Script tab. Select "New Script Tab" from the "File" menu. Please note that you will not see the results of any queries on the Script tab.

+19
source share

On your system, save all queries in a .sql file. In the MySQL Query Browser, go to Tools> MySQL Command Line Client. At the command prompt, connect to your database using the following command: use [your db name]. example: use test (test is the name of the database) After connecting to your db run the following command: source [your path to the .sql file] Example: source C: \ Users \ 100390 \ Desktop \ select.sql (select.sql is my saved .sql file)

0
source share

More articles:


All Articles