mycli---数据库工具(提示、自动补全)

前言

朋友介绍了一个工具,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>

截图

mycli---数据库工具(提示、自动补全)