i-mycli: Indawo ebalaseleyo ye-MySQL ene-AutoComplete kunye nokuqaqanjiswa kwes syntax

MySQL, MariaDB y IPercona bathathu iziseko solwazi ezisetyenziswa ngokubanzi namhlanje, ezimbini zokuqala zifakwe kwipesenti enkulu yezicelo zomthombo ovulekileyo ezikhoyo namhlanje. Kungenxa yoko le nto kubalulekile ukuba ne- Isiphelo sendlela ye-MySQL, iMariaDB kunye nePercona esivumela ukuba sizilawule ngokufanelekileyo ezi nkcukacha zisuka kwintuthuzelo kunye noncedo esilunikwa yiConsole.

Ngeli xesha siza kudibana ne-mycli, isiseko sedatha esineempawu eziyimfuneko ukulawula ngokufanelekileyo ugcino lwedatha yethu, ngaphandle kokusebenzisa izixhobo ezibaxiweyo kunye namaxwebhu abanzi.

Yintoni iMicli?

mycli sisixhobo esivulekileyo somthombo, esenziwe nge Python, esivumela ukuba silawule kwaye senze iMySQL, iMariaDB, kunye nePercona imiyalelo ngendlela ekhawulezayo, ezenzekelayo nefanelekileyo. Isixhobo sinenkqubo yokugqitywa okuzenzekelayo kwezi lwimi zikhankanyiweyo ngasentla, ngendlela efanayo, iphakamisa i-syntax ngendlela esemgangathweni, esinceda ukuba silawule iziseko zedatha yethu ngendlela efanelekileyo ukusuka kwisiphelo.

Inofakelo olufutshane kunye nomgca wokufunda, owongeze kwiimpawu zayo ezigqwesileyo ezenza ukuba kube yinto enomdla kakhulu kwizixhobo ezinikezelwe kulawulo lwedatha, ngakumbi ngenxa yokusetyenziswa kwayo kancinci kwezixhobo kunye nexesha lokuphendula ngokukhawuleza. .

Ukusetyenziswa ngokubanzi kwesi sixhobo kunokubonwa kwi-gif elandelayo ekhutshwe ngabaphuhlisi besixhobo:

Iimpawu zeMycli

• Umthombo ovulekileyo ngokupheleleyo, ophuhliswe kwi-python kunye namaxwebhu agqwesileyo.
• Gcwalisa ngokuzenzekelayo njengoko amagama aphambili e-SQL echwetheziwe, kunye neetafile zedatha, ukujonga kunye neekholamu.
• I-syntax egqwesileyo yokuqaqambisa umbulelo kwiiNxalenye.
• Ukugqitywa okuzenzekelayo kwe-Smart (enikwa amandla ngokungagqibekanga), eya kuthi inike kuphela iingcebiso ezinxulumene nomxholo.
  • SELECT * FROM <tab> iya kubonisa kuphela amagama eetafile.
  • SELECT * FROM users WHERE <tab> izakubonisa kuphela amagama ekholamu.
• Inkxaso yemibuzo ebandakanya ngaphezulu komgca omnye.
• Ivumela ukugcina eyona mibuzo isetyenzisiweyo, kuba oku kwanele ukugcina umbuzo usebenzisa  \fs alias query kwaye usebenzise lo myalelo ulandelayo \f alias xa ufuna ukuyiqhuba kwakhona.
• Inamandla kwaye ilula ifayile yoqwalaselo, eveliswa ngokuzenzekelayo kulawulo ~/.myclirc
• Inenkqubo ebanzi yokuloga, ukuba sifuna ukugcina imbali yemiyalelo eyenziweyo.
• Makhe sisebenzise induction elungileyo.
• Iziphumo zedatha zilungelelanisiwe kwaye ziyathandeka, kubonisiwe kwiikholamu ngokwahlulahlula iitheyibhile.
• Inenkxaso yonxibelelwano lwe-SSL.
• Amaxwebhu aneenkcukacha xa usebenzisa uncedo lwesixhobo $ mycli --help
• Okuninzi nokuninzi.

Uyifaka njani i-mycli

Singayifaka i-mycli nakweyiphi na i-Linux distro enkosi kwi-python, ngenxa yoku kufuneka sifakelwe umbhobho kwaye senze lo myalelo ulandelayo:

$ sudo pip install -U mycli

Abasebenzisi be-Debian kunye ne-ubuntu bangafaka isixhobo ngokuthe ngqo kwii-repositories ezisemthethweni ngokusebenza

$ sudo apt-get install mycli

Ngokunjalo, iArch Linux kunye nabasebenzisi abavela kuyo banokonwabela esi sixhobo enkosi kwii-AUR zokugcina, ngokwenza njalo, yenza lo mthetho ulandelayo:

$ yaourt -S mycli

Ukuqukumbela, ndifuna ukugxininisa ukuba kuvavanyo olwenziwe sisixhobo siziphathe ngokukhawuleza kakhulu kwaye ingcebiso yayo xa isiza kugqibezela ilungile. Ndide ndicinge ukuba esi sixhobo siluncedo kakhulu kwi-MySQL Navigator kunye nethuba lokusebenzisa izixhobo ezimbalwa, ukuba ungumthandi wekhonsoli kwaye usebenzisa ezinye zeedatha ezintathu ezihambelana nazo, ungathandabuzi ukuzama esi sixhobo sikhulu kwaye usixelele ngombono wakho malunga.