I am trying MySQL Workbench 6.0 and when I execute a query the results are displayed with a tab called "Result 1". When I fire another query the same tab is reused, now named "Results 2".
I found no way to open a new results tab (not query tab). What am I missing?
3 Answers 3
MySQL Workbench always closes all existing resultset tabs when it executes the content in a specific tab. If you have several queries in your editor and execute all of them (and they return a result set) then a new resultset tab is created for each returned set.
If you want a specific resultset tab to stay while running other queries open it in a separate editor tab.
-
Is there a way to set name to the result tab in the query itself? Like automatically renaming default "Result 1" to "Students data"?Lamar– Lamar2017年07月09日 14:07:19 +00:00Commented Jul 9, 2017 at 14:07
-
No, that's not possible.Mike Lischke– Mike Lischke2017年07月09日 15:05:36 +00:00Commented Jul 9, 2017 at 15:05
Once you have run a query in MySQL Workbench, you can right-click and pin - and rename - the query results. The next query in the same query tab which you run, will open a new results tab, allowing you to switch between both results (multiple if you pin further result tabs) and compare results without having to re-run each query again.
nothing to worry about. this is how it works. just counting results. if you make 2 select statements they will be in different results tabs, not like in mssql man. studio in 1.
select * from tableA -> tab tableA 1 select * from tableB -> tab tableB 1