- Preface and Legal Notices
- 1 MySQL Workbench Introduction
- 2 MySQL Workbench Editions
- 3 Installing and Launching MySQL Workbench
- 4 Getting Started Tutorial
- 5 The Home Window
- 6 SQL Development
- 7 Data Modeling
- 8 Generating code overview
- 9 Server Administration
- 10 Database Migration Wizard
- 11 Extending Workbench
- 12 Keyboard Shortcuts
- 13 MySQL Utilities
- 13.1 Preface
- 13.1.1 Preface
- A Third Party Licenses
- B MySQL Workbench FAQ
- C MySQL Workbench and Utilities Change History
The following tables list keyboard shortcuts for MySQL Workbench commands. Modifier in the tables stands for the platform-specific modifier key. This is Command on Mac OS X, Control on other platforms. On Mac OS X, the Alt key is Option.
There are keyboard shortcut tables for the File, Edit, View, Arrange, Model, Query, Database, Scripting, Help, and EER Diagram Mode menus.
File Menu
Table 12.1. File menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| New Model | Modifier+N | All |
| Open Model | Modifier+O | All |
| Open SQL Script | Modifier+Shift+O | SQL Editor |
| Close Tab | Modifier+W, Modifier+F4 on Windows | All |
| Save Model | Modifier+S | Model |
| Save Script | Modifier+S | SQL Editor |
| Save Model As | Modifier+Shift+S | Model |
| Save Script As | Modifier+Shift+S | SQL Editor |
| Forward Engineer SQL CREATE Script | Modifier+Shift+G | Model |
| Forward Engineer SQL ALTER Script | Modifier+Alt+Y | Model |
| Synchronize With SQL CREATE Script | Modifier+Shift+Y | Model |
| Modifier+P | EER Diagram mode only | |
| Exit | Modifier+Q | All |
Edit Menu
Table 12.2. Edit menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Undo | Modifier+Z | Model, EER Diagram |
| Redo | Modifier+Y, Modifier+Shift+Z (Mac OS X) | Model, EER Diagram |
| Cut | Modifier+X | All |
| Copy | Modifier+C | All |
| Paste | Modifier+V | All |
| Delete | Modifier+Delete, Command+BackSpace (Mac OS X) | All |
| Edit Selected | Modifier+E | Model, EER Diagram |
| Edit Selected in New Window | Modifier+Shift+E | Model, EER Diagram |
| Select All | Modifier+A | EER Diagram |
| Find | Modifier+F | All |
| Find Advanced | Modifier+Alt+F | All |
| Find Next | F3 | All |
| Find Previous | Shift+F3 | All |
| Search and Replace | Modifier+Shift+F | All |
| Comment/Uncomment lines of SQL | Modifier+/ | SQL Editor |
| Auto-Complete SQL | Modifier+Space | SQL Editor |
View Menu
Table 12.3. View menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Output Window | Modifier+F2, Modifier+Option+2 (Mac OS X) | All |
| Set Marker n | Modifier+Shift+n (n is integer 1..9) | EER Diagram |
| Go to Marker n | Modifier+n (n is integer 1..9) | EER Diagram |
Arrange Menu
Table 12.4. Arrange menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Bring to Front | Modifier+Shift+F | EER Diagram |
| Send to Back | Modifier+Shift+B | EER Diagram |
Model Menu
Table 12.5. Model menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Add Diagram | Modifier+T | Model, EER Diagram |
| Validate All | Modifier+Alt+V | Model, EER Diagram |
| Validate All (MySQL) | Modifier+Alt+B | Model, EER Diagram |
| Model Options | Command+Alt+, (Shortcut available only on Mac OS X) | Model, EER Diagram |
Query Menu
Table 12.6. Query menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Execute statement | Modifier+Return | SQL Editor |
| Execute statements | Modifier+Shift+Return | SQL Editor |
| New Tab | Modifier+T | SQL Editor |
Database Menu
Table 12.7. Database menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Query Database | Modifier+U | All |
| Reverse Engineer | Modifier+R | Model, EER Diagram |
| Forward Engineer | Modifier+G | Model, EER Diagram |
| Synchronize Model | Modifier+Y | Model, EER Diagram |
Scripting Menu
Table 12.8. Scripting menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Scripting Shell | Modifier+F3, Modifier+Option+3 (on Mac OS X) | All |
| Run Workbench Script File | Modifier+Shift+R | All |
Help Menu
Table 12.9. Help menu keyboard shortcuts
| Function | Keyboard Shortcut | Context |
|---|---|---|
| Help Index | F1, Command+Option+question (on Mac OS X) | All |
EER Diagram Mode
In the EER Diagram view, a number of other keyboard shortcuts are available.
Table 12.10. EER diagram mode keyboard shortcuts
| Function | Keyboard Shortcut |
|---|---|
| Selection tool | Escape |
| Hand tool | H |
| Delete tool | D |
| Layer tool | L |
| Note tool | N |
| Image tool | I |
| Table tool | T |
| View tool | V |
| Routine Group tool | G |
| Non-Identifying Relationship 1:1 | 1 |
| Non-Identifying Relationship 1:n | 2 |
| Identifying Relationship 1:1 | 3 |
| Identifying Relationship 1:n | 4 |
| Identifying Relationship n:m | 5 |
| Relationship Using Existing Columns | 6 |
Table 12.11. Keyboard shortcut changes
| MySQL Workbench version | The Change |
|---|---|
| 5.2.45 | The "Modifier+/" shortcut was added to comment/uncomment SQL in the SQL editor |
| 5.2.45 | On Microsoft Windows, the "Modifier+W" shortcut was changed to "Control+F4" -- this shortcut closes MySQL Workbench tabs |
User Comments
Add your own comment.