SQL editor
SQL editor
The SQL editor is a full CodeMirror 6 editor with the MySQL dialect and autocomplete for your databases, tables and columns.
#Running queries
| Shortcut | Action |
|---|---|
⌘/Ctrl + Enter |
Run the statement under the cursor |
Shift + ⌘/Ctrl + Enter |
Run every statement |
⌘/Ctrl + K |
Open the command palette |
Each statement's result opens in its own tab, using the same data grid as the table browser.
#Limits that keep you safe
- Row cap. Results stop at the row cap (1,000 by default). For the full result, use CSV export.
- Timeout.
SELECTs are stopped by MySQL after the query timeout (30 s by default, viamax_execution_time). - Cancel. A long-running query can be cancelled from the editor; DBNova runs
KILL QUERYon its connection. - One statement per call. Multi-statements are turned off at the driver, so a statement can't smuggle in another.
Each user can adjust the row cap and timeout under Settings → Preferences, within the maximums set by the administrator.
#History and saved queries
Every query you run is kept in your history panel. Save a query from your history to keep it and run it again later.