前言

朋友介绍了一个工具，mycli，支持MySQL查询语句自动补全等，这里给大家介绍一下。

大家也可以直接去官网看一下，安装使用都很简单。

安装

$ pip install -U mycli

$ brew update && brew install mycli  # Only on OS X

$ sudo apt-get install mycli # Only on debian or ubuntu

三种方式，简单到不行

登录数据库

也是三种方式，很简单

➜ mycli -h localhost -u root test

Version: 1.10.0

Chat: https://gitter.im/dbcli/mycli

Mail: https://groups.google.com/forum/#!forum/mycli-users

Home: http://mycli.net

Thanks to the contributor - Daniel Black

mysql root@localhost:test> quit

➜mycli mysql -u root

Version: 1.10.0

Chat: https://gitter.im/dbcli/mycli

Mail: https://groups.google.com/forum/#!forum/mycli-users

Home: http://mycli.net

Thanks to the contributor - Steve Robbins

➜ mycli mysql://root@localhost:3306/test

Version: 1.10.0

Chat: https://gitter.im/dbcli/mycli

Mail: https://groups.google.com/forum/#!forum/mycli-users

Home: http://mycli.net

Thanks to the contributor - Iryna Cherniavska

mysql root@localhost:test>

截图