Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench > Plugins > Utilities > Reformat SQL Query

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?

like image 845
Robi Wan Kenobi Avatar asked Jun 19 '15 12:06

Robi Wan Kenobi


People also ask

How do I format a SQL query in MySQL workbench?

The Workbench allows you to format an SQL query into a new SQL tab and click the “Beautify/reformat the SQL script” button.

How do I edit a DDL in MySQL workbench?

You can add or modify the columns or indexes of a table, change the engine, add foreign keys, or alter the table name. To access the MySQL Table Editor, right-click a table name in the Navigator area of the sidebar with the Schemas secondary tab selected and click Alter Table.


1 Answers

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

like image 159
Robi Wan Kenobi Avatar answered Sep 27 '22 00:09

Robi Wan Kenobi