How To Create More Than 1 Results Window

[Mike_123]

I started using Sqlyog with MySQL and it's looking quite good. The one thing I can't understand is how to have more than 1 Results window open at a time. If I press Ctrl+T another query tab opens but when I run the query, the results will replace the existing results window. I need to have 2 or more results windows open at a time. How can I do this without opening another connection?

TIA

Mike

[peterlaursen]

You need to write the two (or more) queries in the same query window like

Code:

show databases;
show variables;

or

Code:

show databases; show variables;

and presse 'execute all' (double green arrow or Shift+f5) and each. Now each query will open a tab.

We have plans to add a feature to 'lock'/'unlock' a result tab but it will take some months.

[Mike_123]

peterlaursen wrote on Nov 23 2006, 12:34 AM:

You need to write the two (or more) queries in the same query window like

Code:

show databases;
show variables;

or

Code:

show databases; show variables;

and presse 'execute all' (double green arrow or Shift+f5) and each. Now each query will open a tab.

We have plans to add a feature to 'lock'/'unlock' a result tab but it will take some months.

The queries are executed at different times, so I wouldn't want to execute them together. Let's say for example I want to find all invoices over $1000. I run that query in one window (Window #1). I now want to look at the invoice details for each of those invoices so I open up another query window (Window #2) and manually do a Select on each InvoiceNum to get the details. And I do this repetively for each Invoice that was displayed in window #1. Well, if both queries share the same Results window, then I lose the results of the first query. I don't really want to rerun query#1 each time I run Query#2.

So all I'm saying is each Results window should be tied to each query window. It would also be nice if we could detach them from the tab so we can look at the Results of 2 or more windows at the same time. The only way around this right now is to run 2 or more copies of Sqlyog and that seems like overkill.

Mike

[peterlaursen]

Quote:

The queries are executed at different times, so I wouldn't want to execute them together.

You won't have to execute all the queries.

There are 2 options: 'execute' and 'execute all'. 'execute all' executes all queries on a tab, 'execute' only executes the one where the cursor is positioned.

As said we do plan to ame a RESULT tab 'sticky' or 'locked' but we have a few months work with other isssues before we can pay attention to that.

[Author]

Posts