2

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?

2

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 Jul 9 '17 at 14:07
  • No, that's not possible. – Mike Lischke Jul 9 '17 at 15:05
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.