MySQL Workbench > Plugins > Utilities > Reformat SQL Query

Question

At some point I installed MySQL Workbench 5.2.47 Revision 10398. This version has the feature to reformat an SQL query located at:

Plugins > Utilities > Reformat SQL Query

I like this feature and I use it almost every day.

Now every newer version I downloaded from http://dev.mysql.com/downloads/workbench/ misses this feature.

How do I get it back?

hg8 · Accepted Answer · 2018-08-02 15:33:29Z

103

Just answering my own question. I found the feature by accident. It was moved and renamed to and is now located here:

Edit > Format > Beautify Query

Shortcut: Ctrl+B

hg8

1,1182 gold badges16 silver badges29 bronze badges

answered Jun 19, 2015 at 12:48

Robi Wan Kenobi

1,5912 gold badges10 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Just want to add that this function will not work if statement is invalid.

The feature does not work for complex statements such as CREATE PROCEDURE.