Keyboard Shortcuts using SQL

Nic Zangre Updated by Nic Zangre

Keyboard Shortcuts in SQL

While not everyone can free-code and write SQL, it's common for non-technical ops professionals to learn "enough to be dangerous"! Advanced users in CaliberMind can actually type in or edit queries pulling tables from the Customer Data Platform.

Common Use Cases

There are some common use cases when keyboard shortcuts can save lots of time and also prevent user errors.

For example, below a user is editing SQL in a list and wishes to replace an exact match for the word "id" with "customer_id". You can see the the shortcut tool highlighted "id" on rows 6, 21, and 32 -- but the word "company_id" wasn't highlighted. To see a list of all SQL keyboard shortcuts scroll down to see the entire list of powerful hotkeys!

All CaliberMind SQL keyboard shortcuts

Line Operations

Windows/Linux

Mac

Action

Ctrl-D

Command-D

Remove line

Alt-Shift-Down

Command-Option-Down

Copy lines down

Alt-Shift-Up

Command-Option-Up

Copy lines up

Alt-Down

Option-Down

Move lines down

Alt-Up

Option-Up

Move lines up

Alt-Delete

Ctrl-K

Remove to line end

Alt-Backspace

Command-Backspace

Remove to linestart

Ctrl-Backspace

Option-Backspace, Ctrl-Option-Backspace

Remove word left

Ctrl-Delete

Option-Delete

Remove word right

---

Ctrl-O

Split line

Selection

Windows/Linux

Mac

Action

Ctrl-A

Command-A

Select all

Shift-Left

Shift-Left

Select left

Shift-Right

Shift-Right

Select right

Ctrl-Shift-Left

Option-Shift-Left

Select word left

Ctrl-Shift-Right

Option-Shift-Right

Select word right

Shift-Home

Shift-Home

Select line start

Shift-End

Shift-End

Select line end

Alt-Shift-Right

Command-Shift-Right

Select to line end

Alt-Shift-Left

Command-Shift-Left

Select to line start

Shift-Up

Shift-Up

Select up

Shift-Down

Shift-Down

Select down

Shift-PageUp

Shift-PageUp

Select page up

Shift-PageDown

Shift-PageDown

Select page down

Ctrl-Shift-Home

Command-Shift-Up

Select to start

Ctrl-Shift-End

Command-Shift-Down

Select to end

Ctrl-Shift-D

Command-Shift-D

Duplicate selection

Ctrl-Shift-P

---

Select to matching bracket

Multi cursor

Windows/Linux

Mac

Action

Ctrl-Alt-Up

Ctrl-Option-Up

Add multi-cursor above

Ctrl-Alt-Down

Ctrl-Option-Down

Add multi-cursor below

Ctrl-Alt-Right

Ctrl-Option-Right

Add next occurrence to multi-selection

Ctrl-Alt-Left

Ctrl-Option-Left

Add previous occurrence to multi-selection

Ctrl-Alt-Shift-Up

Ctrl-Option-Shift-Up

Move multicursor from current line to the line above

Ctrl-Alt-Shift-Down

Ctrl-Option-Shift-Down

Move multicursor from current line to the line below

Ctrl-Alt-Shift-Right

Ctrl-Option-Shift-Right

Remove current occurrence from multi-selection and move to next

Ctrl-Alt-Shift-Left

Ctrl-Option-Shift-Left

Remove current occurrence from multi-selection and move to previous

Ctrl-Shift-L

Ctrl-Shift-L

Select all from multi-selection

Go to

Windows/Linux

Mac

Action

Left

Left, Ctrl-B

Go to left

Right

Right, Ctrl-F

Go to right

Ctrl-Left

Option-Left

Go to word left

Ctrl-Right

Option-Right

Go to word right

Up

Up, Ctrl-P

Go line up

Down

Down, Ctrl-N

Go line down

Alt-Left, Home

Command-Left, Home, Ctrl-A

Go to line start

Alt-Right, End

Command-Right, End, Ctrl-E

Go to line end

PageUp

Option-PageUp

Go to page up

PageDown

Option-PageDown, Ctrl-V

Go to page down

Ctrl-Home

Command-Home, Command-Up

Go to start

Ctrl-End

Command-End, Command-Down

Go to end

Ctrl-L

Command-L

Go to line

Ctrl-Down

Command-Down

Scroll line down

Ctrl-Up

---

Scroll line up

Ctrl-P

---

Go to matching bracket

---

Option-PageDown

Scroll page down

---

Option-PageUp

Scroll page up

Find/Replace

Windows/Linux

Mac

Action

Ctrl-F

Command-F

Find

Ctrl-H

Command-Option-F

Replace

Ctrl-K

Command-G

Find next

Ctrl-Shift-K

Command-Shift-G

Find previous

Folding

Windows/Linux

Mac

Action

Alt-L, Ctrl-F1

Command-Option-L, Command-F1

Fold selection

Alt-Shift-L, Ctrl-Shift-F1

Command-Option-Shift-L, Command-Shift-F1

Unfold

Alt-0

Command-Option-0

Fold all

Alt-Shift-0

Command-Option-Shift-0

Unfold all

Other

Windows/Linux

Mac

Action

Tab

Tab

Indent

Shift-Tab

Shift-Tab

Outdent

Ctrl-Z

Command-Z

Undo

Ctrl-Shift-Z, Ctrl-Y

Command-Shift-Z, Command-Y

Redo

Ctrl-,

Command-,

Show the settings menu

Ctrl-/

Command-/

Toggle comment

Ctrl-T

Ctrl-T

Transpose letters

Ctrl-Enter

Command-Enter

Enter full screen

Ctrl-Shift-U

Ctrl-Shift-U

Change to lower case

Ctrl-U

Ctrl-U

Change to upper case

Insert

Insert

Overwrite

Ctrl-Shift-E

Command-Shift-E

Macros replay

Ctrl-Alt-E

---

Macros recording

Delete

---

Delete

---

Ctrl-L

Center selection

How did we do?

Where is my Segments Menu?

Contact