Mycli Multi-line Mode

The default behavior of mycli is to execute a query as soon as the enter key is pressed. 

To emulate the original MySQL behavior you can enable the multi-line mode which will require a semi-colon to be present at the end of the line. This enables writing multi-line queries if they are really long. You can enable multi-line mode by pressing <F3> key or set it permanently via the config file.

# Multi-line mode allows breaking up the sql statements into multiple lines. If
# this is set to True, then the end of the statements must have a semi-colon.
# If this is set to False then sql statements can't be split into multiple
# lines. End of line (return) is considered as the end of the statement.
multi_line = False

Comments