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

Editor to share with you what the MySQL command line automatic completion and completion of the gadget is, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

MySQL command line client tool mycli, can achieve automatic completion of the command line and syntax highlighting.

Home page: http://mycli.net

Documentation: http://mycli.net/docs

Installation method:

# pip install-U mycli

Collecting mycli

Downloading https://files.pythonhosted.org/packages/f9/8a/9f96f12b482ff2e1bbb1d4252e14b4a24ed37daa5b1dcd14c3d990eca9dd/mycli-1.19.0-py2.py3-none-any.whl (56kB)

100% | ██ | 61kB 27kB/s

Collecting PyMySQL > = 0.9.2 (from mycli)

Downloading https://files.pythonhosted.org/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl (47kB)

100% | ██ | 51kB 11kB/s

Collecting sqlparse=0.2.2 (from mycli)

Downloading https://files.pythonhosted.org/packages/65/85/20bdd72f4537cf2c4d5d005368d502b2f464ede22982e724a82c86268eda/sqlparse-0.2.4-py2.py3-none-any.whl

Collecting configobj > = 5.0.5 (from mycli)

Downloading https://files.pythonhosted.org/packages/64/61/079eb60459c44929e684fa7d9e2fdca403f67d64dd9dbac27296be2e0fab/configobj-5.0.6.tar.gz

Collecting cryptography > = 1.0.0 (from mycli)

Downloading https://files.pythonhosted.org/packages/97/18/c6557f63a6abde34707196fb2cad1c6dc0dbff25a200d5044922496668a4/cryptography-2.7-cp34-abi3-manylinux1_x86_64.whl (2.3MB)

100% | ██ | 2.3MB 1.3MB/s

Collecting cli-helpers [styles] > = 1.0.1 (from mycli)

Downloading https://files.pythonhosted.org/packages/51/53/d94bb9cd98cd996da6eeea82a077293cd62b825d89a36d3c27714cae5e5b/cli_helpers-1.2.1-py3-none-any.whl

Collecting Pygments > = 1.6 (from mycli)

Downloading https://files.pythonhosted.org/packages/5c/73/1dfa428150e3ccb0fa3e68db406e5be48698f2a979ccbcec795f28f44048/Pygments-2.4.2-py2.py3-none-any.whl (883kB)

100% | ██ | 890kB 1.5MB/s

Collecting prompt-toolkit > = 2.0.6 (from mycli)

Downloading https://files.pythonhosted.org/packages/f7/a7/9b1dd14ef45345f186ef69d175bdd2491c40ab1dfa4b2b3e4352df719ed7/prompt_toolkit-2.0.9-py3-none-any.whl (337kB)

100% | ██ | 337kB 1.5MB/s

Collecting click > = 4.1 (from mycli)

Using cached https://files.pythonhosted.org/packages/fa/37/45185cb5abbc30d7257104c434fe0b07e5a195a6847506c074527aa599ec/Click-7.0-py2.py3-none-any.whl

Collecting six (from configobj > = 5.0.5-> mycli)

Downloading https://files.pythonhosted.org/packages/73/fb/00a976f728d0d1fecfe898238ce23f502a721c0ac0ecfedb80e0d88c64e9/six-1.12.0-py2.py3-none-any.whl

Collecting cffidates 1.11.3, > = 1.8 (from cryptography > = 1.0.0-> mycli)

Downloading https://files.pythonhosted.org/packages/5f/bf/6aa1925384c23ffeb579e97a5569eb9abce41b6310b329352b8252cee1c3/cffi-1.12.3-cp36-cp36m-manylinux1_x86_64.whl (430kB)

100% | ██ | 440kB 1.5MB/s

Collecting asn1crypto > = 0.21.0 (from cryptography > = 1.0.0-> mycli)

Using cached https://files.pythonhosted.org/packages/ea/cd/35485615f45f30a510576f1a56d1e0a7ad7bd8ab5ed7cdc600ef7cd06222/asn1crypto-0.24.0-py2.py3-none-any.whl

Collecting tabulate [widechars] > = 0.8.2 (from cli-helpers [styles] > = 1.0.1-> mycli)

Downloading https://files.pythonhosted.org/packages/c2/fd/202954b3f0eb896c53b7b6f07390851b1fd2ca84aa95880d7ae4f434c4ac/tabulate-0.8.3.tar.gz (46kB)

