Console umyalelo Windows - SQL

Development of information technology - yenye yeenkalo eziphambili zezinto ezenziwa luluntu. Ngoko ke, kule ngingqi utyala imali esikhulu semali. Ukususela ekuqaleni kunye eninzi zemisebenzi eyahlukeneyo kuye kwagqitywa ekubeni umhla, leyo lula kakhulu ubomi bemihla ngemihla babantu abaninzi. Noko ke, apho kukho inkqubela kwezobugcisa, inani iingxaki, enye yazo - isixa ngokugqithiseleyo ulwazi lugcinwe. Oovimba badalwa ukusombulula le meko.

Enesishwankathelo ngenkqubo yolawulo database

Ekubeni ingxaki yokugcina ulwazi oluninzi iyimfuneko namhlanje, kukho iindlela ezininzi zokusombulula. Ngamnye kubo ajongene nalo msebenzi ngokuqhubekayo indlela ethile. Nangona kunjalo, kunye akha isakhiwo epheleleyo ethi lula ingxaki lokugcina.

Kukho kudidi ecacile, nto leyo ebonisa imfuneko uvimba ethile kunye DBMS (inkqubo yolawulo database). Avamise kakhulu ngoku uthathwa ukuba uhanjiselo-server technology lokugcina. Ezi ziquka oku kulandelayo: Firebird, Interbase, IBM DB2, Kumncedisi we SQL MS, Sybase, Oracle, PostgreSQL, Linter, I SQL yam. Thina abanomdla yokugqibela ukhetho - I SQL yam, apho iqela ngokupheleleyo nomgangatho SQL. Lo bugcisa yenye isicelo kunye nemveliso iingxaki ethandwa kwaye ngokuqhelekileyo kusetyenziswa ukujongana yasekuhlaleni ukuziphilisa.

technology uhlobo loNiko-bomncedisi ledatha fayile-server, kwinto ezilahlekileyo kwizikhundla zazo ngenxa eziliqela kuneengxaki ezikhoyo, phakathi apho imfuneko sokwabela andise DBMS kernel kwikhompyutha nganye kunye umthwalo ebalulekileyo kwi ariya yobulali yomsebenzi womnatha, oko kukhokelele ekwandeni ixesha. Eli qela libandakanya i-Microsoft Access, i Borland imangalisayo.

ubugcisa ezintsha ngokuya kuthandwa

Noko ke, kwiminyaka embalwa eyadlulayo kwakukho iteknoloji enobuchwepheshe zithanda kunye nemfuno zokusombulula iingxaki ezincinane zendawo. Sithetha kweenkqubo zolawulo database olungisiweyo. Eyona phawu yale ledatha - akukho kwicala lomncedisi. Le nkqubo kukodwa ilayibrari, singavumeli ngendlela efanayo yokusingatha oluninzi ulwazi esingethwe kwi computer yobulali. Le ndlela kushenxisa ezingalunganga ifayile izibonelelo umncedisi, isikhulu kakhulu ukuba isantya technology uhanjiselo-server.

Njengoko imizekelo kubonakala OpenEdge, SQLite, BerkeleyDB, njengenye yeenketho Firebird ka nale Sav, i-Microsoft uMncedisi SQL i IiBhalbhu, Linter, kwakunye njengomnye I SQL yam ukhetho ukuba iqela akukho ezahlukileyo kwezo zisetyenziswa database uhanjiselo-server. Nangona kunjalo, iinkqubo eqhagamshelweyo kungaba lula ukufaneleka ukuba ingxaki liyayeka ukuba zasekuhlaleni.

Eyona engundoqo eziluncedo kweziko ledatha MySQL

inkqubo yolawulo ledatha I SQL yam ngomnye ezixhobo ethandwa, kuba isebenze ukusombulula inani elikhulu imisebenzi. Ukuba usithelekise kunoogxa mihla, kusenokwenzeka ukuba inani yeenzuzo ezinkulu.

Uncedo eziphambili kurhwebo Russian uthathwa ukuba ibe nokufumaneka kwayo, ukusukela ukuba isimahla kwentlawulo kwiimeko ezininzi. Olona phawu yesibini isantya. Enye kwiindlela ezininzi popular I SQL. Iqela ke fast, kwixesha lokuphendula ubuncinane. Akukho ukusebenza ngesantya processing imiyalelo oluzakudibaniswa kumncedisi abaxhasi ezininzi kwindlela multithreaded ngokusebenzisa sisixhobo senkxaso InnoDB yeentengiselwano fast.

