In MS Query Analyzer you can press Ctrl+R to hide the results section, making your query window bigger and saving on scrolling up and down
Is there a keyboard shortcut in MySQL Workbench v6.2 to do this? I can't find it
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.
Figure 8.5 SQL Editor - Result Grid Context Menu Pin Tab: Pin the results tab to the result grid. Executing additional SQL statements will create new result grid tabs. Close Tab: Close this tab.
The Output is located at the bottom of MySQL Workbench. Its select box includes the Action Output , History Output , and Text Output options.
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.
I will share my own trick (not so nice): I mark one new line (or some spaces), after that, I "execute" that empty query with shift-ctrl-enter
so the empty query generates an empty resultset and the grid is then hidden.
No, there is no shortcut to hide the result set for an sql editor. You only can use the close button in the tab title or run a query that doesn't return a result set.
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