Bug #35290 Please add column auto-adjust-width to Query Browser
Submitted: 14 Mar 2008 11:57 Modified: 19 Sep 2008 10:12
Reporter: David Goodine Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S4 (Feature request)
Version:1.2.12 OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: query browser, UI

[14 Mar 2008 11:57] David Goodine
Description:
Currently, the Query Browser uses a fixed column width for result sets.  This often leads to a significant amount of excess horizontal whitespace and the need to scroll horizontally to see results.  One can adjust the column sizes manually, but then re-executing the query resets the column sizes and you're back to square one.

How to repeat:
Do a query.

Suggested fix:
Add a feature to allow column widths to be automatically resized based on the max length of each column's results.  This should probably be clamped to a (user-specified) max value to prevent TEXT columns from blowing out the window.

The option should be allowed to be activated automatically after each query, or perhaps manually by the user for specific queries.
[15 May 2008 3:28] Charles Thompson
I second this request. In many other applications, a double-click a column's right border adjusts the column's width to fit the data it contains. It seems possible that this feature could be added without adding much complexity to the overall application.
[16 Sep 2008 15:04] Susanne Ebrecht
Verified as described by using Query Browser version 1.2.12
[19 Sep 2008 10:12] Susanne Ebrecht
This is a duplicate of bug #18574
[19 Sep 2008 11:21] Susanne Ebrecht
This is a duplicate of bug #11461
[29 Nov 2008 9:31] sql coder
I use the query browser to write and refine queries, and I like it straightaway.
(Ok, the help menu isn't working, but I figure I can re-install at some point and hopefully that will have been fixed.)

I'd like to add to this request. This is a feature available in other tools, it's disappointing to see this was requested years ago and still isn't there. It's very irritating to resize the columns so that they are all visible, tweak one or two characters in a 50 line sql statement and then lose all the column settings when I re-run the query.

My suggestion is to add an option to remember column sizes based on the name of the column. Something like:

X  No column resizing
X  Remember column sizes
   X  Permanently (settings saved when Query Browser closed)
   X  Separate sizes for each Resultset Tab
X  Autofit column sizes to retrieved data

The 3 main options would be radio buttons, so mutually exclusive.
The 2 detailed tickboxes would only appear if the "Remember Column Sizes" option was chosen. 

This would give users the option to turn the feature on if they want.

Meanwhile I'll go and check out the other tools people have suggested ...

- sqlcoder