GitHub can be described as a variety of artifact have, today found a command line operation database tool, can automatically complete and syntax highlighting, before the terminal type SQL, you not only have to remember the table name, field name, all kinds of functions need to remember to knock out a complete statement to, otherwise is the first Google Baidu search document.
And with myCLI this command line assistance tool, a lot of worry. You can take a look at the renderings:
If you don’t try it yourself, you may not feel so strongly, so you might as well try it yourself. Normally this can be installed with the PIP command
pip install mycli
Copy the codeIf the installation is wrong, please refer to the official documentation, or upgrade your PIP tool, I need to upgrade PIP in CentOS environment to normal installation
$ sudo yum install python-pip
Copy the codeMycli supports multiple platforms, including Windows, macOS, and Linux. How do you use it? Mycli completely inherits the parameters from mysql commands, so there is no learning cost.
Mysql > connect to a database
mycli -u your_user_name -h your_host -p your_password --database your_db_name
Copy the code
After successfully connecting to the database, the operation is the same as when using SQL input, the only difference is that each character is automatically prompted, the keyword is highlighted, and multiple prompts can be switched up and down by the Tab key to select different items.
Why don’t you try it yourself?
Blog at foofish.net
