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!
This entry was posted in Databases
. Bookmark the permalink