Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about how to use mycli, a command line tool for database operation. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

GitHub can be described as a variety of artifacts have, today found an operation of the database command line tool, can automatically complete and syntax highlighting, in the past in the terminal knock SQL, you not only have to remember table names, field names, a variety of functions need to be remembered to knock out a complete statement, otherwise it is the first Google Baidu documents.

With mycli as a command line aid, it's a lot easier to worry about. You can take a look at the effect picture first:

If you don't try, you may not feel so strongly, so you might as well try it yourself. Normally, you can install it directly with the pip command.

Pip install mycli

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

$sudo yum install python-pip

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

Connect to the database, and mysql operates in the same way:

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 using sql input, the only difference is that every time you type in a character, there is an automatic prompt, keywords are highlighted, and multiple prompts can be selected by switching up and down through the Tab key.

Seeing here, you should try it yourself.

After reading the above, do you have any further understanding of how to use the database operation command line tool mycli? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.