MySQL Workbench > Plugins > Utilities > Reformat SQL Query

mysql plugins workbench utilities reformatting
Robi Wan Kenobi picture Robi Wan Kenobi · Jun 19, 2015 · Viewed 19.7k times · Source

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?

Answer

Robi Wan Kenobi picture Robi Wan Kenobi · Jun 19, 2015

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

Related questions

Is there a way to store Mosquitto payload into an MySQL database for history purpose?

I am using Mosquitto MQTT broker and I would like to store every published message into a MySQL database without creating a client and subscribing to # wildcard. I found this https://github.com/jpmens/mosquitto-auth-plug but my english is not …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More