MySQL - umbuzo nombuzo. MySQL: izibonelo nombuzo. imibuzo Embedded MySQL

Okwamanje, umuntu ngamunye zingabuka nokukhula ngokushesha ulwazi wedijithali. Futhi njengoba okuningi lolu lwazi kubalulekile, kubalulekile ukuwulondoloza ngendlela yedijithali ukuze zisetshenziswe esikhathini esizayo. Kulesi simo, ingasetshenziswa ubuchwepheshe sesimanjemanje njenge yolwazi. Zinikeza isitoreji onokwethenjelwa noma yiluphi ulwazi kanye nedatha digital ukufinyelela engenziwa nganoma yingasiphi yembulunga. Omunye ubuchwepheshe olucutshungulwayo wuhlelo MySQL yolwazi.

DBMS MySQL - Iyini?

A zingubudlelwane ngabaphathi semininingwane uhlelo MySQL ingenye ethandwa kakhulu futhi evame ukusetshenziswa isitoreji ubuchwepheshe. Ukusebenza Its luphakeme ngezindlela eziningi database ekhona. Ikakhulukazi, esinye sezici eziyinhloko yikhono ukusebenzisa imibuzo esishunyekiwe MySQL.

Ngakho-ke, amaphrojekthi amaningi, lapho isikhathi kubalulekile futhi kuyadingeka ukuqinisekisa isitoreji ulwazi ukusebenza, kanye ukwenza amasampula idatha eziyinkimbinkimbi isakhiwa ku database MySQL. Iningi yalezi zigigaba ukuba amawebhusayithi. Kulokhu, MySQL wenziwa kugqugquzelwa ukuqaliswa abancane (blogs, iwebhusayithi, amakhadi ibhizinisi nokunye. P.) Futhi izinkinga esikhundleni esikhulu (bethenga online, isitoreji idatha , nokunye. D.). Kuzo zombili lezi zimo, ngokubonisa ulwazi ikhasi lewebhu esetshenziswa MySQL-nombuzo. Isicelo konjiniyela uzama ukwenza iningi amathuba ahlinzekwa Database Management System.

Indlela kufanele isitoreji ihlelwe

Ukuze isitoreji elula nokucubungula okwalandela idatha ngempela ngaphambilini. Isakhiwo idatha ukuthola indlela etafuleni izobukeka, ezisetshenziswa ukugcina ulwazi. Database amatafula iqoqo Amasimu (amakholomu) elihambisana ngayinye impahla ethize into idatha.

Ngokwesibonelo, uma ithebula abasebenzi inkampani ethile, kuba isakhiwo kunazo elula kuyoba kanje. Ukuze umsebenzi ngamunye unamathele inamba engafani, ngokuvamile lisetshenziswa njengedivaysi ukhiye oyihloko etafuleni. Khona-ke ethebuleni elotshiwe ukwaziswa okuphathelene nabasebenzi. Kungaba yini: Igama eligcwele, inombolo yekhadi, okuyiwona wona iqinile, yocingo, ikheli kanye neminye imininingwane. Ngokusho nezidingo ukuzinza (6 amafomu evamile yolwazi) kanye MySQL-imibuzo ujenga Amasimu olwakhiwe kwetafula kumele kube athomu, okungukuthi, hhayi ukuba enumerations noma uhlu. Ngakho-ke, ngokuvamile, ethebuleni, kukhona amasimu ehlukile isibongo, igama lokuqala, nokunye. D.

Ngenhla isibonelo eziwubala isakhiwo ithebula egciniwe. Nokho, kusenzima hhayi ngokugcwele nezidingo ezibalulekile of ukuzinza. In izinhlelo real, lidale izigaba ithebula ezengeziwe. Ngakho-ke, ithebula esikhundleni amagama "uMnyango" ikholomu kufanele iqukathe eminyangweni eminingana.

Kangakanani isampuli idatha

Ukuze ubuyise i-data esuka amathebula in uhlelo lokuphathwa database MySQL, ithimba eliyisipesheli - Khetha umbuzo. Ukuze iseva semininingwane kahle asabela ngayo sikhalo, sicelo kumele eyakheke kahle. kwakhiwa isakhiwo nombuzo is kanje. Noma yimuphi ukufinyelela leseva database iqala ngamadijithi elisemqoka khetha. Kwaba naye eyakhelwe zonke imibuzo MySQL. Izibonelo kungaba yinkimbinkimbi ezahlukene, kodwa isimiso sokwakha kuyafana.

