Kwinqaku elilandelayo siza kujonga i-mycli. Okulandelayo siza kubona ukufakwa ku-Ubuntu koku Umthengi we-MySQL kwisiphelo sendlela. Kubhaliwe kwiPython kusetyenziswa ithala leencwadi Isixhobo sePython Prompt Toolkit nakwi se kubandakanya ukugqibezela kunye nokuqaqanjiswa kwes syntax. Iya kusebenza nge-MySQL, iMariaDB kunye neeseva zedatha yePercona.
Lo mthengi uya kuba luncedo ngakumbi xa kuziwa bhala imibuzo entsonkothileyo ngokulula nangokukhawuleza ngaphandle kokukhumbula wonke umbuzo wes syntax. Iya kusinika abasebenzisi ithuba lokusebenzisa i-REPL (Funda, u-Eval, uPrinta, uLoopeziza kuvela kwimenyu yeengcebiso nje ukuba siqale ukuthayipha.
Iimpawu ngokubanzi ze-mycli
I-Mycli sisixhobo somgca wokuyalela ye-MySQL, iMariaDB kunye nePercona kwaye ixhasa le misebenzi ilandelayo:
- Masidibane ne- ukugqibezela nokugqibezela icala eliphezulu okanye elisezantsi. Ngokukhawuleza xa siqala ukuthayipha imiyalelo, oku kuya kudlala.
- Gcwalisa ngokuzenzekelayo ngelixa uchwetheza amagama aphambili e-SQL, kunye neetafile, umbono, kunye neekholamu kwiziko ledatha.
- Ushicilelo oluhle lwe idatha yetafile apho ubona khona imibala. Njengoko sibhala imibuzo yethu, siza kubona ukuba amagama agciniweyo aya kuba nombala omnye, ngelixa idatha kunye nezinye zihlala zikhona. Oku kuyakuvumela abasebenzisi ukuba babone ngokukhawuleza kwaye ngokulula kwaye bahlalutye imibuzo esiyenzayo kwi-DB.
- Lo mthengi uza kusinika inkxaso Imibuzo emininzi.
- Inkxaso Unxibelelwano lwe-SSL / TLS.
- Siya kuba nethuba lokuba gcina imibuzo yethu ozithandayo. Siya kuba nakho ukugcina iziphumo zakho kwifayile. Oku kusebenza kukhubazekile ngokungagqibekanga kodwa sinokukusebenzisa ngokuhlela ifayile ye ifayile yoqwalaselo, efumaneka kwi ~ / .isikhuselo.
- Zonke iirekhodi Siya kuba nakho ukuzifumana kwifayile ~ / .mycli.log.
- Siza kufumana inkxaso ukuze sikwazi ukuyisebenzisa imixholo eyahlukeneyo.
- Isebenza kakuhle Unicode igalelo / imveliso.
Ezi zezinye zeempawu zayo. Siya kuba nakho ukufumana zonke izinto zayo kwiphepha lakhe leGitHub.
Faka i-mycli kwi-Ubuntu
Ukufaka i-MySQL CLI, okt mycli, Siya kufuna inkqubo eqhuba python 2.7+ okanye 3.4+. Ngesi sizathu kuya kufuneka siqiniseke ukuba inkqubo yethu Ubuntu inePython efakiweyo. Ukuba asinalo olu lwimi, ukulifaka, yenza lo mthetho ulandelayo kwi-terminal (Ctrl + Alt + T):
sudo apt install python
Nje ukuba le mfuno ingentla izalisekiswe, i-mycli inayo iiphakheji ezikhoyo kumthombo wokugcina impahla yenkqubo. Siza kuba nakho ukusebenzisa le script ilandelayo ukufaka lo mthengi:
sudo apt update && sudo apt install mycli
Olunye ukhetho lofakelo luya kusetyenziswa kuba ekugqibeleni. Ukufaka i-mycli usebenzisa lo mphathi wephakheji yePython, kuya kufuneka uchwetheze kwisiphelo sendlela (Ctrl + Alt + T):
sudo pip3 install mycli
Emva kofakelo, siya kuba nakho jonga ingxelo yomthengi efakiweyo ngalo myalelo ulandelayo:
mycli -v
Ukuqala, siya kuba nakho ukuqhagamshela usebenzisa lo myalelo uboniswe ngezantsi:
sudo mycli
Qaphela ukuba iingcebiso zinobuthathaka kumxholo kuxhomekeke kwindawo yesikhombisi. Umzekelo: ziitafile kuphela ezicetyiswayo emva kwegama elivela kwigama eliphambili kwaye kuphela ngamagama ekholamu acetyiswayo emva kwegatya LAPHO
Uncedo
Ukufumana Uluhlu lwayo yonke imiyalelo enokusetyenziswa ne-mycliInto ekufuneka uyenzile kukuqhuba lo myalelo woncedo ulandelayo kwisiphelo sendlela:
mycli --help
ukuba funda ngakumbi ngokusebenzisa i-mycli, abasebenzisi banokudibana ne- amaxwebhu asemthethweni enikezelwa kwiwebhusayithi yeprojekthi.
Isishwankathelo, i-mycli sisixhobo esilungileyo secala labathengi esiza kufutshane nexesha lokubhala imibuzo kwisiphelo sendlela kuba iya kuphakamisa amagama etafile kunye neekholamu njengoko sibhala umbuzo. Ukuba kukho umntu onomdla, kufuneka kuthiwe Kukwakho nesixhobo esilinganayo seposi enegama pgcli eye yaphuhliswa nguAmjith.