Mycli介紹
Mycli是一個(gè)MySQL命令行客戶(hù)端工具，是一個(gè)印度人基于python寫(xiě)的一個(gè)工具，其最先發(fā)布的版本是pgcli（PostgreSQL客戶(hù)端）。那個(gè)時(shí)候我就下載使用過(guò)感覺(jué)還不錯(cuò)，當(dāng)然安裝過(guò)程也是出了很多問(wèn)題，后來(lái)跟作者請(qǐng)教過(guò)才搞定（不要問(wèn)我怎么溝通的，你懂的）。當(dāng)時(shí)mycli還沒(méi)有出來(lái)，國(guó)內(nèi)都是使用MySQL大部分，當(dāng)然就請(qǐng)?jiān)副M快出MySQL的版本，相信還有很多其他人請(qǐng)?jiān)浮?015年底mycli終于出來(lái)了，幾番嘗試后也成功安裝了mycli，也就有了下面的文章供參考。
mycli具有語(yǔ)法高亮以及自動(dòng)完成鍵入SQL關(guān)鍵字及數(shù)據(jù)庫(kù)列表顯示，具體特性如下：
Mycli基于prompt_toolkit和python編寫(xiě)而來(lái)；
自動(dòng)完成鍵入 SQL關(guān)鍵字以及數(shù)據(jù)庫(kù)列表；
使用Pygments語(yǔ)法高亮顯示；
`Smart-completion(默認(rèn)啟用)上下文；
SELECT * FROM <tab> 只顯示table名；
SELECT * FROM users WHERE <tab> 只顯示column名；
在配置文件中自動(dòng)創(chuàng)建~/.pglirc·
支持tab自動(dòng)補(bǔ)全
安裝mycli
pip install mycli
如果出現(xiàn)如下警告
warning: GMP or MPIR library not found; Not building Crypto.PublicKey._fastmath.
centos下的解決辦法:
yum install gmp-devel -y
出錯(cuò)信息
src/MD2.c:31:20: error: Python.h: No such file or directory src/MD2.c:131: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token In file included from src/MD2.c:147: src/hash_template.c:48: error: expected specifier-qualifier-list before ‘PyObject_HEAD’ src/hash_template.c:59: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘PyTypeObject’ src/hash_template.c: In function ‘newALGobject’: src/hash_template.c:69: warning: implicit declaration of function ‘PyObject_New’ src/hash_template.c:69: error: expected expression before ‘ALGobject’ src/hash_template.c: At top level: src/hash_template.c:76: error: expected ‘)’ before ‘*’ token src/hash_template.c:91: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:110: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:122: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:162: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:188: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:190: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘ALG_methods’ src/hash_template.c:199: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:225: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘ALGtype’ src/hash_template.c:271: error: expected ‘=’, ‘,’, ‘;’, ‘a(chǎn)sm’ or ‘__attribute__’ before ‘*’ token src/hash_template.c:304: error: array type has incomplete element type src/hash_template.c:305: error: ‘PyCFunction’ undeclared here (not in a function) src/hash_template.c:305: error: expected ‘}’ before ‘ALG_new’ src/hash_template.c: In function ‘init_MD2’: src/hash_template.c:339: error: ‘PyObject’ undeclared (first use in this function) src/hash_template.c:339: error: (Each undeclared identifier is reported only once src/hash_template.c:339: error: for each function it appears in.) src/hash_template.c:339: error: ‘m’ undeclared (first use in this function) src/hash_template.c:351: error: ‘ALGtype’ undeclared (first use in this function) src/hash_template.c:351: error: ‘PyType_Type’ undeclared (first use in this function) src/hash_template.c:352: warning: implicit declaration of function ‘Py_InitModule’ src/hash_template.c:356: error: ‘o’ undeclared (first use in this function) src/hash_template.c:356: warning: implicit declaration of function ‘PyInt_FromLong’ src/hash_template.c:356: warning: implicit declaration of function ‘PyDict_SetItemString’ src/hash_template.c:356: warning: implicit declaration of function ‘PyModule_GetDict’ src/hash_template.c:356: warning: implicit declaration of function ‘Py_DECREF’ src/hash_template.c:360: warning: implicit declaration of function ‘PyErr_Occurred’ src/hash_template.c:361: warning: implicit declaration of function ‘Py_FatalError’ error: command 'gcc' failed with exit status 1 ---------------------------------------- Rolling back uninstall of pycryptoCommand "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-5qio8g/pycrypto/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-qRQy4P-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-build-qio8g/pycrypto/
解決辦法:
yum install python-devel -y
參考文章:http://www.ywnds.com/?p=2840http://www.linuser.com/thread-1378-1-1.html
