Learn HeidiSQL Shortcuts for Windows
Most used HeidiSQL Shortcuts
| Action |
HeidiSQL Shortcut keys |
| New window |
Ctrl + N |
| New query tab |
Ctrl + T |
| Close query tab |
Ctrl + F4 |
| Copy |
Ctrl + C |
| Paste from clipboard |
Ctrl + V |
| Cut |
Ctrl + X |
| Undo |
Alt + Backspace |
| Print |
Ctrl + P |
| Refresh |
F5 |
| Full status refresh. Get full statistics to refresh on table data |
F5 |
| Select all items or text |
Ctrl + A |
| Invert selection |
Ctrl + I |
| Activate filter panel |
Ctrl + Alt + F |
| Cancel running operation |
Esc |
| Save as a text file |
Ctrl + S |
| Database tree |
Ctrl + D |
| Table filter |
Ctrl + E |
| Go to tab 1 |
Ctrl + 1 |
| Go to tab 2 |
Ctrl + 2 |
| Go to tab 3 |
Ctrl + 3 |
| Go to tab 4 |
Ctrl + 4 |
| Go to tab 5 |
Ctrl + 5 |
| Copy selected rows in the custom format |
Ctrl + Shift + C |
Tools Shortcuts
| Action |
HeidiSQL Shortcuts |
| Search selected tables for text occurrences |
Ctrl + Shift + F |
| SQL help browser |
F1 |
| Go back to the previous tab |
Ctrl + Shift + Tab |
| Go to the next tab |
Ctrl + Tab |
SQL Shortcuts
| Action |
HeidiSQL Shortcut keys |
| Execute SQL query |
F9 |
| Execute selected SQL |
Ctrl + F9 |
| Run currently focused SQL query |
Ctrl + Shift + F9 |
| Load SQL file |
Ctrl + O |
| Save SQL to a text file |
F12 |
| Save selected text to a file |
Ctrl + Shift + S |
| Clear query editor |
Ctrl + W |
| Find text |
Ctrl + F |
| Replace text |
Ctrl + R |
| Find or replace again |
F3 |
| Save SQL to the file |
Ctrl + S |
| Automatically reformat disordered SQL in active editor to make it more readable |
Ctrl + F8 |
Data Shortcuts
| Action |
HeidiSQL Shortcut keys |
| Insert row |
Insert |
| Duplicate row |
Ctrl + Insert |
| Delete selected row(s) |
Ctrl + Delete |
| Post |
Ctrl + Enter |
| Cancel Editing |
Esc |
| Clear filter editor |
Ctrl + W |
| Apply filter |
F9 |
| Reset sorting |
Alt + S |
| Show the next 1.000 rows |
Ctrl + Alt + Page Down key |
| Show all rows |
Ctrl + Alt + End |
| Set focused cell to NULL |
Ctrl + Shift + N |
| Insert SQL function call in this grid cell. E.g. NOW() |
Ctrl + F2 |
| Previous result tab |
Alt + Left Arrow key |
| Next result tab |
Alt + Right Arrow key |
SQL Editing Shortcuts
| Action |
HeidiSQL Shortcuts |
| Insert line |
Ctrl + N |
| Delete word |
Ctrl + T |
| Delete line |
Ctrl + Y |
| Delete E O L |
Ctrl + Shift + Y |
| Undo |
Ctrl + Z |
| Redo |
Ctrl + Shift + Z |
| Goto marker 0…9 |
Ctrl + 0 |
| Set marker 0…0 |
Ctrl + Shift + 0 |
| Normal select |
Ctrl + Shift + N |
| Column select |
Ctrl + Shift + C |
| Line select |
Ctrl + Shift + L |
| Match bracket |
Ctrl + Shift + B |
| Uppercase block |
Ctrl + U |
| Lowercase block |
Ctrl + L |
READ NEXT:
