To open the query editor, click on the query editor button on top of the left panel, or use the shortcut key
⌘ + Return, or
⌘ + E.
To execute a query from the Query Editor, select the query and click on the Run Current button, or use shortcut key
⌘ + Return.
TablePlus also supports writing and executing multiple queries, you’ll need to separate them with a semicolon.
To execute multiple queries, select them in the Query Editor and click on the dropdown next to Run Current button, choose Run All, or use the shortcut key
⌘ + ⇧ + Return.
You can change the default Execute button from Run Current to Run All from the same dropdown.
When executing a long running queries and you need to stop it midway through, you can do it via the process list:
Cancelbutton on the Query Editor
- Or navigate to menu
- Or use the shortcut keys
⌘ + .
From the Process List, you can see all the running queries, select the query and click Kill to cancel it.
To export a queries from the Query Editor, click on the dropdown menu next the the Run button and choose
Save SQL as...