Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Saving columns' widths in result grid in MySQL Workbench

Each time I run a query, the columns' widths in the result grid in MySQL Workbench are reset:

enter image description here

Is there any way to prevent this? According to the bug tracker, this issue was fixed 3.5 years ago.

like image 543
Franck Dernoncourt Avatar asked Jun 19 '14 21:06

Franck Dernoncourt


People also ask

How do I pin a result grid in MySQL Workbench?

Right-click a result grid subtab to open the context menu, which appears in the figure that follows. The result grid context menu includes: Rename Tab: Customize the name (title) of this tab. Pin Tab: Pin the results tab to the result grid.

How do I show the result grid in SQL Workbench?

Here is a simple technique to get back the results grid in MySql WorkBench. Place the text cursor on a query and use the "EXPLAIN command" for the statement under the cursor. That will open the Visual Explain window. In that window you can find Results Grid.


2 Answers

Thankfuly, this annoying bug was fixed in Workbench version 6.2+. I tested it with freshly downloaded v6.2.3.12312, 64-bit.

A heads up if you're using Windows non-installer version (i.e. zip): there is a new dependency which, if missing, causes it to break upon startup: Visual C++ Redistributable. Thankfully, installer version checks for this and lets you download it first. If you're not using the installer, here's the direct link to Microsoft site: http://www.microsoft.com/en-us/download/details.aspx?id=40784.

like image 76
Saran Avatar answered Sep 20 '22 15:09

Saran


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

Other way to expand panel

enter image description here

Let me know in case if you finding difficulty.

like image 43
Gauttam Jada Avatar answered Sep 18 '22 15:09

Gauttam Jada