Esihlokweni esilandelayo sizobheka i-mycli. Okulandelayo sizobona ukufakwa ku-Ubuntu kwalokhu Iklayenti le-MySQL lokugcina. Kubhalwe ePython kusetshenziswa umtapo wezincwadi I-Python Prompt Toolkit nasese kufaka phakathi ukugqamisa kwe-autocomplete ne-syntax. Izosebenza nge-MySQL, i-MariaDB ne-Percona database amaseva.
Leli klayenti lizoba wusizo ikakhulukazi uma kukhulunywa ngalo bhala imibuzo eyinkimbinkimbi kalula futhi ngokushesha ngaphandle kokukhumbula yonke syntax yombuzo. Izosinikeza abasebenzisi ithuba lokusebenzisa i-REPL (Funda, u-Eval, Phrinta, uLoop) okuzovela kumenyu yeziphakamiso ngokushesha nje lapho siqala ukuthayipha.
Izici ezijwayelekile ze-mycli
I-Mycli iyithuluzi lomugqa womyalo kwe-MySQL, iMariaDB nePercona futhi isekela le misebenzi elandelayo:
- Asihlangane ne- ukuqedela okuzenzakalelayo nokuqedela icala eliphezulu noma eliphansi. Lapho nje siqala ukuthayipha imiyalo, lokhu kuzoqala ukusebenza.
- Gcwalisa ngokuzenzakalela ngenkathi uthayipha amagama angukhiye e-SQL, kanye namatafula, ukubukwa, namakholomu ku-database.
- Ukuphrinta okuhle kwe idatha yethebula lapho ungabona khona imibala. Njengoba sibhala imibuzo yethu, sizobona ukuthi amagama agodliwe azoba nombala owodwa, kanti idatha futhi imise omunye. Lokhu kuzovumela abasebenzisi ukuthi bakhombe ngokushesha futhi kalula futhi bahlaziye imibuzo esiyenza kwi-DB.
- Leli klayenti lizosinikeza ukusekelwa imibuzo enemigqa eminingi.
- Ukusekela Ukuxhumeka kwe-SSL / TLS.
- Sizoba nethuba lokuthi gcina imibuzo yethu izintandokazi. Sizokwazi nokugcina imiphumela yakho kufayela. Lokhu kusebenza kukhutshazwe ngokuzenzakalela kepha singakusebenzisa ngokuhlela ifayela le- ifayela lokumisa, elitholakala ku- ~ / .myclirc.
- Konke amarekhodi sizokwazi ukubathola kufayela ~ / .mycli.log.
- Sizothola ukusekelwa esizokwazi ukukusebenzisa izingqikithi ezahlukahlukene.
- Isebenza kahle nge Okokufaka / ukukhishwa kwe-Unicode.
Lezi ngezinye nje zezici zayo. Sizokwazi ukuthola zonke izici zayo ekhasini lakhe leGitHub.
Faka i-mycli ku-Ubuntu
Ukufaka i-MySQL CLI, i.e. mycli, sizodinga uhlelo olusebenzisa i-python 2.7+ noma i-3.4+. Ngalesi sizathu kuzofanele siqiniseke ukuthi uhlelo lwethu lwe-Ubuntu lunePython efakiwe. Uma singenalo lolu limi, ukulifaka, yenza umyalo olandelayo ku-terminal (Ctrl + Alt + T):
sudo apt install python
Lapho le mfuneko engenhla ifezekile, i-mycli ine amaphakheji atholakala kumakhosombe wemenenja yephakheji wohlelo. Sizokwazi ukusebenzisa umbhalo olandelayo ukufaka leli klayenti:
sudo apt update && sudo apt install mycli
Enye inketho yokufaka kuzoba ukusebenzisa PIP. Ukufaka i-mycli usebenzisa le mphathi wephakheji yePython, kufanele uthayiphe ukuphela (Ctrl + Alt + T):
sudo pip3 install mycli
Ngemuva kokufakwa, sizokwazi hlola inguqulo yeklayenti efakiwe ngomyalo olandelayo:
mycli -v
Ukuqala, sizokwazi ukuxhuma sisebenzisa umyalo njengoba kukhonjisiwe ngezansi:
sudo mycli
Yazi ukuthi iziphakamiso zizwela kokuqukethwe ngokuya ngendawo yesikhombisi. Isibonelo: kuphela amatafula aphakanyisiwe ngemuva kwegama elivela ku-FROM futhi amagama ekholamu kuphela aphakanyisiwe ngemuva kwesigatshana esithi LAPHO.
Usizo
Ukuthola uhlu lwayo yonke imiyalo engasetshenziswa ne-mycliUkuphela kokufanele ukwenze ukusebenzisa umyalo wosizo olandelayo ku-terminal:
mycli --help
para funda kabanzi ngokusebenzisa i-mycli, abasebenzisi bangaxhumana ne- imibhalo esemthethweni okunikelwe kuwebhusayithi yephrojekthi.
Ngokufingqa, i-mycli iyithuluzi elihle eliseceleni kwamakhasimende elizofushanisa isikhathi sokubhala imibuzo ku-terminal ngoba izophakamisa amagama etafula namakholomu njengoba sibhala umbuzo. Uma kukhona onentshisekelo, kufanele kushiwo lokho kukhona futhi ithuluzi elilinganayo lama-postgres anegama pgcli esakhiwe ngu-Amjith.