Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench not displaying query results

When I query a table in MySQL Workbench, no results are shown, the result section is just blank, no grid or anything. However if I export the data, it is all there. Everything worked fine until a couple days ago.

Query settings:

  • Max Length = 65536
  • Continue on SQL Script Error = true
  • "Safe Updates = true
  • Leave autocommit mode enabled = true
  • Progress status update interval = 500
  • Default algorithm for ALTER table = Default
  • Default lock for ALTER table = Default
  • Limit Rows = true
  • Limit Rows Count = 1000
  • Max Field Value Length to Display = 256
  • Treat BINARY/VARBINARY as nonbinary character string = false
  • Confirm Data Changes = True

No queries work, an example would be SELECT * FROM database.address

enter image description here

like image 463
jjmirks Avatar asked Jul 14 '14 14:07

jjmirks


People also ask

How do I display output in SQL workbench?

The Output is located at the bottom of MySQL Workbench. Its select box includes the Action Output , History Output , and Text Output options.

How do I enable the result grid in MySQL 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.

How do you display a query result?

You have the option of displaying your query results on the Run SQL window, as opposed to Data Display windows. To do this, go to View > Data Grid (Ctrl+G). Once you have selected this option, a panel will appear at the bottom of the window - your query results will be displayed there.

How do I view a query in MySQL Workbench?

To do that, first select the desired database from the left column menu by double-clicking it. Then type in the MySQL query you want to run in the text field in the middle of the program window and use the yellow lightning button above that text field to run the query.


2 Answers

New to MySql myself and found this is happening on Windows as well. Goto Query > Explain Current Statement > click on the Results Grid icon on the far right of the Visual Explain window that shows by default. You may have to toggle through the up down arrow icons to see it.

like image 45
rob23 Avatar answered Sep 22 '22 17:09

rob23


This is a known bug: link. Upcoming release 6.2.2 fixes this for OS X (Unfortunately, Linux version is still broken).

At least on my computer it's not dissapeared, just folded, and it's edge is almost merged with the edge of 'Action Output' block. When you move your mouse to that edge, the cursor starts looking like a dash with two arrows. Slowly move it couple of pixels higher until you catch the small 1px area where the cursor changes to a dash with a single arrow. Then catch it and pull : )

I've made a couple of photos to illustrate this.

Step 1Step 2Step 3

like image 200
Thaumant Avatar answered Sep 22 '22 17:09

Thaumant