Multiple query results and server details

After having updated to the latest build via Help > "Check for updates" you will be able to see more than only the result of the last SELECT query in any "Query" tab. By default, HeidiSQL displays up to 10 result sets in subtabs. In case you want more just go to

Tools > Preferences > Data

and increase this value in Maximum number of query results. Different than before, these are the first result sets from your SQL code.



Please note that HeidiSQL still does not separate multiple results from a stored procedure. Will be the next thing to implement soon.

Also a minor new feature is the hint on the lower statusbar when hovering over the MySQL version. You will see various connection, server and client related details here.

Hi, it would be nice to have possibility to run same query and see result in another tab. For example, i run some query (F9) and after 1 hour i want to compare current result with previous. It can be some other shortcut to run query and put results in new tab. What do You thing about this?

One more thing. Tool tip should shows after some delay, now it's pretty annoying.

[quote=korro]It can be some other shortcut to run query and put results in new tab[/korro]
I don't think that should be solved with these sub tabs which are meant to be transient somehow, should disappear when you execute the next command.

You should just open a new main query tab by hitting Ctrl+T, paste the query and press F9. After that you can compare by pressing Ctrl+Tab and Ctrl+Shift+Tab.

Hi. In Yours scenario I have to have same query in two deferent tabs. Please consider this.

Well in yours its also two (sub) tabs - where's the difference?

In my opinion tab and subtabs aren't comparable. Nature of subtab is to be less important than tab. If you don't want to include my opinion in code, fine. I'm just suggesting functionality which can be helpful in my daily life as programmer.

It's not that I don't want to make it easier, I just don't see that this makes anything easier, while it would require quite some complex code changes. So I decide to leave it as it is, giving the advice to use main tabs for comparing.

Multiple queries and displaying result sets are good improvement, but i don't understand why there aren't display duration of query/ies - I'm missing it!

Duration is logged into the lower SQL log now.

„Duration is logged into the lower SQL log now.“
Yes, I noticed that, but I think it's annoying to look into log (I use resized log viewer - small).
What lead you to remove duration info from there ?

As you may have noticed there is one sub tab for each query result now. Each tab has a hint which displays its original query + col/row count, these details are both per query. To avoid stealing even more vertical space the query summary (affected rows, duration) is displayed in the log now.

r3506 now implements the remainder: Multiple tabs for multi result queries, e.g. a procedure call which returns 2 results.

In my version of Heidi SQL (7.0.0.4058) I cannot find any option with the name "Maximum number of query results" under "Tools > Preferences > Data". Has this option been removed or can I simply find it somewhere else?

Yes, this option has been moved to the new tab "SQL" (Maximum result sets).

Thank you very much for your prompt feedback. I checked the SQL tab and found the feature. However, "Maximum result sets" is set to 10, but still I do not get more than one result tab, even if I execute the same query again and again and again...
Is there any other setting that I have to change in order to make this work?

Hehe, you only get more tabs when there are more results for *one* F9/Run press. This is the case if you have two SELECTs separated by semicolon, or if you call a procedure which returns multipe results.