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

Multiple query results and server details

ansgar posted 5 years ago in News
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.

korro posted 4 years ago
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?
korro posted 4 years ago
One more thing. Tool tip should shows after some delay, now it's pretty annoying.
ansgar posted 4 years ago
[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.
korro posted 4 years ago
Hi. In Yours scenario I have to have same query in two deferent tabs. Please consider this.

ansgar posted 4 years ago
Well in yours its also two (sub) tabs - where's the difference?
korro posted 4 years ago
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 posted 4 years ago
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.
Kuboslav posted 4 years ago
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 posted 4 years ago
Duration is logged into the lower SQL log now.

Kuboslav posted 4 years ago
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 posted 4 years ago
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 posted 4 years ago
r3506 now implements the remainder: Multiple tabs for multi result queries, e.g. a procedure call which returns 2 results.
grymhet posted 3 years ago
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 posted 3 years ago
Yes, this option has been moved to the new tab "SQL" (Maximum result sets).

grymhet posted 3 years ago
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 posted 3 years ago
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.