Ubukho umqhubi ODBC ivumela ababhekisi lula ngesisombululo iingxaki ezininzi. Iinzuzo Kwakhona kufuneka ukuba sibandakanye ukunikezelwa amathuba zamarekhodi ubude ezinzileyo kunye neguquguqukayo. Kodwa msebenzi ungundoqo leyo kakhulu kunene phakathi badwelisi benkqubo - interface kunye iilwimi C and PHP. Amathuba enikwa I SQL yam, uvunyelwe ukusebenzisa le database inani elikhulu ababoneleli ngeenkonzo webhu.

Yaye engumshumayeli elula, nokuphuhlisa umdla ubuchwepheshe bale mihla yokugcina ulwazi, kuyimfuneko ukuba ukufunda I SQL yam, imiyalelo SQL nolwamagama kuba iingcali kule ndawo zifunwa enkulu kakhulu ihlawulwe naphi na ehlabathini. Ngoko ke, ukuba umntu onomdla ngale ndlela ngaphandle kweendleko kokulibazisa. Kufanele siqhubele ukufunda ngoku.

Yintoni ekufuneka ukuba ndiqale ukufunda

Ngophanya nje lweliso, kusenokubonakala ngathi le ndawo kunzima self-sifundo kwaye ifuna nonxibelelwano rhoqo kunye ingcali. Noko ke, oko akunjalo. Study ngezakhiwo neempawu I SQL yam, iqela ongundoqo ulwimi umbuzo kwaye yonke into enxulumene nayo, unako ngumnini, ngaphandle kokubhenela kwi uncedo umcebisi. Akwanelanga ukuba umnqweno kunye neenzame uqhubeke. i self-uphuhliso kunye sifundo sale ndawo Kuphela kuya kuvumela ukuba bafumane ulwazi olutsha, ukubethelela izakhono ezifunyenwe ze, mhlawumbi, qala ukwakha umsebenzi kwaye yokuhamba ngale ndlela.

Ukufunda imiyalelo esisiseko, okokuqala nje, kufuneka ukuba esandleni version simahla I SQL yam into eluncedo console. Ukuba inkqubo yokufunda iqala nayo. Uyakwazi ukulayisha ukusuka kwisiza MySQL esemthethweni. It is kalula sayo nayiphi na inkqubo yokusebenza, kusekwe umncedisi kunye umxhasi ngekhompyutha enye, kananjalo kube lula kakhulu.

Ngoko kuyimfuneko ukuba ukubhenela ukufumana incwadana yoqeqesho equlethe ulwazi olusisiseko malunga nokusingqongileyo I SQL. Console uyalela ukuba uphando ezisisiseko, njengoko umthetho, ke nabo equkethwe. Ulwazi malunga nale kakhulu lukhulu. Kodwa ke, kufuneka ukuba akhethe nzulu. Ulwazi kufuneka thaca gqolo kwaye yakhiwe ngokucacileyo.

Ukuba unolwazi olusisiseko kulwimi IsiNgesi, ungasebenzisa inkxaso console eyakhelwe-ngaphakathi. Ukulungiselela le njongo kukho umyalelo okhethekileyo uncedo, nto leyo eza kunceda ukuqonda ukusetyenziswa kwezixhobo I SQL.

Imiyalelo main console

A inguqulelo ezolileyo evela iimpawu ezingundoqo, izakhono kunye neenzuzo, sifika uluhlu imiyalelo esisiseko. I SQL yam eluncedo ekuqaleni iqulethe umsebenzisi omnye kuphela, nesetyenziswa nje isifundo. Lo msebenzisi obizwa ingcambu, ogama lokugqitha efanayo igama.

Xa uqala kuqala kunye elandelayo console I SQL yam umsebenzisi kuya kufuneka ukuba ufake igama eligqithisiweyo eliyingcambu, ngenxa yomsebenzi engaphezulu kunye DBMS I SQL. imiyalelo cli zifumaneka kuphela emva ungqinisiso ngempumelelo.

Emva kovavanyo ngempumelelo ukunceda, unako ukubonisa imiyalelo esele ngokusebenzisa umyalelo uncedo. Emva koko, lo console iya kuqhutywa kuzo zonke imiyalelo ezikhoyo kunye nenkcazo emfutshane kubo.

kwaye imiyalo control ukubonisa

Ngoku ke kufuneka ukuba uye kwinyathelo elilandelayo. Ukuze wenze oku, kufuneka ukhethe i ezikhoyo okanye yenza i uvimba entsha. Ukukhetha i-database ezikhoyo kufuneka asebenzise ukusebenzisa umyalelo. Esebenzisa umsantsa ukuba ufake igama ledatha. Ekuqaleni, le nkampani kukuba kukho mnye kuphela - onegama uvavanyo. Ngoko ke, lo mbuzo uya kukhangela ngolu hlobo: sebenzisa test.

