Display column widths in MySQL Query browser

"Richard Cunningham" <[email protected]> Sat, 24 Jun 2006 23:04:55 +0100
Newsgroups gmane.comp.db.mysql.mycc
Message-ID <000801c697da$3f7d7890$0200a8c0@DININGXP>
How can I control the displayed column widths in the "result set" tab?

I don't need help with the column width in the "create table" SQL, I know about that.  I have found that taking a substring of the column in the query (eg "select left(col,10) from..." can work, but it's a nuisance, unpredictable, and clutters up the 'real' SQL.

I can grab the column edges in the top of the tab where the column titles are, and move them to left and right.  But, each time I re-run a query the old column widths return.  Many are too long to be convenient and make use of the Query Browser somewhat annoying.

I want to set a display width for a column so that the width in the result tab is always a convenient length.  I feel that this is something that the Query browser should have features for, but I can't find them in searching any of the browser, its help, the MySQL web pages, or the public lists.

I could suggest some sort of comments mixed in the SQL (eg "select description /* # width 50 pixels */ from..."), or perhaps right-clicking on the list of column names at the RHS and having a control for the width via a windows menu.  However, the second does not give any control to expressions in the select statement (as in eg "select price / quantity as price_each from...)

For the record, I am using:
MySQL Query Browser version 1.1.20
On Windows XP Home Edition, SP2
Under the GPL.

Thanks,

Richard Cunningham