Multiple result tabs for multiple queries

[expired user #6302]'s profile image [expired user #6302] posted 12 years ago in Running SQL scripts Permalink
Is there a way to run various queries and be able to see the results in many tabs bellow. So far can only see one result from a query at a time!

It seems like it is there somewhere...just can't find it...feels like I'm missing something obvious...

Can anyone help me find this feature? - Thanks!
[expired user #6302]'s profile image [expired user #6302] posted 12 years ago Permalink
I see there is a possibility for query tabs...just not bellow...I get that...

Just would like to see different queries opened at the same time, lined up next to each other...

Is that possible?
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, a result tabs is opened for each result-query, up to a configurable maximum which is by default 10. Just do it - run multiple commands in one go:
SELECT 1; SELECT 2; SELECT 3
[expired user #6302]'s profile image [expired user #6302] posted 12 years ago Permalink
Got it! thanks,

Just a thought...it would be easy to visually compare data if more than one result-query tab(/window) could be open.

Is there a way to do that? could that be a helpful feature?

Thanks for a great software!
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, you can open two HeidiSQL instances. No way to have two grids displayed at once inside one instance.
[expired user #6302]'s profile image [expired user #6302] posted 12 years ago Permalink
Thinking that this would be a nice feature to have. For me it would save me tons of time comparing multiple queries.

Can this be implemented in some future HeidiSQL update?

Not to trouble you much, it's a great software as is...

Or perhaps there is a way to do so using queries?

Thanks!
ansgar's profile image ansgar posted 12 years ago Permalink
I guess this is too much effort for a feature which is already usable with two Heidi instances. However, even if there was some side-by-side grid viewer, that would not be a good comparison logic. I can instead recommend doing an SQL export and then compare SQL files with Beyond Compare, which is a fantastic text comparison tool with support for various file formats, including SQL.
[expired user #6302]'s profile image [expired user #6302] posted 12 years ago Permalink
Thanks for the tips! at first didn't get the 'two instances' mentioned before ...got it now...surprised

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