Multiple query results and server details

User, date Message
User: anse
Posted: Sat, 29 May 10 13:08
Category: News
1821 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.
User: korro
Posted: Tue, 22 Jun 10 12:40
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?
User: korro
Posted: Tue, 22 Jun 10 12:42
4 posts since Tue, 22 Jun 10 		One more thing. Tool tip should shows after some delay, now it's pretty annoying.
User: anse
Posted: Tue, 22 Jun 10 12:59
1821 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.
User: korro
Posted: Tue, 22 Jun 10 14:14
4 posts since Tue, 22 Jun 10 		Hi. In Yours scenario I have to have same query in two deferent tabs. Please consider this.
User: anse
Posted: Tue, 22 Jun 10 14:26
1821 posts since Fri, 07 Apr 06 		Well in yours its also two (sub) tabs - where's the difference?
User: korro
Posted: Wed, 23 Jun 10 22:48
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.
User: anse
Posted: Thu, 24 Jun 10 11:06
1821 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.
User: Kuboslav
Posted: Fri, 02 Jul 10 11:40
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!
User: anse
Posted: Fri, 02 Jul 10 12:12
1821 posts since Fri, 07 Apr 06 		Duration is logged into the lower SQL log now.
User: Kuboslav
Posted: Fri, 02 Jul 10 12:20
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 ?
User: anse
Posted: Fri, 02 Jul 10 12:35
1821 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.
User: anse
Posted: Sun, 29 Aug 10 01:36
1821 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.
 

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