"Zinthu Zofunika" DML-Team Pezani MySQL

Aliyense mapulogalamu, amene anali kugwira ntchito ndi zinasokoneza makompyuta, anakumana ndi DML-ntchito (anawamasulira kuchokera English - .. "Data Kupotoza Language"), monga Select, Ikani, Chotsani ndi Pomwe. MySQL-zoyendera amagwiritsanso ntchito zida za malamulo onse a pamwamba.

mawu awa, nawatsimikizira akulankhula za kusankhidwa - timva kusankha, kumanga mfundo yatsopano, kasinthidwe deta zilipo wonse, kapena mogwirizana ndi mmene ananenera, kuchotsa mfundo Nawonso achichepere. The ongolankhula zofunikira pophunzitsa atsogoleri atsopano ndi anafotokoza mfundo ya ntchito lamulo lililonse ndi malembedwe awo, koma paliponse anapeza otchula mavuto amene tingakhale kuchita pa ntchito. Nkhanizi zidzagwiritsidwa ntchito kuzochita zochita za ena a iwo.

Mwachidule za DML-mawu (Ikani)

Akuyendera zina, m'pofunika kamodzinso kukumbukira zambiri za cholinga cha aliyense ntchito. Tidzakhala ndi ntchito ziwiri chidwi mwatsatanetsatane: Ikani ndi Pomwe, chifukwa izo zimatengera iwo amapeza mavuto chachikulu processing yambiri deta.

Muyenera kuyamba ndi Ikani lamulo, ndiyeno pang'onopang'ono kusuntha kwa Pezani. MySQL dongosolo, ngati wina aliyense Nawonso achichepere masiku ano, ntchito Ikani ntchito kuwonjezera timva zatsopano matebulo alipo Nawonso achichepere. The malembedwe a ntchito imeneyi ndi lophweka komanso osapita m'mbali. Lili m'ndandanda wa minda yomwe adzapatsidwa ndi mfundo, ndi kopita - dzina la gome - ndipo pomwepo anayambitsa mndandanda deta. Nthawi iliyonse kuchita Ikani Nawonso achichepere adzakhala kusinthidwa ndi makhalidwe atsopano.

Pezani mawu

Komabe, mu kuchita, nthawi zambiri pali zinthu zimene ena ya deta imodzi kapena mfundo zambiri chikhumbo kuti kusinthidwa. Mwachitsanzo, vuto limene kampani anali kusintha ndi renaming zina m'madi- waukulu. Pankhaniyi m'pofunika kusintha kwa aliyense dipatimenti. Ngati kokha kusintha dzina, ndiye vuto zingathe kuthetsedwa mwamsanga. Komabe, ngati kusintha 'kala' ikusonyeza aliyense zikuluzikulu za ulimi lonse, zomwe kawirikawiri akutumikira monga kiyi chachikulu, amene ali, nayenso, kumatanthauza kusintha kwa mfundo ndi aliyense wantchito.

Pezani - DML-woyendetsa ingagwiritsidwe ntchito vutoli. MySQL- Seva, amachita zambiri zolemba, mothandizidwa ndi mawu pomwe, aphe kafufuzidwe chofunika ndi kuthetsa vutolo. Koma nthawi zina kumachitika nthawi pomwe si bwino ndithu ndi zovuta zovuta kumvetsa. Icho ndi chimene chimayambitsa vuto kulembamo kusinthidwa, tikambirana zina.

Kodi pang'ono zanenedwa chiphunzitso ...

Pezani Team, monga taonera kale, ntchito zosinthika timva alipo tebulo. Komabe, makasitomala kupeza maseva Nawonso achichepere si kalekale, pali ena ya deta mu matebulo kapena ayi. Kuyambirira onani kupezeka kwa deta mu Nawonso achichepere kwa updating wotsatira wa zotsatira mu nthawi yambiri ndipo akungotaya mphamvu Seva.

Popewa izi, mu wapadera kapangidwe Nawonso achichepere MySQL - Ikani * Pezani, imene Ikani kapena pomwe angathe kuchitidwa paokha wina ndi mzake. Apo ndi pamene tebulo ali ndi kulowa kwa chikhalidwe makamaka, adzakhala kusinthidwa. Ngati zinthu zatchulidwa, deta adzafufuzidwa koma sadzapezeka, MySQL-Seva watha kuchita deta uploads pempho.

Pezani deta pamene pali Zobwerezedwa

Mbali yofunika kwambiri ya Ikani ichi - pempho dongosolo MySQL kasamalidwe Nawonso achichepere - «Pa obwerezabwereza Ofunika Pezani» manambala oyambirira. The malembedwe lathunthu la funso ili: «amaika mu test_table (employer_id, dzina) mfundo ( 1, 'Abramov') pa chibwereza kiyi pomwe last_modified = TSOPANO (); ".

Amenewa pempho akhoza ankagwiritsa pojambula zimene Mwachitsanzo, kudziwa mphambano ndimeyi nthawi ogwira anatsatira mwa kuwerengera nthawi imeneyi ndi kudziwika yomweyo. Pofuna kuti tebulo timva ochepa, moti aliyense wogwira ntchito kusunga malipoti ndi kasinthidwe zonse. Ndi chibwereza cheke kapangidwe chololera.

Ndipotu mavuto ...

Chitsanzo pamwamba chonse ndodo kanthu pakhomo, monga vuto ndi ntchito samouvelichivayuschihsya (galimoto _ increment) minda, omwe amagwiritsidwa ntchito lembani mfundo yaikulu kiyi (chachikulu _ kiyi). Ngati mumamwa MySQL Pezani lamulo zomangidwa ndi Ikani galimoto _ increment, munda nthawi zonse kuwonjezeka.

Mofananamo, chilichonse chimachitika pamene ntchito yomanga m'malo zinachitikira kudziwika chibwereza. "Auto-increment" mtengo kwambiri chifukwa ngakhale choncho kumene osafunika. Chifukwa cha ichi, mavuto zikusefukira chikudutsa mfundo kapena aataliatali, amene kenako kuyambitsa wonongeka kachitidwe kasamalidwe Nawonso achichepere.

Ambiri mwina vuto

Akufotokoza vuto ayenera kuwaganizira Web-kutukula, monga ambiri mu kachitidwe Mipikisano wosuta (Websites, makonde, ndi zina zotero. P.), Pamene dongosolo ndi kuphedwa ambiri njira Ikani ndipo kuonjezera MySQL.

Php - Kudandaula m'munsi pa nthawi anachita. Choncho, kukwaniritsa masamba pazipita wofotokozedwa kukhala auto_increment, amapezeka mofulumira, ndipo mu kusanthula mavuto anakumana kukhazikitsa zifukwa sizingagwire ntchito basi.

Choncho, kutukula akulimbikitsidwa kuganizira kugwiritsa ntchito kulengedwa chibwereza zikuluzikulu lamulo MySQL pomwe. kusankha - mafunso pamene kupeza ndi Nawonso achichepere Seva ntchito popanda cholakwa, koma Kuwonjezera kulembamo zatsopano Nawonso achichepere ndi zinadzala ndi zinthu zosasangalatsa akutsogolereni tsogolo mavuto aakulu. Kapenanso, izo akulimbikitsidwa minda galimoto-increment poyamba onani mayina awo, kenako adzawalange kusinthidwa.