"Ngaahi tō'anga" DML-Team Whakahōu MySQL

Katoa rorohiko, nei i ki te mahi ki pātengi raraunga, fehangahangai ki te DML-ngā (whakamaoritia i English - .. "Raraunga whawhe, Reo"), pērā i Tīpakohia, Kōkuhu, Muku a Whakahōu. whakamahi hoki MySQL-waka ona täoro o katoa o nga whakahau i runga ake.

E arorau ēnei tauākī korero e pā ana ki tona whakarite - pūkete kōwhiri, te kōkuhu uara hou, whakahōu raraunga tīariari, oti, i roto i runga i te tikanga i whakaritea, te tango o te kōrero i roto i te pātengi raraunga ranei. Kua whakaahuatia te rauemi whakangungu ariā i roto i te taipitopito te parau tumu o te mahi o ia whakahau, me to ratou wetereo, engari wahi kitea tohutoro ki te mau fifi e ai ara ake i roto i te mahi i roto i te whakamahi. Ka kia oti rawa tēnei rauemi ki te whakaaro o etahi o ratou.

Poto e pā ana ki DML-tauākī (Kōkuhu)

I mua i puta atu, he kotahi ano reira e tika ana ki te haamana'o ētahi atu kōrero e pā ana ki te whakaaro o ia mahi. Ka whai tatou e rua ngā hiahia i roto i te taipitopito atu: Kōkuhu a Whakahōu, no te mea tei reira ki runga ki a ratou ahu i te mau fifi matua i roto i te tukanga nui o ngā raraunga.

Me tīmata koe ki te Kōkuhu whakahau, a ka āta neke ki te Update. pūnaha MySQL, rite tetahi atu pātengi hou, te whakamahi i te mahi Kōkuhu ki te tāpiri i ngā pūkete hou ki ngā tepu pātengi raraunga. Ko te wetereo o tenei mahi he tino māmā, me te māmā. Oku i ai e he rārangi o mara ka e kia hanga ki te uara, te ūnga - ingoa o te tepu - a tonu whakaurua he rārangi o ngā raraunga. ka mau taime atoa e mahi koe i te pātengi raraunga Kōkuhu kia whakahoutia ki ngā uara hou.

tauākī Whakahōu

Heoi, i roto i te mahi, tino maha i reira he āhuatanga e mo etahi huinga o raraunga tetahi atu uara huanga ranei ki te whakahou. Ka rite ki te tauira, he āhuatanga i reira ko te kamupene whakahou ki Whakaingoa Anō atu o nga tari matua. I roto i tenei take, ko te mea e tika ana ki te hanga huringa mo ia tari. Ki te huri i te ingoa anake, ka taea te whakatika rawa hohoro te raruraru. Heoi, ki te huri i te waehere o ia wāhanga o te hanga katoa, e te nuinga o te kaimahi rite te kī tuatahi, e he, i roto i te tahuri, e titau huringa ki te mōhiohio me te mo ia kaimahi.

Update - DML-operator taea te tono ki te whakaoti i te rapanga. tūmau MySQL-, mahi ana ki te maha nui o ngā tāurunga, me te awhina o te tauākī whakahou, mahia te uiui e hiahiatia ana, ka whakatau i te raruraru. Ko ētahi wā puta i roto i kore te mea tino mārama, me te uaua te whakahou ki te whakamārama whīwhiwhi. Ko te mea ai te uaua o ngā pūkete whakahoutia, ka kia kōrero atu.

He aha iti i mea kua i roto i te ariā ...

Whakahōu Team, rite tuhia i runga ake, kua whakamahia ki te whakahou i ngā pūkete ngā i roto i te tepu. Otiia i roto i te mahi, e kore e kiritaki whakauru i te tūmau pātengi raraunga mohiotia tonu, i reira te mea he tetahi huinga o ngā raraunga i roto i te papa e kore ranei. Hukihuki tirohia te wātea o ngā raraunga i roto i te pātengi raraunga mo te whakahōu muri o hua i roto i te wa-e kai ana me te ururua o kaha tūmau.

Ki te karo i tenei, i roto i te hanganga pātengi raraunga MySQL motuhake - Kōkuhu * Update, i roto i nei e taea te whakamana i te whakauru whakahou ranei takitahi o ia atu. Ko ina kua he urunga mo te huru ngā te tepu, ka kia whakahoutia. Ki te nga tikanga whakaaro, nga raraunga ka kore e kitea, e taea ki te mahi i tono tukunga raraunga MySQL-tūmau ko.

Whakahōu raraunga ka reira he tārite

He wae nui o tenei Kōkuhu - tono ki te pūnaha whakahaere pātengi raraunga MySQL - «I Tārua Key Update» kuhimua. Ko te wetereo oti o te rapu ko e whai ake: «kōkuhu ki test_table (employer_id, ingoa) uara ( 1, 'Abramov') i runga i matua tārite whakahou last_modified = NOW (); ".

Ka taea te whakamahi i te tono taua ki te tuhi i nga mahi o, mo te tauira, te whakatau i te hinonga wā whakawhitinga irava aru e tatau wā wā, me te kite roa. I roto i te tikanga e kore e ki te hanga i te tepu i te torutoru pūkete, nui hoki ia kaimahi ki te pupuri i ngā pūkete ki tonu whakahōu. Ko te hoahoa Taki tārite taea reira.

Mau raruraru ...

Whakaaro i te tauira i runga ake o te rēhita mahi ngā kaimahi i te tomokanga, rite te raruraru ko te whakamahi samouvelichivayuschihsya (aunoa _ nuku) mara, e e te nuinga whakamahia ki te whakaki i te uara matua tuatahi (kī _ tuatahi). Ki te kei te whakamahi koe i MySQL Update whakahau i roto i te hoahoa ki Kōkuhu auto _ nuku, kei te piki haere tonu te mara.

Waihoki, tupu katoa ka whakamahi i te hanga whakakapinga i te take o te kitenga tārite. nui haere "nuku-aunoa" uara te ara i roto i te take te wahi e kore e te hiahiatia reira. No te mea o tenei, ara ake raruraru uara waipuke haere awhe ranei, e muri arahi ki arā o ngā pūnaha whakahaere pātengi raraunga.

Te nuinga pea te raruraru

Whakaahua ana me whakaaro te raruraru Tukutuku-ngā, rite he reira tino noa i roto i ngā pūnaha maha-kaiwhakamahi (tukutuku, papa matotoru hoki, a pera i runga i. P.), ka mahi i te pūnaha te he maha nui o ngā tukanga Kōkuhu a Whakahōu MySQL.

rawa maha whakamana piira ki te turanga - PHP. Na reira, ki te whakatutuki i tawhē mōrahi, tautuhia rite auto_increment, puta tere, me i te tātaritanga o te fifi tūpono ki te whakatū i te take e kore tika e mahi.

Na reira, kei te ākina ngā ki kia tahuri ki te whakamahi o te hoahoa i runga i te kī tārite i roto i te whakahou whakahau mysql. tīpako - pātai ka whakauru ka mahi i te tūmau pātengi raraunga, kahore he, engari, he mahi wehe ki ngā āhuatanga kino i roto i te mata a muri ki raruraru nui te tua o pūkete hou ki te pātengi raraunga. Tērā, e tūtohu ana hoki mara nuku-aunoa te tīmatanga tirohia mo ratou pūkete, a ka mau ratou whakahoutia.