100% | ██ | 51kB 5.7MB/s

Collecting terminaltables > = 3.0.0 (from cli-helpers [styles] > = 1.0.1-> mycli)

Downloading https://files.pythonhosted.org/packages/9b/c4/4a21174f32f8a7e1104798c445dacdc1d4df86f2f26722767034e4de4bff/terminaltables-3.1.0.tar.gz

Collecting wcwidth (from prompt-toolkit > = 2.0.6-> mycli)

Downloading https://files.pythonhosted.org/packages/7e/9f/526a6947247599b084ee5232e4f9190a38f398d7300d866af3ab571a5bfe/wcwidth-0.1.7-py2.py3-none-any.whl

Collecting pycparser (from cffidates 1.11.3, > = 1.8-> cryptography > = 1.0.0-> mycli)

Using cached https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz

Installing collected packages: PyMySQL, sqlparse, six, configobj, pycparser, cffi, asn1crypto, cryptography, wcwidth, tabulate, terminaltables, Pygments, cli-helpers, prompt-toolkit, click, mycli

Running setup.py install for configobj... Done

Running setup.py install for pycparser... Done

Running setup.py install for tabulate... Done

Running setup.py install for terminaltables... Done

Successfully installed PyMySQL-0.9.3 Pygments-2.4.2 asn1crypto-0.24.0 cffi-1.12.3 cli-helpers-1.2.1 click-7.0 configobj-5.0.6 cryptography-2.7 mycli-1.19.0 prompt-toolkit-2.0.9 pycparser-2.19 six-1.12.0 sqlparse-0.2.4 tabulate-0.8.3 terminaltables-3.1.0 wcwidth-0.1.7

You are using pip version 18.1, however version 19.1.1 is available.

You should consider upgrading via the 'pip install-- upgrade pip' command.

[root@test1 20190626] #

Examples of use:

Examples:

-mycli my_database

-mycli-u my_user-h my_host.com my_database

-mycli mysql://my_user@my_host.com:3306/my_database

# mycli-uroot-p-D test-h 192.168.16.150

Password:

Mysql 5.7.24-log

Mycli 1.19.0

Chat: https://gitter.im/dbcli/mycli

Mail: https://groups.google.com/forum/#!forum/mycli-users

Home: http://mycli.net

Thanks to the contributor-Dick Marinus

Mysql root@192.168.16.150:test > select * from

Aaa

Dsf

Dsf_old

Peihy

Sq_prebycollecttime

T

T1

Mysql > select * from dsf order by rand () limit 5\ G

* * [1. Row] * *

Id | 281730

Name |

* * [2.row] * *

Id | 448833

Name |

* * [3. Row] * *

Id | 441833

Name |

* * [4. Row] * *

Id | 686905

Name |

* * [5. Row] *

Id | 392884

Name |

5 rows in set

Time: 1.311s

Mysql >

Description:

The mycli command must be followed by-D and the database name, otherwise an error will be reported:

(1049, "Unknown database"

Command help information:

# mycli-help

Usage: mycli [OPTIONS] [DATABASE]

A MySQL terminal client with auto-completion and syntax highlighting.

Examples:

-mycli my_database

-mycli-u my_user-h my_host.com my_database

-mycli mysql://my_user@my_host.com:3306/my_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.

-- ssh-user TEXT User name to connect to ssh server.

-- ssh-host TEXT Host name to connect to ssh server.

-- ssh-port INTEGER Port to connect to ssh server.

-- ssh-password TEXT Password to connect to ssh server.

-ssh-key-filename TEXT Private key filename (identify file) for the

Ssh connection.

-- 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 Output mycli's version.

-v,-- verbose Verbose output.

-D,-- database TEXT Database to use.

-d,-- dsn TEXT Use DSN configured into the [alias_dsn]

Section of myclirc file.

-- list-dsn list of DSN configured into the [alias_dsn]

Section of myclirc file.

-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 MySQL config groups with the specified

Suffix.

-- defaults-file PATH Only read MySQL 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 command and quit.

-- help Show this message and exit.

These are all the contents of this article entitled "what are the gadgets for MySQL command line completion and completion?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.