MySQL - kafufuzidwe mu funso. MySQL: Zitsanzo kafufuzidwe. mafunso ophatikizidwa MySQL

Panopa munthu aliyense akhoza kuona kuwonjezeka mofulumira mudziwe yadigito. Ndipo kuyambira zambiri zimenezi n'kofunika, m'pofunika adzausunga mu mawonekedwe digito ntchito m'tsogolo. Imeneyi, zikhoza kugwiritsidwa ntchito umisiri wamakono monga zinasokoneza makompyuta. Iwo amapereka yosungirako odalirika aliyense digito mfundo ndi deta mwayi angathe kuchitidwa nthawi imene padziko lapansi. Mmodzi wa umisiri pansi kulingalira ndi dongosolo la MySQL zinasokoneza makompyuta.

DBMS MySQL - ndi chiyani ichi?

A ubale kasamalidwe dongosolo Nawonso achichepere MySQL ndi imodzi mwa njira zamakono wotchuka kwambiri ndipo amagwiritsidwa ntchito yosungirako. magwiridwe ake ndi amphamvu zambiri ndi Nawonso achichepere alipo. Makamaka, chimodzi mwa zinthu zazikulu ndi luso logwiritsa ntchito ophatikizidwa mafunso MySQL.

Choncho, ambiri mwa ntchito, kumene nthawi n'kofunika kwambiri ndipo pofuna yosungiramo mudziwe ntchito, komanso kuchita zitsanzo zovuta deta akupangidwa pa MySQL Nawonso achichepere. Ambiri zimenezi kupanga Websites. Pankhaniyi, MySQL lichitidwa ankalimbikitsa mu kukhazikitsa (Mabulogu, webusayiti, ntchito makadi ndi zina zotero. P.) ang'ono Ndipo mavuto m'malo lalikulu (Intaneti kugula, yosungirako deta , ndi zina zotero. D.). Nthawi zonse, kuwonetsera kwa nkhani pa tsamba ntchito MySQL-kafufuzidwe. Pempho kwa kutukula ankafuna kwambiri za mwayi anapereka Nawonso achichepere Management System.

Kodi tiyenera bungwe osungira

Pakuti yosungirako yabwino ndipo anayamba processing deta kwenikweni analamula. Kapangidwe deta kudziwa mmene tebulo lidzaonekera, amene ntchito kusunga malangizo. matebulo Nawonso achichepere ndi m'ndandanda wa minda (mizati) lolingana kwa aliyense katundu zenizeni za chinthu deta.

Mwachitsanzo, ngati tebulo ya ogwira ntchito ku kampani inayake, ndi dongosolo losavuta kwambiri adzakhala motere. Pakuti aliyense wogwira ntchito amamangiriridwa chiwerengero wapadera, amene kawirikawiri ntchito ngati kiyi yaikulu ku gome. Ndiye tebulo zalembedwa deta wantchito. Izo zikhoza kukhala chirichonse: dzina Full, Khadi, chomwe chili, foni, adiresi, ndi zinthu zina. Malinga ndi malamulo a normalization (6 njira yachibadwa ya zinasokoneza makompyuta) komanso MySQL-mafunso alimbane kusasintha minda ya tebulo ayenera atomiki, kuti si kuti enumerations kapena mndandanda. Choncho, kawirikawiri, tebulo, pali minda osiyana dzina lomaliza, dzina loyamba, ndi zina zotero D..

Pamwamba ndi chitsanzo zazing'ono ya kapangidwe Nawonso achichepere tebulo. Komabe, komabe si kwathunthu akwaniritsa zofunikira yofunika kwambiri ya normalization. M'magulu weniweni, amalenga zina tebulo zigawo. Choncho, tebulo zotsatirazi mmalo mwa mawu "Dipatimenti" ndime ayenera muli angapo m'madipatimenti.

Kodi chitsanzo deta

Kupeza kafukufuku matebulo mu kasamalidwe dongosolo Nawonso achichepere MySQL, wapadera timu - Select kafufuzidwe. Kwa Seva Nawonso achichepere molondola anachita apilo, pempho ayenera bwino anapanga. kafufuzidwe dongosolo aumbike motere. Aliyense kupeza makina Nawonso achichepere imayamba ndi nfundo yaikhulu sankhani. Iwo anali naye anamanga onse MySQL mafunso. Zitsanzo zikhoza kukhala cha kapangidwe osiyana, koma mfundo ya zomangamanga ndi ofanana kwambiri.