Khona-ke kufanele ucacise ukuthi yiziphi izinkambu ufuna ukhethe ulwazi olufunayo. Ubala izinkambu ababhekene ukhefana ngemva iziphakamiso ukhetha. Uma zonke izinkambu ezidingekayo ziye ezisohlwini isicelo icacisa into etafuleni kusukela lapho isampula kuzokwenzeka ngosizo iziphakamiso ezivela futhi ucacise igama etafuleni.

Ukuze amasampuli zihibe MySQL-imibuzo kunezelwa opharetha ekhethekile, inqobo database. Ukuze isampula unduplicated idatha (esiyingqayizivele) esetshenziswa ukuvalelisa egqamile, futhi ukusetha izimo - opharetha lapho. Njengoba isibonelo kusebenza lelingenhla, singacabangela isicelo efuna ukuphuca ulwazi Igama abasebenzi abasebenza eMnyangweni "Sales". isakhiwo umbuzo ithatha ifomu njengoba kuleli thebula elingezansi.

Umqondo umbuzo isichazi

Kodwa isici esiyinhloko database, njengoba kushiwo ngenhla, ikhono isibambo esishunyekiwe imibuzo MySQL. Kufanele ibukeke? Kusukela igama ngokunengqondo ke baqonda ukuthi lesi isicelo eyenziwe ngo yokwehlayo izicelo ezimbili noma ngaphezulu. Okwazekayo, ngokutadisha izici database lithi MySQL akasibekeli inani MySQL-imibuzo ukuthi kungenziwa owakhe isidleke sakho phakathi nombuzo main. Nokho, ungakwazi ukuhlola practice futhi uqinisekise ukuthi emva yesibili eziyishumi nombuzo isichazi Ukusabela isikhathi ukwandisa sina. Kunoma ikuphi, practice zikhona izinkinga ezidinga zisebenzisa esiyinkimbinkimbi kakhulu MySQL-nombuzo. Isicelo kungadinga esiphezulu 3-5 Ukuhleleka kokuhlala ahlanganisiwe.

Ukwakhiwa imibuzo isichazi

Esikhathini ukuhlaziya ulwazi kumelwe afundeke ngokuthi, imibuzo eminingi mayelana lapho sub-imibuzo, futhi uma ungakwazi ukuxazulula le nkinga sokuhlukanisa wabayisa elula ngaphandle nzima isakhiwo ingasetshenziswa. Ekusebenteni, sub-imibuzo zisetshenziselwa ukuxazulula izinkinga ezinzima. uhlobo enjalo zezinkinga izimo lapho kungaziwa kusengaphambili izimo umkhawulo uyakwazisa izibonelo zalokho okwengeziwe kuyokwenzeka ngaphansi okuyinto. Akunakwenzeka ukuba baxazulule izinkinga ezinjalo, uma nje usebenzise njalo MySQL-nombuzo. Ngo isicelo, ehlanganisa esigaba sabefundisi, kuyoba search imikhawulo angashintsha ngesikhathi noma kusengaphambili ayikwazi ezaziwayo.

Uma sicabanga lelingenhla, isibonelo esilandelayo kuwumsebenzi eziyinkimbinkimbi. Ake sithi kudingeka sazi ulwazi oluyisisekelo mayelana abasebenzi okhonzile Grishina Grigoriya Grigorevicha, ngubani inhloko yokuthengisa. Ngo obumba nombuzo asazi inombolo yayo umazisi. Ngakho ekuqaleni sidinga ukwazi ke. Lisebenzisa nombuzo elula ukuthi uzothola imigomo eyinhloko isinqumo futhi azokusizana main MySQL-nombuzo. Isicelo libonisa ngokucacile ukuthi subquery uthola inombolo ID yesisebenzi, elibuye ichaza kumkhawulo nombuzo main:

Kulokhu, imuphi umbono isetshenziswa ukuvimbela okuvela kuyo amaphutha, uma abasebenzi nge zokuqala okunjalo kuyoba ambalwa.

Imiphumela

Kufinyeta, kufanele kuphawulwe ukuthi zikhona nezinye izici eziningi ezengeziwe lula kakhulu ukwakhiwa nombuzo, njengoba DBMS MySQL - iyithuluzi elinamandla nge amathuluzi anhlobonhlobo ngoba izinqubo zokulondoloza.