Bug #65223 Autofit Results Column Widths
Submitted: 7 May 2012 14:09 Modified: 21 Aug 2014 20:40
Reporter: Larry D. Wilson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.39 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[7 May 2012 14:09] Larry D. Wilson
Description:
When running a query, it would be great if the columns in the result set expanded to the maxium width of the data in the column for that result (autofit).

I find I spend a lot of time changing column widths manually when running queries for development or production support (so much that I usually perform queries in another tool). 

 

How to repeat:
select name from mysql.time_zone_name;

Suggested fix:
Sample the maxium width before display and adjust column width accordingly.
[10 May 2012 18:21] Valeriy Kravchuk
Thank you for the feature request.
[21 Aug 2014 20:40] Philip Olson
Fixed as of the MySQL Workbench 6.2.0 release, and here's the changelog entry:

Column widths in the results view window would sometimes not fit, thus
requiring the columns to be resized manually. 

In addition to the autofit function being fixed, adjusted column widths 
are now preserved.

Thank you for the bug report.