Inu ndiye ayenera mwachindunji amene minda mukufuna kusankha mfundo ankafuna. Limatchula minda kudutsa koma pambuyo maganizo kusankha. Kamodzi minda zonse chofunika akhala kutchulidwa pempho n'chakuti tebulo chinthu imene chitsanzo zidzachitika mothandizidwa ndi malangizo ochokera ndipo mutchule dzina pa tebulo.

Sangathe kuchita zitsanzo zosankhidwazi mu MySQL-mafunso akuwonjezeka ntchito yapadera, malinga Nawonso achichepere. Chitsanzo unduplicated (wapadera) deta ntchito angabwereze kuyitana osiyana, ndi kuyika zinthu - ndi woyendetsa kumene. Mwachitsanzo ntchito tebulo pamwamba, tingaganizire pempho udzafunidwa mudziwe Dzina ogwira ntchito ntchito mu dipatimenti "Sales". kafufuzidwe dongosolo umakhala ngati tebulo pansipa.

Lingaliro la kafufuzidwe Mathithiŵa

Koma mbali yaikulu ya Nawonso achichepere, monga tatchulazi, luso kuti agwire bwino ophatikizidwa mafunso MySQL. Chioneke motero? Ku dzina nawatsimikizira izo zamveka kuti ndi pempho kwaiye mu ufumu wa zopempha awiri kapena kuposa. Chiphunzitso, ndi kuphunzira peculiarities wa Nawonso achichepere limanena kuti MySQL si kuchepetsa chiwerengero cha MySQL-mafunso amene angathe zinapeza malo okhala mu kafufuzidwe chachikulu. Komabe, mukhoza kuyetsa kuchita ndipo onetsetsani kuti pambuyo wachiwiri khumi Mathithiŵa kafufuzidwe Poyankha nthawi kuti kwambiri kuonjezera. Mulimonsemo, kuchita pali mavuto amene amagwiritsa ntchito zovuta MySQL-kafufuzidwe. pempho angafunike pazipita 3-5 kudzipweteka Mathithiŵa.

Ntchito yomanga mafunso Mathithiŵa

Mu kusanthula mfundo Werengani, mafunso angapo za komwe boma mafunso, ndipo ngati simungathe kuthetsa kugawa iwo mu losavuta popanda complicating dongosolo angagwiritsidwe ntchito. Zochita, boma mafunso ntchito pothetsa mavuto zovuta. Chotero mtundu wa mavuto zochitika pamene samadziwika pasadakhale mavuto malire amayamikira zitsanzo zosankhidwazi zina zidzachitika. N'zosatheka kuti athetse mavuto amenewo, ngati inu ntchito zonse MySQL-kafufuzidwe. Mu pempho, wopangidwa mwa utsogoleri wolowezana, adzakhala kufufuza zoletsa kuti akhoza kusintha pa nthawi kapena pasadakhale angathe silikudziwika.

Ngati tikambirana tebulo pamwamba, chitsanzo chotsatirachi ndi ntchito zovuta. Tiyeni tinene tiyenera kudziwa zinthu zofunika zokhudza ogwira ntchito amene ali wamng'ono Grishina Grigoriya Grigorevicha, yemwe ndi mutu wa malonda. Mu kupanga funso sitikudziwa chizindikiritso nambala yake. Moti poyamba tiyenera kudziwa izo. Limagwiritsa ntchito kafufuzidwe osavuta kuti adzapeza mawu waukulu mlandu ndipo amathandizana waukulu MySQL-kafufuzidwe. pempho chimasonyeza kuti subquery afika wantchitoyo ID number, zomwe zina amasonyeza malire a kafufuzidwe chachikulu:

Pankhaniyi, malingaliro ntchito kuteteza zosayembekezereka zolakwa, ngati ogwira ntchito ndi Maina amenewa adzakhala ochepa.

zotsatira

Kuti adzimvera, tisaiwale kuti pali zina zambiri mbali zina kwambiri atsogolere ntchito yomanga funso, monga DBMS MySQL - chida champhamvu ndi osiyanasiyana zida yosungirako ndiponso pokonza.