MySQL Workbench Query Preferences

Question

We recently upgraded our MySQL Workbench environment from 5.2 to 6.1.

It works fine, but every query seems to default to columns that are tiny, so that the result of every query has me opening up each column so I can see the data.

When we had 5.2, the columns would make an attempt to fill the viewing window.

Does anyone know how to fix this behavior in the many settings that Workbench has?

I tried asking this with an account I have had for a while on MySQL Forums :: MySQL Workbench, but the system says I am not authorized to post or reply to topics there.

Answer 1

There seems to be a bug tracker with this issue open :

http://bugs.mysql.com/bug.php?id=72332

Open a SQL editor to a server and execute a query that returns some text fields, the columns don't autofit to a reasonable width to display as much as they can (or set in the Preferences as I believe 256 bytes..). Instead they are displayed in a super narrow table taking 1/20 of the screen width.

It seems to have changed with 6.1

Subscribe to updates! And roll back to 6.0.8 ;-)

Answer 2

seems like there is a way to do it with the wrap cell contents

see documentation. http://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html