M'nkhani yotsatira tiwona mycli. Pambuyo pake tiwona kukhazikitsa kwa Ubuntu kwa izi MySQL kasitomala wothandizira. Zinalembedwa mu Python pogwiritsa ntchito laibulale Chida cha Python Prompt ndi mu se Zimaphatikizapo kukonza kwa autocompletion ndi syntax. Idzagwira ntchito ndi ma seva a database a MySQL, MariaDB ndi Percona.
Wotsatsa uyu azithandiza makamaka zikafika lembani mafunso ovuta mosavuta komanso mwachangu osakumbukira syntax yonse yamafunso. Ipatsa ogwiritsa ntchito mwayi wogwiritsa ntchito REPL (Werengani, Eval, Sindikizani, Loop) zomwe ziwonekere pamndandanda wazomwe tikangoyamba kulemba.
Zambiri za mycli
Mycli ndi chida cholozera ya MySQL, MariaDB ndi Percona ndipo imathandizira ntchito zotsatirazi:
- Tiyeni tikumane kumaliza kwathunthu komanso kumaliza kwathunthu. Tikangoyamba kulemba malamulo, izi zidzayamba.
- Khalani ndi anthu ambiri mukamalemba mawu osakira a SQL, komanso matebulo, mawonedwe, ndi zipilala zosungidwa.
- Zithunzi zabwino za deta yomwe mungathe kuwona mitundu. Pamene tikulemba mafunso athu, tiwona kuti mawu osungidwa adzakhala ndi mtundu umodzi, pomwe zosankhazo zimakhala zina. Izi zithandizira ogwiritsa ntchito kuzindikira mwachangu komanso kosavuta mafunso omwe timapanga ku DB.
- Kasitomala uyu atithandizira mafunso angapo.
- Thandizo Maulalo a SSL / TLS.
- Tidzakhala ndi kuthekera kwa sungani mafunso athu okondedwa. Tithandizanso kusunga zotsatira zanu mu fayilo. Ntchitoyi imalephereka mwachisawawa koma titha kuyambitsa ndikusintha fayilo ya Configuration file, yopezeka mu ~ / .chombo.
- Zonse zolemba tidzatha kuwapeza mu fayilo ~ / .mycli.log.
- Tidzapeza chithandizo choti tizitha kugwiritsa ntchito mitu yosiyanasiyana.
- Zimagwira bwino ndi Kulowetsa / kutulutsa kwa Unicode.
Izi ndi zina chabe mwa mawonekedwe ake. Tidzatha kupeza mawonekedwe ake onse patsamba lake la GitHub.
Ikani mycli pa Ubuntu
Kuyika MySQL CLI, i.e. mycli, tingafune dongosolo loyendetsa python 2.7+ kapena 3.4+. Pachifukwa ichi tiyenera kuwonetsetsa kuti Ubuntu wathu wakhazikitsa Python. Ngati tilibe chilankhulochi, kuti tiziyike, tsatirani lamulo ili mu terminal (Ctrl + Alt + T):
sudo apt install python
Izi zikadzakwaniritsidwa, mycli has maphukusi omwe amapezeka m'malo osungira ma phukusi ya dongosolo. Titha kugwiritsa ntchito script yotsatirayi kukhazikitsa kasitomala uyu:
sudo apt update && sudo apt install mycli
Njira ina yowonjezera idzakhala yogwiritsidwa ntchito pip. Kuti muyike mycli pogwiritsa ntchito woyang'anira phukusi la Python, muyenera kungolemba mu terminal (Ctrl + Alt + T):
sudo pip3 install mycli
Pambuyo pokonza, tidzatha onani mtundu wa kasitomala woyikiridwayo ndi lamulo lotsatira:
mycli -v
Poyamba, tidzatha kulumikizana pogwiritsa ntchito lamulo monga tawonetsera pansipa:
sudo mycli
Dziwani kuti malingalirowa ndi achinsinsi malinga ndi malo amtembowo. Mwachitsanzo: matebulo okha ndi omwe amalimbikitsidwa pambuyo pa mawu osakira a FROM ndipo mayina am'makalata okha ndi omwe amafotokozedwera pambuyo pamagawo a WHERE.
Thandizo
Kuti mupeze mndandanda wa malamulo onse omwe angagwiritsidwe ntchito ndi mycli, zonse zomwe muyenera kuchita ndikutsatira lamulo lothandizira mu terminal:
mycli --help
Para phunzirani zambiri za kugwiritsa ntchito mycli, ogwiritsa ntchito amatha kufunsa fayilo ya zolemba zoperekedwa patsamba la projekiti.
Mwachidule, mycli ndi chida chabwino chamakasitomala chomwe chidzafupikitsa nthawi yolemba mafunso mu terminal chifukwa chiziwonetsa mayina amatebulo ndi zigawo pomwe tikulemba funso. Ngati wina ali ndi chidwi, ziyenera kunenedwa kuti Palinso chida chofanana cholemba ndi dzina pgcli zomwe zapangidwa ndi Amjith.
Khalani oyamba kuyankha