A brief introduction to the command line tool mycli for operating MySQL database

GitHub has all kinds of magic tools. Today I found a command line tool for operating databases, which can automatically complete and highlight syntax. In the past, when typing SQL in the terminal, you not only had to remember the table name and field name, but also various functions to type out a complete statement, otherwise you had to Google Baidu to check the document first.

With the mycli command line auxiliary tool, I can save a lot of trouble. You can first look at the effect diagram:

If you don’t try it yourself, the feeling may not be so strong, so you might as well try it yourself. Under normal circumstances, you can install it directly using the pip command

pip install mycli

If the installation goes wrong, you can refer to the official documentation, or upgrade your pip tool. I need to upgrade pip to install it normally in the CentOS environment.

$ sudo yum install python-pip

mycli supports multiple platforms, including Windows, macOS, and Linux. How to use it? mycli completely inherits the parameters in the mysql command, so there is no learning cost.

Connect to the database, mysql also does this:

mycli -u your_user_name -h your_host -p your_password --database your_db_name 

After successfully connecting to the database, the operation is the same as usual when using SQL input. The only difference is that there will be an automatic prompt for each character typed, the keywords are highlighted, and multiple prompt items can be switched up and down by pressing the Tab key to select different items.

Why not try it yourself?

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.