Menu
When I execute a script, MySQL Workbench don't show up the result grid for me to view all records. Like a below picture:
My MySQL Workbench is in version 6.3.9.
MySQL Workbench
MySQL Workbench of my friends can show like this:
My friend's MySQL Workbench
Please help me !
691
However, I noticed that you can have another tab open (within MySQL Workbench) where the result grid for the same table remains open, and then you can toggle between the two tabs (the query tab and the result grid tab) by using CTRL + TAB and CTRL + SHIFT + TAB.
The Output is located at the bottom of MySQL Workbench. Its select box includes the Action Output , History Output , and Text Output options.
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.
To edit a big table: You can right click the "Send to SQL Editor -> SELECT All Statement". Then before running, this, add a LIMIT 100 in that SELECT or a WHERE condition to filter the rows returned. You can also go to "Preferences -> SQL Editor" and mark the "Limit Rows" checkbox.
After executing the query that you want (ex: SELECT * FROM table) execute the EXPLAIN command
It will open a new panel and on the right side you can find the option to open the Result Grid.
133
UPDATE: Mysqlworkbench 6.3.10 has been released. If you have this problem, you should get the official update.
========================
Looks like this is a known bug in MySQL Workbench on High Sierra, the latest Mac OS.
It is fixed in the next version 6.3.10, but as of 10/17/17 that isn't available.
See the bug report here:
http://bugs.mysql.com/bug.php?id=87714
From the bug report, there is a user build that addresses the issue:
https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
