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

Mysql Command Line completion tool mycli

Preface

When we connect to the mysql database, we mostly use the tools of the gui graphical interface. However, sometimes it is convenient to connect to the database on the command line, so we usually need to master the basics of operating the database on the command line.

Here is an article recommended to show you the Mysql commands, which contains most of the mysql commands we need to use.

However, the default mysql command line does not support completion, and it is annoying that after we entered the wrong command, because of the command line operation habit, tmd has already exited the mysql command line tool when ctrl+c wants to cancel. You can only connect again. Commands that want to delete errors can only be deleted by ctrl+a ctrl+u. Or press ctrl+w all the time to delete.

Also, every command must end with a semicolon, and a Martha like me always forgets.

Most importantly, this thing does not support completion! People like me, how to operate the command line without completion!

Today, I saw an open source project on github called mycli. I felt very good. I installed and used it, and it was really awesome. I have overcome my fear of Mysql command line operation! Therefore, recommend it to everyone!

Installation

Official website: http://mycli.net

Github address: https://github.com/dbcli/mycli

Operation demonstration

Mac installation method

$brew update & & brew install mycli

Ubuntu installation command

Sudo apt-get install mycli

Arch installation command

Sudo pacman-S mycli

Windows is not tested and there is no windows system on hand.

Usage

$mycli-help

Usage: mycli [OPTIONS] [DATABASE]

Options:

-h,-- host TEXT Host address of the database.

-P,-port INTEGER Port number to use for connection. Honors

$MYSQL_TCP_PORT

-u,-- user TEXT User name to connect to the database.

-S,-- socket TEXT The socket file to use for connection.

-p,-- password TEXT Password to connect to the database

-- pass TEXT Password to connect to the database

-- ssl-ca PATH CA file in PEM format

-- ssl-capath TEXT CA directory

-- ssl-cert PATH X509 cert in PEM format

-- ssl-key PATH X509 key in PEM format

-- ssl-cipher TEXT SSL cipher to use

Ssl-verify-server-cert Verify server's "Common Name" in its cert

Against hostname used when connecting. This

Option is disabled by default

-v,-- version Version of mycli.

-D,-- database TEXT Database to use.

-R,-- prompt TEXT Prompt format (Default: "\ t\ u @\ h:\ d >")

-l,-- logfile FILENAME Log every query and its results to a file.

-- defaults-group-suffix TEXT Read config group with the specified suffix.

-- defaults-file PATH Only read default options from the given file

-- myclirc PATH Location of myclirc file.

-- auto-vertical-output Automatically switch to vertical output mode

If the result is wider than the terminal

Width.

-t,-- table Display batch output in table format.

-- csv Display batch output in CSV format.

-warn /-- no-warn Warn before running a destructive query.

-- local-infile BOOLEAN Enable/disable LOAD DATA LOCAL INFILE.

-- login-path TEXT Read this path from the login file.

-e,-- execute TEXT Execute query to the database.

-- help Show this message and exit.

Connect to the database

$mycli local_database

$mycli-h localhost-u root app_db

$mycli mysql://amjith@localhost:3306/django_poll

If you are proficient in using the Mysql command line, there is no problem with using this tool. If you are not proficient, using this tool can make you proficient quickly!

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.