MyCLI is a control tool for MySQL & MariaDB allowing auto-completion and help to syntax of your SQL command.

Installation

We install management tools of Python packages in order to use pip then we install mycli :

apt-get update

### Debian/Ubuntu
apt-get install python-pip
apt-get install python3-pip
pip install mycli

### CentOS/RHEL/Fedora
yum install python-pip python-devel
pip install mycli

###MacOS
brew update
brew install mycli

Use

We connect to MySQL via mycli through one of these following methods :

mycli -u root -h localhost
mycli -u root -h localhost name_base
mycli mysql://root@localhost:3306/name_base

mysql root@localhost:(none)>

From mycli view, any SQL requests will be highlighted and auto-completed even if there is a syntax error (as ; final).

Auto-completion operates with key words and SQL functions, names from data base and tables.

Alias can be handled as well as the columns of your tables if it is specified like the following example :

The result of your requests is identically shaped as the command less :

mysql root@localhost:name_base> SELECT * FROM name_table
+------+------------+------------+------------+------------+
| id   |  column1   |  column2   |  column3   |  column4   |
|------+------------+------------+------------+------------|
+------+------------+------------+------------+------------+
0 rows in set
Time: 0.004s