Franck Dernoncourt
Franck Dernoncourt

Reputation: 83297

How to execute multiple SQL queries concurrently in MySQL Workbench?

I have two tabs in MySQL Workbench's SQL Editor, each of them containing one SQL query: is there any way I can launch those two queries concurrently? I use Windows 7 64-bit Ultimate with MySQL Workbench 5.2.47 CE.

Upvotes: 5

Views: 13717

Answers (2)

MatP
MatP

Reputation: 144

This is now possible. I'm using MySQL Workbench 6.2.5 on Ubuntu 14.04. To do so, select "New Tab to Current Server" from the [Query] drop down menu or press Ctrl+Shift+T. Get the latest version of the software by downloading it from the official website.

Upvotes: 12

Mike Lischke
Mike Lischke

Reputation: 53417

In order to avoid excessive usage of connections all editors in a session share the same connection (there's another one in the background for maintenance tasks like killing a query, but in general you only have one at your disposal). What you can do however is to open multiple sessions to the same server. They can then run queries concurrently.

Upvotes: 5

Related Questions