Multiple query results and server details

ansgar's profile image ansgar posted 14 years ago in News Permalink
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.
1 attachment(s):
  • serverdetails
[expired user #5001]'s profile image [expired user #5001] posted 14 years ago Permalink
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?
[expired user #5001]'s profile image [expired user #5001] posted 14 years ago Permalink
One more thing. Tool tip should shows after some delay, now it's pretty annoying.
ansgar's profile image ansgar posted 14 years ago Permalink
[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.
[expired user #5001]'s profile image [expired user #5001] posted 14 years ago Permalink
Hi. In Yours scenario I have to have same query in two deferent tabs. Please consider this.
ansgar's profile image ansgar posted 14 years ago Permalink
Well in yours its also two (sub) tabs - where's the difference?
[expired user #5001]'s profile image [expired user #5001] posted 14 years ago Permalink
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.
ansgar's profile image ansgar posted 14 years ago Permalink
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.
[expired user #4681]'s profile image [expired user #4681] posted 14 years ago Permalink
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!
ansgar's profile image ansgar posted 14 years ago Permalink
Duration is logged into the lower SQL log now.
[expired user #4681]'s profile image [expired user #4681] posted 14 years ago Permalink
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 ?
ansgar's profile image ansgar posted 14 years ago Permalink
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.
ansgar's profile image ansgar posted 14 years ago Permalink
r3506 now implements the remainder: Multiple tabs for multi result queries, e.g. a procedure call which returns 2 results.
[expired user #6242]'s profile image [expired user #6242] posted 12 years ago Permalink
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?
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, this option has been moved to the new tab "SQL" (Maximum result sets).
[expired user #6242]'s profile image [expired user #6242] posted 12 years ago Permalink
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?
ansgar's profile image ansgar posted 12 years ago Permalink
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.

Please login to leave a reply, or register at first.