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