Shulou(Shulou.com)05/31 Report--

This article is about the sample analysis of mycli in the mysql database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

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.

Thank you for reading! This is the end of this article on "sample Analysis of mycli in mysql Database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.