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?

score 94 · Answer 1 · edited Aug 02 '18 at 15:33

94

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

edited Aug 02 '18 at 15:33

hg8

1,082
2
15
28

answered Jun 19 '15 at 12:48

Robi Wan Kenobi

1,441
1
10
10

9

Just want to add that this function will not work if statement is invalid. – Marosinho Sep 19 '17 at 06:59
You can also mark your answer as correct ... that way others can quickly see, that this questions has a correct answer – Kazschuri May 30 '18 at 11:30
Is there a way to configure the Beautify to keep comments? – Shahar Sep 23 '19 at 23:12
God bless you! :) – Eggon Jan 10 '21 at 13:56

score -1 · Answer 2 · answered Mar 21 '21 at 22:10

-1

Now there is a simple icon (looks like a brush) Just click it and wa-la... your ugly SQL is now a work of art. Take a screenshot of it and sell it as a NFT on opensea.io :)

answered Mar 21 '21 at 22:10

Pip

1,062
8
6

MySQL Workbench > Plugins > Utilities > Reformat SQL Query

2 Answers2

Linked