MySQL Workbench: Vertical Query Output

October 8, 2013 – 12:12 am by Marcin Szalowicz

MySQL Workbench have one nice feature which is probably a stranger for some of us. The name of this feature is vertical query output, it help in situations where the standard Workbench output will not be very useful. This functionality is very easy to use and in this post I’ll try to visualize some of it’s benefits.

First we need to know how to use it, so we’ve provided you two options to execute the query with vertical output. One of them is the menu bar where you can find item named Execute vertically, you’ll also find hint about the shortcut for that option it’s CTRL+ALT+RETURN.

After you know how to get the vertical query output, I’ll show you some screen shots to compare it with command line output.

Let’s take the command that suits best to this type of output, it’s SHOW ENGINE INNODB STATUS. Normally to understand the output, you probably copy it to some notepad app, and add line breaks. Well it was a little annoying, especially when you know how does it look in command line client with \G. So let’s take a look for the output of console  and Workbench.

Vertical output console preview Vertical Output Workbench preview

You should find out that it’s the same view as in the console. Below you’ll see how it looks in Standard Output

vertical_output_show_engine_normal

and with Text Output.

vertical_output_show_engine_text

Here is also one more screen shot of the EXPLAIN query:

vertical_output_explain

Please fell free to comment this, and let us know how do you like it.



  1. 6 Responses to “MySQL Workbench: Vertical Query Output”

  2. Hey Guys,

    Great job with Workbench, really! But can you please fix all the chrash-bugs that been going on for ages now in various versions and platforms?

    By Lukasz Andersson on Oct 26, 2013

  3. Hi Lukasz

    What crash bugs do you mean? Are there bug reports for them? We don’t always encounter the same bugs as users, so it’s always good to file a report at http://bugs.mysql.com if you’d like to see something fixed.

    By akojima on Nov 7, 2013

  4. Is there a way to export this format?

    By Pam on Aug 19, 2014

  5. Not directly, but you can select-All and copy/paste the text.

    By akojima on Aug 20, 2014

  6. I just installed workbench and it does this by default when I run a query using ALT+Enter – how can I turn it off to just run the query and return rows as normal?

    By Darren on Aug 27, 2014

  7. Use Control-Enter instead of Alt-Enter. You can see the shortcuts in the Query menu.

    By akojima on Aug 27, 2014

Post a Comment


9 − = five