HeidiSQL keyboard shortcuts

HeidiSQL  

defkey.com -
7 years ago
- Shortcuts

If you frequently browse or edit databases using HeidiSQL, you may want to take advantage of these useful keyboard shortcuts.

1
Ctrl + N

New window

0
Ctrl + T

New query tab

0
Ctrl + F4

Close query tab

Advertisement

1
Ctrl + C

Copy

0
Ctrl + V

Paste from clipboard

1
Ctrl + X

Cut

2
Alt + Backspace

Undo

0
Ctrl + P

Print

-1
F5

Refresh

1
F5

Full status refresh. Get full statistics refresh on table data

1
Ctrl + A

Select all items or text

1
Ctrl + I

Invert selection

0
Ctrl + Alt + F

Activate filter panel

0
Esc

Cancel running operation

0
Ctrl + S

Save as text file

0
Ctrl + D

Database tree

0
Ctrl + E

Table filter

0
Ctrl + 1

Go to tab 1

0
Ctrl + 2

Go to tab 2

0
Ctrl + 3

Go to tab 3

0
Ctrl + 4

Go to tab 4

0
Ctrl + 5

Go to tab 5

3
Ctrl + ↑  Shift + C

Copy selected rows in custom format

0
Ctrl + ↑  Shift + F

Search selected tables for text occurences

0
F1

SQL help browser

0
Ctrl + ↑  Shift + Tab

Go back to previous tab

0
Ctrl + Tab

Go to next tab

0
Del

Delete all rows in selected table(s)

0
F9

Execute SQL query

1
Ctrl + F9

Execute selected SQL

2
Ctrl + ↑  Shift + F9

Run currently focused SQL query

0
Ctrl + O

Load SQL file

0
F12

Save SQL to a text file

0
Ctrl + ↑  Shift + S

Save selected text to a file

0
Ctrl + W

Clear query editor

0
Ctrl + F

Find text

0
Ctrl + R

Replace text

0
F3

Find or replace again

0
Ctrl + S

Save SQL to file

0
Ctrl + F8

Automatically reformat disordered SQL in active editor to make it more readable

0
Insert

Insert row

0
Ctrl + Insert

Duplicate row

0
Ctrl + Del

Delete selected row(s)

0
Ctrl + ⤶ Enter

Post

0
Esc

Cancel editing

0
Ctrl + W

Clear filter editor

0
F9

Apply filter

0
Alt + S

Reset sorting

0
Ctrl + Alt + Page Down

Show next 1.000 rows

0
Ctrl + Alt + End

Show all rows

0
Ctrl + ↑  Shift + N

Set focused cell to NULL

0
Ctrl + F2

Insert SQL function call in this grid cell. E.g. NOW()

0
Alt +

Previous result tab

0
Alt +

Next result tab

Advertisement

0
Ctrl + N

Insert line

0
Ctrl + T

Delete word

0
Ctrl + Y

Delete line

0
Ctrl + ↑  Shift + Y

Delete E O L

0
Ctrl + Z

Undo

0
Ctrl + ↑  Shift + Z

Redo

0
Ctrl + 0

Goto marker 0...9

0
Ctrl + ↑  Shift + 0

Set marker 0...0

0
Ctrl + ↑  Shift + N

Normal select

0
Ctrl + ↑  Shift + C

Column select

0
Ctrl + ↑  Shift + L

Line select

0
Ctrl + ↑  Shift + B

Match bracket

0
Ctrl + U

Uppercase block

0
Ctrl + L

Lowercase block


Share this page on:
Is this page helpful?
0 0

Program information

Program name: HeidiSQL HeidiSQL (Developer tools)

HeidiSQL is a tool designed for web developers using MySQL server, Microsoft SQL databases and PostgreSQL. It allows you to browse and edit data, create and edit tables, views, procedures, triggers and more.

Web page: heidisql.com

Last update: 1/30/2020 11:56 AM UTC

How easy to press shortcuts: 85%

More information >>

Shortcut count: 68

Platform detected: Windows or Linux

Similar programs



User operations

Add HeidiSQL to favorites

Add to favorites

Advertisement


What is your favorite HeidiSQL hotkey? Do you have any useful tips for it? Let other users know below.


 
?
Guest OP says : 3 years ago 2/17/2021 10:07 PM
What's the shortcut for commenting a line of code in the query editor?
Zeynel Admin says in reply to Guest : 3 years ago 2/17/2021 10:18 PM
In my version it's not assigned. I see a shortcut can be assigned for comment/uncomment in Preferences > Shortcuts tab > SQL > Un/comment