Editor Basics
Last updated
Was this helpful?
Last updated
Was this helpful?
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:
Click Cancel
button on the Query Editor
Or navigate to menu Connection
> Process List...
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...