MySQL命令行自動完成和補全的小工具是什么

小編給大家分享一下MySQL命令行自動完成和補全的小工具是什么，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

創(chuàng)新互聯(lián)致力于互聯(lián)網(wǎng)品牌建設(shè)與網(wǎng)絡(luò)營銷，包括成都網(wǎng)站設(shè)計、做網(wǎng)站、SEO優(yōu)化、網(wǎng)絡(luò)推廣、整站優(yōu)化營銷策劃推廣、電子商務(wù)、移動互聯(lián)網(wǎng)營銷等。創(chuàng)新互聯(lián)為不同類型的客戶提供良好的互聯(lián)網(wǎng)應(yīng)用定制及解決方案，創(chuàng)新互聯(lián)核心團隊十年專注互聯(lián)網(wǎng)開發(fā)，積累了豐富的網(wǎng)站經(jīng)驗，為廣大企業(yè)客戶提供一站式企業(yè)網(wǎng)站建設(shè)服務(wù)，在網(wǎng)站建設(shè)行業(yè)內(nèi)樹立了良好口碑。

MySQL的命令行客戶端工具mycli，可以實現(xiàn)命令行自動完成補全和語法突出顯示。

主頁: http://mycli.net

文檔: http://mycli.net/docs

安裝方法：

# 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.3.0,>=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 cffi!=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 cffi!=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:

- 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

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

***************************[ 1. row ]***************************

id | 281730

name | <null>

***************************[ 2. row ]***************************

id | 448833

name | <null>

***************************[ 3. row ]***************************

id | 441833

name | <null>

***************************[ 4. row ]***************************

id | 686905

name | <null>

***************************[ 5. row ]***************************

id | 392884

name | <null>

5 rows in set

Time: 1.311s

mysql>

說明：

mycli命令后面必須用-D跟數(shù)據(jù)庫名，否則會報錯：

(1049, "Unknown database

命令幫助信息：

# 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.

以上是“MySQL命令行自動完成和補全的小工具是什么”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

網(wǎng)站標題：MySQL命令行自動完成和補全的小工具是什么
文章鏈接：http://muchs.cn/article6/iiogig.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供搜索引擎優(yōu)化、定制開發(fā)、網(wǎng)站營銷、移動網(wǎng)站建設(shè)、靜態(tài)網(wǎng)站、App設(shè)計

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容