Ukuba unengxaki yokulawula isiseko sedatha esivela kwenye iseva, ungakhathazeki, namhlanje siza kukuxelela yonke into enxulumene nayo Imiyalelo ye-MYSQL.
Imiyalelo ye-MYSQL
Ukuthetha ngezi ntlobo zeefomathi kunye nemiyalelo kuthathelwa ingqalelo indlela eya kugcinwa ngayo indawo yogcino lwedatha kwiphepha lewebhu. Kubalulekile ukuba uyazi ukuba ungayifaka njani imiyalelo ye-MYSQL ngohlobo lwefayile, kunye nesiphelo sendlela.
Umbuzo wesiseko sedatha ubalulekile ekusebenzeni kwayo nayiphi na inkqubo. Ukusetyenziswa kwenziwa ngokubanzi kwiphepha le-PHP, kodwa ukuphatha kulula ukukwenza usebenzisa inkqubo ye-PhpMyAdmin; Nangona kunjalo, kuyenzeka ukuba ukuba kukho iingxaki, eyona ndlela isebenzayo kukuyifaka kulayini wokuyalela.
Ngendlela efanayo, ukuba sikwi-server ekude kwaye singena kwi-terminal, kufuneka sisebenzise eso sixhobo ukubuyisa ezi fayile. Namhlanje siza kukunika eminye imiyalelo ukuze wazi ukuba yenziwa njani le nkqubo.
Khangela ifayile
Iifayile ze-MySQL zisetyenziswa kwisoftware yomthengi, ekwabelana ngayo nehlelo elinye, iMySQL. Isetyenziswa kwiimeko ezininzi ukulawula ugcino lwedatha kwilayini yomyalelo; Ziyasebenza xa inkqubo yefayile eyahlukileyo isenziwa kwaye Imiyalelo ye-MySQL.
Nasiphi na isixhobo esifakelwe isoftware yeWindows, ungayifumana le fayile, indawo ekuyo kule dilesi ilandelayo: C: Iifayile zeNkquboMySQLMySQL Server 4.1bin.
Ungayifumana kwi-C: xamppmysql; esi sikhombisi sinokuhluka kodwa sisegama kuphela.
Kwiifestile
Umzekelo, ngamanye amaxesha kwaye kuxhomekeke kuhlobo lwenkqubo yokusebenza yeWindows, ibekwe kwidiski C: okanye nakweyiphi na enye indawo kwimemori yekhompyuter, ngokufanayo, inokubekwa kwelinye ikhonkco apho umdwelisi uthathe isigqibo sokufaka yiyo. Kuxhomekeka kakhulu kuhlobo luni lwenkqubo esetyenzisiweyo ukuyifaka.
Kodwa ungakhathazeki malunga nokukhangela, usebenzisa iinjini zikaGoogle ezinokufumaneka ngokulula, ngakumbi ukufumana ifolda echanekileyo, kuba ngamanye amaxesha ikhompyuter yokukhangela ayiniki ulwazi esiludingayo.
Ifolda echanekileyo okanye leyo ufuna ukuyilawula ibekwe njengokuyalelwa nguGoogle. Umzekelo, ukuba sikwiWindows kwaye sifuna ukufikelela kwi-MySQL, siyazifumana ngaphakathi kulawulo okanye sibeka ifolda ngaphakathi koqwalaselo lwe-PATH.
Kwi-Linux
Siyabazi ubumnandi obunikwa yiLinux kubo bonke abaqulunqi beenkqubo kunye nabaphuhlisi, nangona oku akuthethi ukuba kulula ukufikelela kwiifayile ze-MySQL, kulula ukuyenza ngemigca yomyalelo; inokufumaneka nakweyiphi na enye incwadi.
Ke xa i-database yolwazi ibekwe, inkqubo enye ibonelela ngefayile "ye-MySQL", nokuba yeyiphi na incwadi esikuyo, kungoko kulula kweLinux ukwenza le nyathelo.
KwiMac
Abanye bacinga ukuba le nkqubo ihlala yahlukile ngokuthelekiswa neWindows neLinux, kodwa kuyathakazelisa ukwazi ukuba kwi-Mac ixhomekeke kakhulu kwindlela ifayile ye-MySQL efakwe ngayo kwikhompyuter. Kule meko, lo myalelo awufumaneki ngokuthe ngqo kwiLinux okanye kwiWindows, nkqu nakwinjini yedatha emiselweyo.
Ukwenza oku, kufuneka senze uphando kuGoogle, eya kuthi isinike lonke ulwazi oluyimfuneko ukuyifumana kwikhompyuter kunye nokufikelela ngqo kwifayile "ye-MySQL". Uqwalaselo olwenziwa kolu hlobo lweefayile lusetyenziso lofakelo lwenkqubo ye-Mamp; impendulo ekhawulezileyo yale nkqubo iya kuba yi-FAQ, eya kuthi isincede sisebenzise umyalelo "mysql" kwi-Mac kwaye siyifake nge-Mamp server.
Qhagamshela kwiseva ye-MySQL
Emva kokufumana ifayile ye-MySQL, kuya kufuneka unxibelelane nomphathi ngomgca wokuyalela. Emva koko qhubeka nokucela i-MySQL, ubeke isikhombisi sefayile esinegama elifanayo kwaye ubonise iindlela zonxibelelwano olusisiseko.
Ukuba sibeka "% mysql", siya kufumana ukufikelela kumgca wokuyalela kwaye ukusuka apho sinokuthintela imvelaphi engxamisekileyo, nangona kunjalo ngokubeka; c: isqlbin>. Asikhathaleli ngqo "%" uphawu.
Isalathiso sinxibelelana nendawo yogcino lwedatha ngokweeparameter kunye neemeko zenkqubo emiselweyo. Ukufaka kunye nokubopha umncedisi wasekhaya ngegama lomsebenzisi okanye lokugqitha kwimitya engenanto; Emva koko enye ingcaciso yolwazi kufuneka iboniswe ukuba ikwazi ukuqhagamshela kwindawo yogcino lwedatha, umzekelo, beka ezi paramitha zilandelayo: mysql -h server_name -u user_name -p.
Ngoku, ukuba sifuna ukudibanisa isiseko sedatha kwiseva yendawo sisebenzisa igama lomsebenzisi wengcambu, kuya kufuneka sibhale oku kulandelayo: Emva kokuyazisa, singena kwilayini yomyalelo we-MySQL; ke utshintsho olukhawulezileyo koku kulandelayo: mysql>
Kwimeko yokubonisa iphasiwedi ngqo kwilayini yomyalelo, kungeniswa ngokukhawuleza, kodwa ayicetyiswa ngezizathu zokhuseleko, kule meko lo myalelo uya kuba yile: mysql -h localhost -u root -pmi_key, enter the-py my_key akufuneki ishiye naziphi na izithuba ngaphandle kokuba ukwiseva yendawo.
Ezi nkqubo zenkqubo zibalulekile kwinkqubo nganye yokusebenza, ukuba ufuna ukufumana ulwazi ngakumbi malunga nesi sihloko, siyakumema ukuba ufunde inqaku elilandelayo Ngelixa ukwinkqubo
Sebenzisa ikhonsoli ye-MySQL
Emva kokuba singaphakathi kwikhonsoli, sinazo zonke ezinye iindlela zomyalelo we-MySQL, esivumela ukuba silawule kwaye senze nawuphi na umsebenzi kunye nesiseko sedatha kunye nekhowudi ye-SQL. Nangona kunjalo, kufanelekile ukuba kube yinto eqhelekileyo ukunxibelelana kwindawo yogcino lwedatha kuqala, ukuze ube nokukhetha ukusebenza ngokukhuselekileyo.
Ngenxa yoko, "ukusetyenziswa" komyalelo kufuneka kusetyenziswe kulandelwa igama ledatha esifuna ukuyidibanisa, masibone umzekelo: mysql> sebenzisa isiseko sedatha; emva koko singena kwindawo yedatha ye "mybaseddata". Nangona kunjalo, kufuneka sithathele ingqalelo zonke iingxelo ekufuneka zikwilayini yomyalelo we-MySQL.
Zonke ziphela ngo ";". Ke ukuba asiyibeki loo semicolon, umthetho awuzukuphunyezwa kwaye ke umyalelo wokuyalela uya kuvela kwakhona, nto leyo ebonisa ukuba kufuneka siqhubeke nokufaka izivakalisi.
Nangona kunjalo, ukuba sifuna kuphela ukwenza ingxelo ebesikhethe yona ngaphambili ngokubeka «;» Iya kwanela. Ngesi sizathu, umyalelo opheleleyo akufuneki ubhalwe kwakhona kwaye ubonakalisa kuphela ";" kwaye ucofe ukungena.
Uluhlu lwedatha
Ukukhetha i-database ethile kufuneka senze isenzo, esiya kuthi sivumele ukuba sibone ukuba zeziphi ezikhoyo; oku kufuneka sibeke is syntax elandelayo: i-mysql> bonisa indawo yolwazi; Uluhlu lubonakala nazo zonke iinkcukacha ezifumaneka kwikhompyuter yethu. Kwaye ekugqibeleni oku kulandelayo kuyaboniswa: mysql> bonisa indawo yolwazi->; Imiqolo emi-5 iseti (imizuzwana eyi-0.02).
Yenza i-database
Khumbula ukuba singaphakathi kwifayile yeMysql, esisinika izixhobo zokwenza izinto ezahlukeneyo ezinxulumene noovimba beenkcukacha, into eyimfuneko yokufuduka, ukulawula nokufaka ulwazi kuyo nayiphi na iseva. Ukuba sifuna ukwenza isiseko sedatha, kufuneka senze oku kulandelayo:
Bhala "yenza isiseko sedatha", sikhatshwa ligama esifuna ukusibeka kwindawo yogcino lwedatha, masibone: mysql> yenza umzekelo wedatha; oku kuyila ifayile.
Oko kuyakwenza idathabheyisi ebizwa ngokuba "ngumzekelo", eya kubhaliswa kwi-MySQL, kwaye singayisebenzisa kamva, ke ukuba sifuna ukuyisebenzisa kwixesha elizayo senza le nyathelo: mysql> use example.
Ulawulo lwedatha
Le datha ayisebenzi kuba sele yenziwe, kodwa ukuba besisebenzisa isiseko sedatha esele sisetyenzisiwe, kufuneka sibhale igama laso. Kwakhona, ukuba sifuna ukusebenzisa okanye ukubona iitafile eziyilungisileyo, kufuneka sibhale "bonisa iitafile", masibone: mysql> bonisa iitafile.
Ngale ndlela, indawo yogcino lwedatha ayiqulathanga iitafile, ulwazi olunje ngoku lubonakala kwangoko: "Iseti engenanto". Ngokuchasene noko, ukuba kukho iitafile ezininzi kwifayile enye, uluhlu lweetafile luya kubonakala lukhatshwa koku kulandelayo: Imigca emi-2 iseti (umzuzwana we-0.00).
Ukufumana idatha enxulumene nenye kwaye wazi nokuba zeziphi iindawo ezikhoyo, kunye neklasi, kufuneka sisebenzise umyalelo ochaza iinkcukacha kunye negama letafile, ngolu hlobo lulandelayo: mysql> inkcazo yomlawuli. Imiqolo emi-3 iseti (imizuzwana eyi-0.11).
Ukuba ufuna ukwazi ngakumbi ngale nto kunye nezinye izihloko, sicebisa ukuba ufunde inqaku elilandelayo Imiyalelo yePowerShell apho uza kufumana ulwazi olongezelelweyo olunxulumene nesi sihloko
Ezinye iZenzo kunye neMigwebo
Ngelixa kwikhonsoli ye-MySQL, izikhombisi zinokwenziwa ngemigca yokuyalela: Ngale ndlela, naluphi na uhlobo lwekhowudi lunokucelwa kusetyenziswa i-SQL; Apho sinokwenza ukhetho, uhlaziyo, ukwenziwa kwetafile kunye nokufakwa.
Indlela yokwenza ilula, ngakumbi ukuba uyazi inkqubo ethile, inkqubo inomdla kwaye kulula ukuyifumana, kufuneka siphumeze isivakalisi kwangoko emva kokubeka isemicolon. Masibone umzekelo:
- i-mysql> yenza uvavanyo lwetheyibhile (i-id yovavanyo);
- Umbuzo Kulungile, 0 imigca echaphazelekayo (imizuzwana eyi-0.08).
- Unokusebenzisa oku kulandelayo: mysql> faka kuvavanyo (id id yokuvavanya) amaxabiso (1);
- Umbuzo Kulungile, 1 umqolo ochaphazelekayo (umzuzwana we-0.00).
Okokugqibela, siyathemba ukuba siza kusombulula amanye amathandabuzo ahambelana nokukhutshelwa kwedatha ye-MySQL, eluncedo kakhulu kwiinkampani nakwimibutho, ukuba ufuna ukufumana ulwazi oluthe kratya ngayo, ungalibali ukwazi nokufunda ezinye izinto ezikule yethu portal.
