Keyboard shortcuts

The default key map is described below. If you are using Mac, use Cmd instead of Ctrl.

Keycode Action
Ctrl-A Select all
Ctrl-Home Go to the start of the document
Ctrl-Left Go to stat of the line
Ctrl-Backspace Delete to beginning of line
Ctrl-F Find
Ctrl-G Find next
Ctrl-U Undo selection
Ctrl-Alt-F Search / Replace
Alt-F Go to word right
Ctrl-V Page down
Alt-D Delete world right
Ctrl-Space Autocomplete
Tab Indent more
Shift-Tab Indent less
Esc Exit full screen
Ctrl-S Save to a local file
Ctrl-E Execute SQL
Ctrl-M (Sublime Text Ctrl-Alt-M), same in Mac Insert myDBR command


Simple macros can be defined in mydbr/user/defaults.php. Following macros have been defined in mydbr/defaults.php

Keycode Action
Ctrl-Alt-S select-clause
Ctrl-I if-clause
Ctrl-Alt-I if-else-clause
Ctrl-Alt-W while-clause

Autocomplete table columns

The editor performs autocompletion to complete the SQL table / view columns. To take advantage of this, use the editor preferences mark the databases which are to be autocompleted. To get the suggestions, create first select query with a from-clause and use either the table name or the table alias in the select-line.