distal-attribute
distal-attribute
distal-attribute
distal-attribute

Multiple query results and server details

User, date Message
Written by ansgar
4 years ago
Category: News
4784 posts since Fri, 07 Apr 06
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.

Written by korro
4 years ago
4 posts since Tue, 22 Jun 10
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?
Written by korro
4 years ago
4 posts since Tue, 22 Jun 10
One more thing. Tool tip should shows after some delay, now it's pretty annoying.
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
[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.
Written by korro
4 years ago
4 posts since Tue, 22 Jun 10
Hi. In Yours scenario I have to have same query in two deferent tabs. Please consider this.
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Well in yours its also two (sub) tabs - where's the difference?
Written by korro
4 years ago
4 posts since Tue, 22 Jun 10
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.
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
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.
Written by Kuboslav
4 years ago
4 posts since Thu, 04 Feb 10
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!
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Duration is logged into the lower SQL log now.
Written by Kuboslav
4 years ago
4 posts since Thu, 04 Feb 10
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 ?
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
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.
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
r3506 now implements the remainder: Multiple tabs for multi result queries, e.g. a procedure call which returns 2 results.
Written by grymhet
2 years ago
2 posts since Wed, 22 Feb 12
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?
Written by ansgar
2 years ago
4784 posts since Fri, 07 Apr 06
Yes, this option has been moved to the new tab "SQL" (Maximum result sets).
Written by grymhet
2 years ago
2 posts since Wed, 22 Feb 12
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?
Written by ansgar
2 years ago
4784 posts since Fri, 07 Apr 06
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.