1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
*************
Key Bindings:
*************
Most key bindings are simply inherited from `prompt-toolkit <https://python-prompt-toolkit.readthedocs.io/en/master/index.html>`_ .
The following key bindings are special to mycli:
###
F2
###
Enable/Disable SmartCompletion Mode.
###
F3
###
Enable/Disable Multiline Mode.
###
F4
###
Toggle between Vi and Emacs mode.
###
Tab
###
Force autocompletion at cursor.
#######
C-space
#######
Initialize autocompletion at cursor.
If the autocompletion menu is not showing, display it with the appropriate completions for the context.
If the menu is showing, select the next completion.
#########
ESC Enter
#########
Introduce a line break in multi-line mode, or dispatch the command in single-line mode.
The sequence ESC-Enter is often sent by Alt-Enter.
##################
C-x p (Emacs-mode)
##################
Prettify and indent current statement, usually into multiple lines.
Only accepts buffers containing single SQL statements.
##################
C-x u (Emacs-mode)
##################
Unprettify and dedent current statement, usually into one line.
Only accepts buffers containing single SQL statements.
##################
C-o d (Emacs-mode)
##################
Insert the current date at cursor, defined by NOW() on the server.
####################
C-o C-d (Emacs-mode)
####################
Insert the quoted current date at cursor.
##################
C-o t (Emacs-mode)
##################
Insert the current datetime at cursor.
####################
C-o C-t (Emacs-mode)
####################
Insert the quoted current datetime at cursor.
|
