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


Popular posts from this blog

Fixed Windows warning: agent returned different signature type ssh-rsa (expected rsa-sha2-512)

How to install/renew SSL Certificate for Glassfish