Indlela ukudala uvimba mysql

Hayi kubaluleke kangaka, nto ke leyo ebangele ukuba unomdla wokwazi enoba ukudala indlela solwazi kwi SQL yam, okona kubaluleke kakhulu, ingaba unayo esisiseko ulwazi, ngaphandle apho ukuthetha malunga nokuphunyezwa ngempumelelo wayezelwe ayikho imfuneko.

Kweli nqaku liza kuxubusha ntoni ukuba nabani na PC, ukuba ezinye iinjongo olisebenzisileyo ukufaka kwi SQL yam, ukudala uvimba, uze uzame esandleni sabo kulawulo zolwazi mihla. Kwakhona uya kuba nomdla kwabo bafuna ukwazi ukwenza njani umsebenzi ledatha mihla.

Ngokuba, njengokuba benditshilo, ukuze babe yonke into ihamba kakuhle, uzakufuna ulwazi olungundoqo ngaphandle adala mysql database ukufumana data, ngokulandelelanayo, sizakucinga ukuba uyayazi into database iitafile, imibuzo kwiziko ledatha yaye bangakholwanga ku zokuthatha abbreviation SQL. Kwakhona, siye sicinge ukuba sele efakiwe kwaye uqwalasele iseva ye Apache.

Ngoko ke, ukuba zonke kufuneka phambi kwakho, yaye umnqweno ukufunda indlela yokwenza uvimba mysql engakhange ezilahlekileyo, siza kuqala eliqalise Apache. Ukuze isebenze ngokusebenzisa indlela C: \ WebServers \ etc Khawubaleke, usebenzise le fayile. Ukuba Apache lilungile, impazamo-free isiqalo, ngoko kwikona esezantsi ekunene kwi icon ekhoyo Yongeza usiba ebomvu.

Ngoku ke kufuneka ukuba uqinisekise ukuba web mncedisi uyasebenza, ngenisa idilesi kwi isikhangeli http: // localhost / Nathi kufuneka ukufumana umbhalo Ukuba ubona phezu monitor, ngoko Apache ukuze "oo, uhola!".

hamba ngoku uye Izixhobo ze ukhethe Import phpMyAdmin kuluhlu, unayo iqokobhe womzobo ekuvumela ukuba ukulawula I SQL yam ledatha. Ingasetyenziswa ukwenza yonke imisebenzi ngaphandle kokukhetha, ezinikezelwa liSebe bemeko- yale database, ingakumbi:

ukudala neeDathabheyisi

Ukudala uvimba, kwi "Yenza database entsha" kufuneka ufake igama, umzekelo, MyBase. Ngoku cinezela iqhosha 'Yenza' yaye phpMyAdmin iza kudala uvimba entsha.

ukudala iitafile

Yenza itheyibhile ilula, kufuneka ukhethe isiseko (MyBase). Kwi window engundoqo kuyalelwa ukuba ufake igama kwetafile (zama ukubhala igama DataStudent), kwakunye nemfuneko ufake inani amasimi (iseti inombolo 5). Xa ukhetha indlela oza kuba amasimi, musa ukulibala ukuba intsimi enye iya phantsi iqhosha (ID). Ukuba oyifake ngendlela eyiyo - cinezela «Ngena» iqhosha.

Ngoku uya kuvula ifom eyongezelelweyo ukudala ezitafileni. Kuyo ungakhankanya intsimi, abele iindidi zedata ngamnye kubo, ekuthiwa kwikholam, ukufumanisa ubukhulu yabo epheleleyo. Njengoko umthetho, intsimi leyo, isitshixo. igama lakhe kungene kwi «ID», ngoku kuyimfuneko ukumisela udidi lwedata wangena kule kholam. Ukususela kule hlobo I SQL yam, sibali ayikho, khetha Int, iimpawu abeke isheke ungatyikitywanga. Emva koko uye kuseto phambili kwaye apho Auto-ukwenyuselwa, ukuze ixesha ngasinye uthethe ixabiso elitsha, lo mhlaba ngokuzimeleyo kwandisa ixabiso layo nganye.

Ngoko ke, nina bagcina nge sokubala eqhelekileyo. Lifikile ixesha lokuba ugqithele kwiqela elilandelayo Useto - RadioButton. Apha, khetha "zaseprayimari" ukuba iyasebenza - ukuba intsimi yethu ke iqhosha.

Ukuba wenza yonke into ngokuchanekileyo, intsimi ezimqoka elungiswe kakuhle, xa udibanisa imiqolo kuyo kwandisa ngokuzenzekelayo le ID ixabiso. Kwaye uba inyathelo elinye ukusondela nokuqonda indlela yokwenza uvimba I SQL.

Ukuya phambili, ngoku kufuneka ukuba ukuchaza amaxabiso uze unike amagama ezinye nemihlathi itafile. Makube emasimini. igama lokugqibela, igama lokuqala kunye, umzekelo, uqikelelo: «Fam», «Name», «Otch», «Ocenka», ekhohlo ukwabela uhlobo lwe data - varChar, ngenxa yokuba kwezi imihlaba ukugcina ulwazi ngohlobo yomgca. Ungalibali ukubeka ubude kunye namasimi bekuya kuba sengqiqweni ukunciphisa kwixabiso ezingu-30. Khangela onke amangeniso kwaye anelise amehlo akho phezu kwetafile wadala. Kufuneka ibe iseti kwamabala kunye «ID» amagama, «Fam», «Name», «Otch», «Ocenka».

Ndiyathemba ukuba ingcaciso enikwe ngayo kweli nqaku kuluncedo kuwe, uze nawe kulo wayifumana impendulo yombuzo ye indlela yokwenza isicwangciso-database I SQL.