Hotkeys and shortcuts for HeidiSQL

(Total 59)

Ctrl + N
SQL editing
Insert line
Ctrl + T
SQL editing
Delete word
Ctrl + F4
File
Close query tab
Ctrl + C
Various shortcuts
Copy
Ctrl + V
Various shortcuts
Paste from clipboard
Ctrl + X
Various shortcuts
Cut
Alt + ⬅ Backspace
Various shortcuts
Undo
Ctrl + P
Various shortcuts
Print
F5
Various shortcuts
Full status refresh. Get full statistics refresh on table data
Ctrl + A
Various shortcuts
Select all items or text
Ctrl + I
Various shortcuts
Invert selection
Ctrl + Alt + F
Various shortcuts
Activate filter panel
Esc
Data
Cancel editing
Ctrl + S
SQL
Save SQL to file
Ctrl + D
Various shortcuts
Database tree
Ctrl + E
Various shortcuts
Table filter
Ctrl + 1
Various shortcuts
Go to tab 1
Ctrl + 2
Various shortcuts
Go to tab 2
Ctrl + 3
Various shortcuts
Go to tab 3
Ctrl + 4
Various shortcuts
Go to tab 4
Ctrl + 5
Various shortcuts
Go to tab 5
Ctrl + ↑   Shift + C
SQL editing
Column select
Ctrl + ↑   Shift + F
Tools
Search selected tables for text occurences
F1
Tools
SQL help browser
Ctrl + ↑   Shift + ⭾ Tab
Tools
Go back to previous tab
Ctrl + ⭾ Tab
Tools
Go to next tab
Del
Database
Delete all rows in selected table(s)
F9
Data
Apply filter
Ctrl + F9
SQL
Execute selected SQL
Ctrl + ↑   Shift + F9
SQL
Run currently focused SQL query
Ctrl + O
SQL
Load SQL file
F12
SQL
Save SQL to a text file
Ctrl + ↑   Shift + S
SQL
Save selected text to a file
Ctrl + W
Data
Clear filter editor
Ctrl + F
SQL
Find text
Ctrl + R
SQL
Replace text
F3
SQL
Find or replace again
Ctrl + F8
SQL
Automatically reformat disordered SQL in active editor to make it more readable
Insert
Data
Insert row
Ctrl + Insert
Data
Duplicate row
Ctrl + Del
Data
Delete selected row(s)
Ctrl + ⤶ Enter
Data
Post
Alt + S
Data
Reset sorting
Ctrl + Alt + Page Down
Data
Show next 1.000 rows
Ctrl + Alt + End
Data
Show all rows
Ctrl + ↑   Shift + N
SQL editing
Normal select
Ctrl + F2
Data
Insert SQL function call in this grid cell. E.g. NOW()
Alt + ←
Data
Previous result tab
Alt + →
Data
Next result tab
Ctrl + Y
SQL editing
Delete line
Ctrl + ↑   Shift + Y
SQL editing
Delete E O L
Ctrl + Z
SQL editing
Undo
Ctrl + ↑   Shift + Z
SQL editing
Redo
Ctrl + 0
SQL editing
Goto marker 0...9
Ctrl + ↑   Shift + 0
SQL editing
Set marker 0...0
Ctrl + ↑   Shift + L
SQL editing
Line select
Ctrl + ↑   Shift + B
SQL editing
Match bracket
Ctrl + U
SQL editing
Uppercase block
Ctrl + L
SQL editing
Lowercase block