Prompt

Mycli provides a configurable prompt. When mycli starts up, it will use the prompt configuration found in its config file. Once mycli is running up, you can interactively change the prompt by using the prompt command.

The default prompt looks something like this: mysql user@localhost:db_name>. It is formatted using the following character sequences. The default format string is \t \u@\h:\d>.

Additional Configuration

Mycli's configuration file has an additional prompt-related option called prompt_continuation. This default to ->. This means that when a query spans more than one line, subsequent lines start with ->:

mysql user@localhost:db > SELECT first_name, last_name, date_of_birth
                       -> FROM users
                       -> WHERE

blogroll

social