A cikin labarin na gaba zamu duba mycli. Nan gaba zamu ga shigarwa a cikin Ubuntu na wannan MySQL abokin ciniki don m. An rubuta shi a Python ta amfani da laburaren Python Prompt Kayan aiki kuma a cikin se ya hada da kammala aiki da rubutu da kuma karin haske. Zai yi aiki tare da sabobin bayanai na MySQL, MariaDB da Percona.
Wannan abokin harka zai kasance mai amfani musamman idan yazo rubuta hadaddun tambayoyi cikin sauki da sauri ba tare da tuna dukkan kalmomin aiki ba. Zai ba masu amfani damar amfani da REPL (Karanta, Eval, Buga, Madauki) wanda zai bayyana a menu na shawarwari da zaran mun fara bugawa.
Janar fasali na mycli
Mycli kayan aikin layin umarni ne na MySQL, MariaDB da Percona kuma yana goyan bayan ayyuka masu zuwa:
- Mu hadu da auto cikakke kuma cikakke babba ko ƙaramin ƙarami. Da zaran mun fara buga umarni, wannan zai shigo cikin wasa.
- Sanya kai tsaye yayin buga kalmomin SQL, da kuma tebur, ra'ayoyi, da kuma ginshiƙai a cikin bayanan.
- Kyakkyawan kwafi na Tabular bayanai wanda zaku iya ganin launuka. Yayin da muke rubuta tambayoyin mu, zamu ga cewa kalmomin da aka tanada suna da launi ɗaya, yayin da bayanan kuma suke ɗauke da wani. Wannan zai ba masu amfani damar ganowa da kuma bincika tambayoyin da muke yi wa DB.
- Wannan abokin aikin zai bamu tallafi tambayoyi da yawa.
- Taimako ga Haɗin SSL / TLS.
- Za mu sami damar adana tambayoyinmu fi so. Hakanan zamu sami damar adana sakamakonku a cikin fayil. Wannan aikin ya lalace ta hanyar tsoho amma zamu iya kunna shi ta hanyar gyara fayil ɗin sanyi, wanda aka samo a ciki ~ / .wajan.
- Duk records za mu iya samun su a cikin fayil ɗin ~ / .mycli.log.
- Za mu sami tallafi don iya amfani da su jigogi daban-daban.
- Aiki da kyau tare da Shigar / shigar da Unicode.
Waɗannan su ne kawai wasu daga cikin fasali. Za mu iya samu duk sifofinsa a shafinsa na GitHub.
Sanya mycli akan Ubuntu
Don shigar da MySQL CLI, watau mycli, zamu buƙaci tsarin da ke gudana Python 2.7+ ko 3.4+. Saboda wannan dole ne mu tabbatar cewa tsarin Ubuntu ɗinmu ya girke Python. Idan ba mu da wannan yaren, don girka shi, aiwatar da umarni mai zuwa a cikin m (Ctrl + Alt + T):
sudo apt install python
Da zarar an cika buƙatar da ke sama, mycli na da fakitoci da ke cikin maɓallan sarrafa manajan kunshin na tsarin. Zamu iya amfani da wannan rubutun don shigar da wannan abokin aikin:
sudo apt update && sudo apt install mycli
Wani zaɓin shigarwa zai kasance don amfani pip. Don shigar da mycli ta amfani da wannan manajan kunshin Python, kawai za ku rubuta a cikin tashar (Ctrl + Alt + T):
sudo pip3 install mycli
Bayan kafuwa, zamu iya duba sigar abokin ciniki da aka sanya tare da umarnin mai zuwa:
mycli -v
Don farawa, zamu iya haɗuwa ta amfani da umarnin kamar yadda aka nuna a ƙasa:
sudo mycli
Lura cewa shawarwarin suna da alaƙa da mahallin dangane da matsayin siginan. Misali: tebura kawai ake ba da shawara bayan DAGA mabuɗin kuma sunayen shafi kawai ake ba da shawara bayan INA magana.
Taimako
A samu jerin duk dokokin da za'a iya amfani dasu tare da mycli, duk abin da zaka yi shine gudanar da umarnin taimako mai zuwa a cikin tashar:
mycli --help
para ƙara koyo game da amfani da mycli, masu amfani zasu iya tuntuɓar takaddun hukuma miƙa akan aikin yanar gizon.
A takaice, mycli kyakkyawan kayan aiki ne na abokin ciniki wanda zai gajartar da lokacin rubuta tambayoyin a cikin tashar tunda zai ba da shawarar tebur da sunayen shafi yayin da muke rubuta tambaya. Idan wani yana da sha’awa, dole ne a faɗi haka akwai kuma kayan aikin daidai don postgres tare da sunan pgcli wanda Amjith ya haɓaka.