MySQL, MariaDB y IPercona bathathu yolwazi esetshenziswa kabanzi namuhla, ezimbili zokuqala zifakwe kumaphesenti amakhulu wezinhlelo zokusebenza zomthombo ovulekile ezikhona namuhla. Kungakho kubalulekile ukuthi ube ne- ukuphela kwe-MySQL, i-MariaDB ne-Percona lokho kusivumela ukuthi siphathe kahle le mininingwane, kusuka kubuntofontofo nobulula i-console esinikeza bona.
Ngalesi sikhathi sizohlangana ne-mycli, i-database egcina imininingwane enezimpawu ezidingekayo zokuphatha kahle imininingwane yethu, ngaphandle kokusebenzisa izinsiza ezinehaba kanye nemibhalo ebanzi esinayo.
Yini i-mycli?
mycli iyithuluzi lomthombo ovulekile, elenzelwe i- Python, esivumela ukuthi siphathe futhi sisebenzise imiyalo ye-MySQL, MariaDB, ne-Percona ngendlela esheshayo, ezenzakalelayo futhi esebenza kahle. Ithuluzi linehlelo lokuqedela ukuqedela okuzenzakalelayo kwezilimi ezisezingeni elishiwo ngenhla, ngendlela efanayo, ligqamisa i-syntax ngendlela ejwayelekile, okusisiza ukuphatha imininingwane yethu ngendlela entofontofo evela esigungwini.
Inentambo yokufaka nokufunda emfushane impela, engeze kuzici zayo ezinhle kakhulu iyenza ibe yinto ethandeka kakhulu kumathuluzi anikezelwe ekuphathweni kwedatha, ikakhulukazi ngenxa yokusebenzisa kwayo izinsizakusebenza nesikhathi sayo sokuphendula esisheshayo.
Ukusetshenziswa okuningiliziwe kwethuluzi kungabonakala ku-gif elandelayo ekhishwe onjiniyela bethuluzi:
Izici zeMycli
- Umthombo ovulekile ngokuphelele, owenziwe nge-python nangemibhalo emihle kakhulu.
- Qedela ngokuzenzakalela njengamagama angukhiye we-SQL athayiphiwe, kanye namatafula e-database, ukubukwa, namakholomu.
- I-syntax enhle kakhulu egqamisa ukubonga kumaPygment.
- Ukuqedela okuzenzakalelayo kwe-Smart (okunikwa amandla ngokuzenzakalela), okuzonikeza kuphela iziphakamiso ezihlobene nokuqukethwe.
SELECT * FROM <tab>kuzokhombisa kuphela amagama wamatafula.SELECT * FROM users WHERE <tab>izokhombisa kuphela amagama ekholamu.
- Ukusekelwa kwemibuzo efaka ngaphezu komugqa owodwa.
- Ivumela ukugcina imibuzo esetshenziswe kakhulu, ngoba lokhu kwanele ukugcina umbuzo usebenzisa i-
\fs alias querybese usebenzisa umyalo olandelayo\f aliaslapho ufuna ukuyiqhuba futhi. - Inamandla futhi ilula ifayela lokumisa, elenziwa ngokuzenzakalela enkombeni
~/.myclirc - Inesistimu ye-log ebanzi, uma kwenzeka sifuna ukugcina umlando wemiyalo ekhishiwe.
- Masisebenzise ukuhlehlisa okuhle.
- Okukhishwa kwedatha kuhlelekile futhi kumnandi, kukhonjiswa kumakholomu ahlukaniswe ngamathebula.
- Inokusekelwa kokuxhumeka kwe-SSL.
- Imibhalo eningiliziwe lapho usebenzisa usizo lwethuluzi
$ mycli --help - Abanye abaningi ngaphezulu.
Ungayifaka kanjani i-mycli
Singafaka i-mycli kunoma iyiphi i-Linux distro sibonga i-python, ngoba lokhu kufanele nje sifake ipayipi bese sisebenzisa umyalo olandelayo:
$ sudo pip install -U mycliAbasebenzisi be-Debian nabakwa-Ubuntu bangafaka ithuluzi ngqo kusuka kumakhosombe asemthethweni ngokusebenza
$ sudo apt-get install mycliNgokunjalo, i-Arch Linux nabasebenzisi abasuselwa kokunye bangalijabulela leli thuluzi ngenxa yezinqolobane ze-AUR, ukwenza lokhu, ukwenza lo myalo olandelayo:
$ yaourt -S mycli
Ukuphetha, ngifuna ukugcizelela ukuthi ezivivinyweni ezenziwayo, ithuluzi liziphathe ngokushesha ngokweqile futhi isiphakamiso salo uma kukhulunywa ngokuqedela okuzenzakalelayo kuhle kakhulu. Ngize ngicabange ukuthi leli thuluzi lisebenziseka nje nge-MySQL Navigator ngenzuzo yokuthi lisebenzisa izinsiza ezingaphansi kakhulu, uma ungumthandi wekhonsoli futhi usebenzisa eminye imininingwane emithathu ehambelana nayo, unganqikazi ukuzama leli thuluzi elihle futhi usitshele okuvelayo mayelana.