Muchikamu chinotevera tichaenda kunotarisa mycli. Tevere tichaona kuisirwa muUbuntu kweizvi MySQL mutengi weiyo terminal. Izvo zvakanyorwa muPython uchishandisa raibhurari Python Inokurumidza Toolkit uye mu se inosanganisira Autocompletion uye syntax kujekesa. Ichashanda neMySQL, MariaDB uye Percona dhatabhesi dhatabhesi.
Uyu mutengi anozonyanya kubatsira kana zvasvika kune nyora mibvunzo yakaoma nyore uye nekukurumidza pasina kurangarira iyo yese mubvunzo syntax. Ichazopa vashandisi mukana wekushandisa iyo REPL (Verenga, Eval, Dhinda, Loop) iyo inozoonekwa mumamenyu ezve zano patinongotanga kutaipa.
Zvakajairika maficha e mycli
Mycli chishandiso chemutsetse wekushandisa ye MySQL, MariaDB uye Percona uye inotsigira anotevera mabasa:
- Ngatisanganei ne Autocomplete uye yakakwana yepamusoro kana yepasi kesi. Tichingotanga kutaipa mirairo, izvi zvinozotanga kutamba.
- Zvigadzire-woga uchinyora SQL keywords, pamwe nematafura, maonero, uye makoramu mudhatabhesi.
- Zvinyorwa zvakanaka zve tabular data maunogona kuona mavara. Sezvatinonyora mibvunzo yedu, tichaona kuti mazwi akachengetedzwa achave neruvara rumwe chete, asi iyo data uye ichimisikidza imwe. Izvi zvinobvumidza vashandisi kukurumidza uye nyore kuona uye kuongorora mibvunzo yatinoita kuDB.
- Uyu mutengi ari kuzotipa rutsigiro mitsara-yakawanda mibvunzo.
- Support for SSL / TLS kubatana.
- Tichava nemukana we ponesa mibvunzo yedu vadikani. Tichakwanisawo kuchengeta mhedzisiro yako mufaira. Aya mashandiro akaremara nekutadza asi isu tinogona kuimisa nekugadzirisa iyo configuration file, inowanikwa mu ~ / .myclirc.
- Zvose zvinyorwa isu tichakwanisa kuvawana mufaira ~ / .mycli.log.
- Tichawana rutsigiro rwekukwanisa kushandisa madingindira akasiyana siyana.
- Inoshanda nemazvo Unicode yekuisa / kuburitsa.
Izvi ndizvo zvimwe zvezvinhu zvaro. Tichakwanisa kuwana maficha ayo ese pane rake GitHub peji.
Isa mycli pane Ubuntu
Kuisa MySQL CLI, i.e. mycli, isu taizoda system inomhanya python 2.7+ kana 3.4+. Neichi chikonzero isu tichafanirwa kuve nechokwadi chekuti yedu Ubuntu system ine Python yakaiswa. Kana isu tisina mutauro uyu, kuti tiuise, ita unotevera kuraira mune terminal (Ctrl + Alt + T):
sudo apt install python
Kana izvo zvataurwa pamusoro zvazadzikiswa, mycli ine mapakeji anowanikwa mupakeji maneja zvinyorwa yeiyo system. Tichakwanisa kushandisa inotevera script kuisa uyu mutengi:
sudo apt update && sudo apt install mycli
Imwe yekumisikidza sarudzo ichave yekushandisa Pip. Kuisa mycli uchishandisa iyi Python package maneja, iwe unofanirwa kungo nyora mune iyo terminal (Ctrl + Alt + T):
sudo pip3 install mycli
Mushure mekumisikidzwa, isu tichakwanisa tarisa iyo vhezheni yeakaisa mutengi nemirairo inotevera:
mycli -v
Kutanga, tichakwanisa kubatanidza tichishandisa rairo sezvakaratidzwa pasi apa:
sudo mycli
Ziva kuti iwo mazano anoenderana nemamiriro ezvinhu zvichienderana nechinzvimbo chechituko. Semuenzaniso: matafura chete ndiwo anokurudzirwa mushure meKUSVIRA wezwi rakakosha uye chete mazita emakoramu anokurudzirwa mushure meCHIPO chikamu.
Rubatsiro
Kuwana iyo rondedzero yemirairo yese inogona kushandiswa ne mycli, zvese zvaunofanirwa kuita kumhanya unotevera kuraira kwekubatsira mune iyo terminal:
mycli --help
Para dzidza zvakawanda nezve kushandisa mycli, vashandisi vanogona kubvunza iyo zvinyorwa zvepamutemo inopihwa pawebsite yeprojekti.
Muchidimbu, mycli yakanaka yevatengi-parutivi chishandiso icho chinoita kupfupisa nguva yekunyora mibvunzo mune iyo terminal nekuti icharatidza tafura nekoramu mazita patinonyora mubvunzo. Kana paine munhu anofarira, zvinofanirwa kutaurwa izvozvo kune zvakare chishandiso chakaenzana chemaposi ane zita pgcli iyo yakagadziriswa naAmjith.