===================================
Sequel Pro 1.1.2 keyboard shortcuts
===================================

First published at 2/12/2021 on
https://defkey.com/sequel-pro-1-1-2-shortcuts

Sequel Pro is a free and open-source database management software for
macOS. It works with MySQL and MariaDB databases.

Sequel Pro 1.1.2 has 85 shortcuts and we have listed all of them below.



Main Tabs
---------

Cmd + 1                 Table Structure
Cmd + 2                 Table Content
Cmd + 3                 Table Relations
Cmd + 4                 Table Info
Cmd + 5                 Custom Query
Cmd + 6                 Table Triggers


General Shortcuts
-----------------

Cmd + N                 New Window (Connection File)
Cmd + T                 New Tab(Connection File)
Shift + Cmd + A         Add Connection To Favorites
Cmd + O                 Open (Connection File or SQL File)
Option + Cmd + O        Open current Connection File in New Window
Cmd + S                 Save (Connection File)
Shift + Cmd + S         Save As (Connection File)
Control + Cmd + S       Save Query
Cmd + W                 Close (Connection File)
Option + Cmd + W        Close All (Connection File)
Cmd + P                 Print
Shift + Cmd + I         Import
Shift + Cmd + K         Show Console Window
Cmd + K                 Clear Console
Control + Option + Left arrow Back in History
Control + Option + Right arrow Forward in History
Control + Tab           Select Next Tab
Control + Shift + Tab   Select Previous Tab
Control + Shift + N     Insert NULL value
Shift + Cmd + C         Copy Create Table Syntax
Option + Cmd + S        Show Create Table Syntax
Shift + Cmd + R         Refresh Databases
Shift + Cmd + D         Choose Database
Shift + Cmd + V         Show Server Variables
Option + Cmd + P        Show Server Processes
Control + Cmd + R       Refresh Tables
Shift + Cmd + F         Flush Privileges
Cmd + U                 User Accounts…
Cmd + C                 Copy selection / Copy selected row(s)
Option + Cmd + C        Copy selected row(s) with column names
Control + Option + Cmd + C Copy selected row(s) as SQL INSERT
Shift + Cmd + T         Show/Hide Toolbar
Control + Cmd + F       Filter Table Content
Control + Option + Cmd + F Filter Tables
Control + Option + Cmd + B Bundle Editor
Control + Option + Cmd + N Navigator


Select
------

Control + W             Select current word
Control + L             Select current line
Shift + Cmd + B         Select enclosing brackets
Cmd + A                 Select all


Table Structure Tab
-------------------

Option + Cmd + A        Add a new field
Backspace               Delete selected field
Cmd + D                 Duplicate selected field
Cmd + R                 Refresh table structure
Cmd + 4                 Edit table details


Table Content Tab
-----------------

Option + Cmd + A        Add a new row
Backspace               Delete selected row(s)
Cmd + D                 Duplicate selected row
Cmd + R                 Refresh table contents


Custom Query Tab
----------------

Version 1.0 and later:

Option + Cmd + R        Run all queries
Enter                   Run current query or selection
Cmd + R                 Run current query or selection

Versions 0.9.9.1 and earlier:

Enter                   Run all queries
Cmd + R                 Run all queries
Option + Cmd + R        Run current query or selection
Cmd + [                 Shift line or selection rightwards
Cmd + ]                 Shift line or selection leftwards
Cmd + /                 (Un)Comment line or selection
Option + Cmd + /        (Un)Comment current query
Esc                     Completion (narrow-down list / fuzzy search)
Enter                   Insertion of an item
Tab                     Insertion of an item
Double click            Insertion of an item
Shift + Enter           Insertion full schema reference
Shift + Tab             Insertion full schema reference
Double click            Insertion full schema reference
Control                 (hold down when inserting) Keep Window Open after Insertion
Control + Esc           Fuzzy Search
Esc                     Close Window
F5                      Spell Checker Completion (narrow-down list)
Control + Y             Select current query
Control + H             Show MySQL help for current word or selection
Option + Cmd + F        Open query favorites popup menu
Option + Cmd + Y        Open query history popup menu
Control + Up arrow      Insert previous history item (successively)
Control + Down arrow    Insert next history item (successively)
Option + Cmd + 1        Show all database names as completion list
Option + Cmd + 2        Show all table and view names as completion list
Option + Cmd + 3        Show all table names from current database as completion list

Last modified on (UTC): Friday, February 12, 2021
Defkey © All rights reserved.