Kwinqaku elilandelayo siza kujonga kwi-MySQL Workbench. Le yenye isixhobo esibonisa uyilo yolwazi edibanisa uphuhliso lwesoftware, ulawulo lwedatha, uyilo lwesiseko sedatha, ukudala kunye nokugcina inkqubo yedatha ye-MySQL.
Le nkqubo yindlalifa ye- Umyili we-DB 4. Indawo yokusebenza ye-MySQL Yenye yeemveliso zokuqala kusapho lwe-MySQL ukubonelela ngeendlela ezimbini ezahlukeneyo, umthombo ovulekileyo kunye nohlobo lwentengiso. Le software inika umsebenzisi ithuba lokuba ngumzekelo wedatha, uphuhliso lwe-SQL kunye nezixhobo zolawulo olubanzi kulungelelwaniso lweseva, ulawulo lomsebenzisi, i-backups nokunye okuninzi. I-MySQL Workbench iyafumaneka kwiWindows, Gnu / Linux, nakwiMac OS X.
I-MySQL Workbench ivumela uyilo olubonakalayo, imodeli, ukuvelisa nokulawula iziseko zedatha. Ibandakanya yonke into ekufuneka yenziwe ngummeli wedatha ukwenza iimodeli ze-ER ezintsonkothileyo, ubunjineli obuchanekileyo kunye nokubuyela umva, kwaye ikwabonelela ngeempawu eziphambili zamaxwebhu anzima kunye notshintsho kwimisebenzi yolawulo efuna ixesha elininzi kunye nomzamo.
Isoftware iya kusinika iseti yezixhobo zokuphucula ukusebenza kwezicelo ze-MySQL. Iingxelo zentsebenzo ziya kusinika ngokuchongwa ngokulula kunye nokufikelela kwiindawo zokufikelela ze-IO, iingxelo ze-SQL kunye nokunye. Kwaye ngonqakrazo olunye, abaphuhlisi banokubona apho banokuyilungiselela khona imibuzo yabo.
Abaphuhlisi beenkcukacha kunye nabalawuli baya kuba nako ngokukhawuleza kwaye ngokulula ukuguqula usetyenziso esele lukhona ukuba lusebenze kwi-MySQL Zombini kwiGnu / Linux nakwamanye amaqonga. Ukufuduka kukwaxhasa ukufuduka ukusuka kwiinguqulelo ezindala ze-MySQL ukuya kwiinguqulelo zamva nje.
Nawuphi na umsebenzisi unokubonisana ne ngezandla ngu Workbench abaphuhlisi benza ukuba kufumaneke nakubani na oyifunayo.
Ukusebenza ngokubanzi kwe-MySQL Workbench
Isicelo siya kusinika yonke into eyimfuneko kuphuhliso lwe-SQL. Nawuphi na umsebenzisi uya kuvunyelwa yenza kwaye ulawule unxibelelwano kumaseva wedatha. Ukongeza kukuvumela ukuba uqwalasele iiparameter zonxibelelwano, i-MySQL Workbench ibonelela ngokuqhuba kwemibuzo ye-SQL kuqhagamshelo lwedatha usebenzisa i Umhleli weSQL oko kudityanisiwe.
I-MySQL Workbench ixhasa ngokupheleleyo iinguqulelo zeseva ye-MySQL 5.5 nangaphezulu. Iyahambelana neenguqulelo ezindala zeseva ye-MySQL 5.x, ngaphandle kweemeko ezithile (ezinje ngokubonisa uluhlu lwenkqubo) ngenxa yeetafile zenkqubo eziguqulweyo. Ngaba ayixhasi iinguqulelo zeseva ye-MySQL 4.x.
Le nkqubo iyakusivumela ukuba senze imizobo yesiseko sedatha ngokuzoba. Iya kusivumela ukuba sibuye umva kwaye sithumele ubunjineli phakathi kweschema kunye nesiseko sedatha ngoku sivumela ukuba sihlele yonke imiba yedatha sisebenzisa uMhleli weTafile. Inkqubo ye- Umhleli wetheyibhile ibonelela ngezixhobo zokuhlela iitafile, iikholamu, ii-index, ii-trigger, izahlulelo, ukhetho, ukufaka, njl.
I-Workbench iyakusinceda nge Ukufuduka kwedatha. Iya kuvumela nawuphi na umsebenzisi ukuba afuduke kwi-MySQL aye kwiMicrosoft SQL Server, Microsoft Access, Sybase ASE, SQLite, SQL Naphi na, iPostreSQL kunye nezinye iitafile ze-RDBMS, izinto kunye nedatha. Ukufuduka kukwaxhasa ukufuduka ukusuka kwiinguqulelo ezindala ze-MySQL ukuya kwiinguqulelo zamva nje.
Faka i-MySQL Workbench 6.3.9 kwi-Ubuntu 16.04
Singayifaka le nkqubo ngeendlela ezimbini. Eyokuqala iya kuba kukhuphelo .deb package kwiwebhusayithi yabo. Emva koko kuya kufuneka siyifake. Indlela yesibini yokufaka le software iya kuba usebenzisa i-terminal kunye ne-APT command.
Phambi kokuqala kofakelo kwisiphelo sendlela, kuyafuneka ukuba uvuselele iindawo zokugcina. Ngale nto siza kuvula i-terminal (Ctrl + Alt + T) kwaye siza kubhala oku kulandelayo:
sudo apt update && sudo apt upgrade
Ngoku sinokufaka i-MySQL Workbench usebenzisa i-APT. Kwisiphelo esinye siya kubhala:
sudo apt install mysql-workbench
Nje ukuba ukufakela kugqityiwe, sinokwazisa usetyenziso nokuba luvela kwiDash okanye ngokubiza inkqubo ukusuka kwisiphelo sendlela:
mysql-workbench
Khipha i-MySQL Workbench
Ukususa inkqubo kwinkqubo yethu yokusebenza kwiConsole (Ctrl + Alt + T) kwaye siza kubhala oku kulandelayo:
sudo apt remove mysql-workbench && sudo apt autoremove
Namhlanje zininzi izinto ezinokubakho (kwaye kusenokwenzeka ukuba zangoku, nangona ndingathandabuzi ukuba zisebenza ngakumbi) ukusebenza noovimba beenkcukacha. Olu yayilukhetho lokuqala endiqale ngalo ukudlala ngalo. Ilula ukuyisebenzisa, kodwa njengoko benditshilo, lukhetho olunye nje oluninzi lwezinto ezikhoyo. Wonke umntu unokufumana eyona ilungele indlela yabo yokusebenza.