MySQL Workbench “Clean up SQL” Feature

I was playing around with MySQL Workbench earlier in the week, here and ran across the clean up SQL feature, find which I thought was neat. Heres a picture-based demonstration you can click on the pictures to make them bigger, search so they are more readable.

Here is a typical complex query that looks pretty good formatted in the results from a performance schema query:

Simply click the broom icon and watch as your SQL is cleaned up, with one field in the SELECT per line and the JOINs indented and formatted prettily:

Pretty cool, for just the click of a button!

Comments are closed.