Performing a custom query

To perform a custom MySQL query, you must first open a MySQL tab, connect to a server, and select a database. To learn how to do these things, see Managing MySQL databases.

Once connected to a database, click Custom Query in the left sidebar of the MySQL tab. The custom query view will appear.

Type any valid SQL query into the text area and press return to execute it. (If you actually need to insert a return character into the text area, press option-return.) Alternatively, you can click Run Query . Table names and SQL keywords will autocomplete if you press Esc.

The result of the query, as well as its execution time will be displayed in the banner beneath the text area.

If the query returns table rows, those will be displayed in the table in the bottom half of the tab.

See also: Managing MySQL tables.