Wenza njani ufakelo lwe SQL yam?

Ngamaxesha zokusabalalisa elikhutheleyo Internet yababini ye Apache, i-PHP, i-SQL yam iye kakhulu zithandwa. Abanini site abaninzi bamba zabo kwezi zakhono. Ngenxa yesi sizathu ndagqiba ekubeni abhale malunga nendlela ufakelo lwe SQL.

Ngoko ke, ukuqala unikezelo lwefayile yokuhlohla uze ucofe Phindisela iqhosha. Kulo wizard, khetha ucwangciso olungagqibekanga uze ucofe "Okulandelayo." Uya kwandula ke ubone indlela ukugcina ifayile. Ukuba anelisekile, yiya phambili kwaye uqalise ufakelo. Xa inkqubo lugqityiwe, kwi izikrini ezimbini ezilandelayo klikha kwiqhosha "Okulandelayo", emva koko jonga ibhokisi kwi ngongoma "Izicwangciso Server lo mzuzu" uklikhe iqhosha "Gqiba".

ufakelo Further lubandakanya isicwangciso MySQL uqwalaselo. Kwakhona iqhosha uqhubeke, uze ukhethe isicwangciso enenkcukacha, kwaye ngoku nqakraza "Okulandelayo." i window izakuvela phambi kwakho apho ufuna ukufaka ukusebenza. Kuzo zonke iinketho kufuneka ukhethe umatshini umqambi. Oku kuya konga kakhulu imemori. Kwi window elilandelayo ungenza isigqibo kuhlobo ekhethwayo ezitafileni. Unomdla kwi yokuqala ukhetho.

Ukuba ufakela umphezulu I SQL yam liyaqhubeka, kwaye ke kufuneka ukuba ukhankanye indawo apho kuya kubakho ifayile equlathe ulwazi olunxulumene izicwangciso elidlulileyo. Ndinicebisa bashiya umendo ezicetywa wizard yokumiselwa, yiya kwinyathelo elilandelayo. Emva koko, uya kucelwa ukuba ukhethe inani benani labaxhasi eziza kuvunyelwa ukuba ngaxeshanye ukudibanisa kwiseva. Unalo ukhetho ukukhetha 20 ukuya yokungapheli. Kodwa ukwenza buza inani 20.

Yiya kwinyathelo elilandelayo. Kufuneka ukhankanye inani lezibuko. Uqhagamshelwano kwi- server ukuya umxhasi iya kuba ukuyisebenzisa. Iwizard ibonisa ixabiso elisisiseko, nto leyo ilingana 3306. Akunakwenzeka ukuba ngaphambili bafaka nayiphi na enye indlela, ukuze uzibekele le salathisi ingaguqukanga. Siya uqinisekise aze aye encoding umyalelo eziya uzakusetyenziswa kokungagqibekanga. Kufuneka ukhethe i ngongoma yesithathu, nto leyo ethetha isandla-ukhowudo, waza wabeka sr1251 kwi Ngokubanzi kwimenu yotsalo-phantsi. Oku kuthetha ukuba Russian windose-encoding iza kusetyenziswa.

Kwi window elandelayo efakiweyo I SQL yam njenge inkonzo enika isiqalo nomncedisi ngexesha lokuqala, kwakunye nokuzaliswa ngokuchanekileyo umsebenzi emva ukucima ikhompyutha. Jonga ibhokisi esecaleni izicwangciso zokusebenza oluzenzekelayo zize zitikishe umba ziquka ithuba khankanya umendo wendlela weefayili. Kwakhona nqakraza "Okulandelayo." Kwi-window entsha, kufuneka kutsha akhawunti eziyimfuneko. Okokuqala, ndinicebisa ukususa uphawu. Oku kuya kunika ithuba lokuba ukuloga ngaphandle lokugqitha.

Umngeni elandelayo iza kuba ukwenza izinto eziyimfuneko yoqwalaselo lwefayile. Yenza mphathi nqakraza kuba iqhosha ulinde abulawe kugqitywe le fayile. Xa inkqubo lugqityiwe, klikha kwiqhosha "Gqiba". Kuko konke. Kufuneka kuqatshelwe ukuba operatsionok ezininzi kunokwenzeka ukufaka I SQL. Ubuntu wena okanye windose, akunamsebenzi.