使用 mycli

1. 使用 mycli 登入 mysql。

   [root@kvm3 ~]# mycli -uroot -p123123
   Connecting to socket /var/lib/mysql/mysql.sock, owned by user mysql
   MariaDB 10.11.11
   mycli 1.39.1
   Home: http://mycli.net
   Bug tracker: https://github.com/dbcli/mycli/issues
   Thanks to the contributor - Lennart Weller
   MariaDB root@(none):(none)>
   
   
   
    [F3] Multiline: OFF    Right-arrow to complete suggestion
   

2. 下命令 show 加空白就會出現提示視窗，列出可以接的參數供您選擇，不用再把完整命令打完。

   MariaDB root@(none):(none)> show
                                     AUTHORS
                                     BINARY LOGS
                                     BINLOG EVENTS
                                     CHARACTER SET
                                     CLIENT_STATISTICS
                                     COLLATION
                                     COLUMNS
   
    [F3] Multiline: OFF    Right-arrow to complete suggestion
   

3. 選擇 databases 後執行。

   MariaDB root@(none):(none)> show DATABASES;
   +--------------------+
   | Database           |
   +--------------------+
   | information_schema |
   | mysql              |
   | performance_schema |
   | sys                |
   +--------------------+
   
   4 rows in set
   Time: 0.024s
   mariadb root@localhost:(none)>