Ukuze ukudala ledatha ufuna ukusebenzisa ukwenza umyalelo, ekhomba uvimba wakhe elingundoqo kunye ecacisa igama elifanelekileyo. Isakhiwo kuthatha le fomu ilandelayo: ukudala database Name_of_database. Ukusebenza kunye ziinkcukacha ezintsha ndikudalile oko kuyimfuneko ukusebenzisa ngokusebenzisa ukusebenzisa umyalelo.

Umthombo umsebenzi ukubonisa oovimba, iitheyibhile, amaqhosha zaseprayimari okanye uqhagamshelo zangaphandle kunye kukukhupha inkcazelo ekhoyo ngazo kwi SQL yam console. Amaqela kulo mzekelo kufuneka kusoloko aqala iziphakamiso kubonisa. Umzekelo, ukuba ukubonisa uluhlu lwe zolwazi ezikhoyo kumsebenzisi lwangoku, faka nje umbuzo olandelayo: bonisa zolwazi. Ukuze ukubonisa itafile ngokwaneleyo emva kokuba igama ukutshintsha uboniso into ngokubhala iitafile.

Team Management Tables

Ngaphambi kokuqhubeka ngakumbi, kuyimfuneko kwakhona ukukhumbula ukuba ukuthotyelwa kunye nomgangatho SQL ibonelela ngamathuba ngababhekisi phambili, kungakhathaliseki ukuba ledatha kunye operating systems. Izicelo eziphuhliswe na bume esixhasa umgangatho we SQL, kuya kusebenza ngempumelelo (xa database luyafumaneka, kunye neetafile) e MySQL bume. console imiyalelo Windows akukho ezahlukileyo kwezo zisetyenziswa kwezinye iindlela zokusebenza.

Spreadsheet kukho iqela imiyalelo engqalileyo, ukuba ukuguqulela ukuba IsiNgesi, athethe ngokwabo. On the ukwenza umyalelo okhankanywe ngasentla. Kananjalo kufuneka isebenze ukongeza iitafile kwiziko ledatha wadala ngaphambili. Ukususa izinto sedata ezifana nezintlu kunye wasebenzisa idrophu umyalelo, ukuba leyo ongeze igama kwinto yokuba kutshatyalaliswa. Umzekelo: imenyu igama _ of _ _ itafile yakho.

izicelo yobeko kumncedisi ledatha usoloko kubume jikelele. Ngoko ke, isicelo, eyenzelwe kwi Windows, yaye iya kusebenza kakuhle kwi SQL yam Linux console. Amaqela ngayo server ngaphandle impazamo enye kwinkqubo yokusebenza akakwazi kunokubangela iimpazamo kwabanye.

Khetha iqela

Kodwa ke eyona nto ibalulekileyo umyalelo spreadsheet kwezivakalisi ilula ngokwaneleyo, - khetha iqela. Oku kusetyenziswa ukukhetha data evela ledatha. Le lwesivakalisi original yile ilandelayo: khetha * evela itheyibhile _ igama. Ngokuthumela isicelo kumncedisi database, izigulana ezo kufuneka azifumane zonke iirekhodi ezigcinwe kule theyibhile.

Abantu abaninzi sicinge, kodwa xa ibrawuza izibonelelo Internet zisetyenziswa rhoqo I SQL yam imiyalelo. I-PHP-imibuzo sebenzisa lwesivakalisi SQL ulwimi ukubonisa imixholo yolawulo yeevenkile intanethi okanye iindaba networks zentlalo. Kunokuba i "*" emva Khetha asinike, njengokuba umthetho, uluhlu Ngowamasimi ezingundoqo itafile okanye iitheyibhile eziliqela ze data ukuba iphunyezwe. Kwimeko kweesampula ngokweetafile ezininzi, inyanda okhethekileyo ukujoyina, leyo isebenza ukudibanisa kubo unxulumano ezikhoyo lwangaphandle. Nangona kunjalo, le meko kufuneka itshintshwe ebonisa ngokuzimeleyo eyiphi imihlaba kufuneka kwenziwe udibaniso.

Ukubeka imigoqo isampula

Maxa wambi kukho imeko apho impendulo evela kwiseva database iqulethe iinkcukacha phindo. Ukuze ukuba umsebenzisi abe amangeniso ebonakalayo kuphela, kusetyenziswa ukunikela eyahlukileyo. Ibekwe phambi kokuba uluhlu Amasimi bacela kwaye lisebenza njengoncedo ukufihla zifane.