MySQL Bugs: #65223: Autofit Results Column Widths

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

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.

Thank you for the feature request.

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.