"Ngozi" DML-Team Update MySQL

programmer ose, akanga kushanda Databases, atarisana DML-dzaishandisa (rakashandurwa kubva Chirungu - .. "Data kumonyanisa Language"), akadai Sarudza, Insert, Kudzima uye Update. MySQL-senga anoshandisawo ayo zvombo zvose zviri pamusoro mirayiro.

Mashoko aya zvine musoro kutaura kwake kugadzwa - zvinyorwa kusarudza, pinza tsika itsva, updating huripo data, zvakakwana, kana maererano raanotaura ezvinhu, kubviswa mashoko ari Database. The yokungotaura kudzidzisa zvinhu zvinotsanangurwa zvakadzama musimboti hwokushanda murayiro mumwe vavo nemarongerwo, asi hapana kuwanikwa nezvechisikwa matambudziko kungamuka mune tsika panguva kushandiswa. Izvi zvinhu uchanamatira kune kufunga vamwe vavo.

Muchidimbu pamusoro DML-mitsara (Insert)

Asati rwuchibuda mberi, zvakakodzera kamwe zvakare kuyeuka zvakawanda nezvechinangwa nechimwe basa. Tichava dzaishandisa mbiri kuziva zvakadzama: Insert uye Update, nokuti zvinoenderana navo zvinowana nematambudziko huru kugadzirisa yakawanda mashoko.

Unofanira kutanga murayiro Insert, uye ipapo zvishoma nezvishoma vachienda Update. MySQL maitiro, kufanana nemamwe Database chero ano, shandisa Insert oparesheni kuwedzera zvinyorwa zvitsva zviripo matafura Database. The nemarongerwo oparesheni iri nyore chaizvo uye yakananga. Rine dzokushandura minda izvo vachaitwa kuti tsika, kunzvimbo - zita tafura - uye pakarepo akazivisa mazita mashoko. Pose iwe basa Insert Database vachapiwa yoku- anokoshesa itsva.

Update statement

Zvisinei, muna tsika, kazhinji pane mamiriro ezvinhu kuti vamwe akaita mashoko mumwe kana kupfuura chizenga tsika kuti yoku-. Somuenzaniso, mamiriro ezvinhu apo boka rakanga kuchinja mimwe renaming huru madhipatimendi. Muchiitiko ichi zvakakodzera kuchinja nechimwe dhipatimendi. Kana chete kuchinja zita, zvino dambudziko anogona kugadziriswa nokukurumidza chaizvo. Zvisinei, kana kuchinja Coding nerimwe chezvinonhuwira pagadzirwe yose, izvo kazhinji anoshumira chikuru kiyi, kuti iri, uyewo, rinobatanidza kuchinja kuti ruzivo uye kuti mushandi mumwe nomumwe.

Update - DML-opareta ingashandiswa kugadzirisa dambudziko iri. MySQL- Server, kushanda pamwe vakawanda vakanyoresa, achibatsirwa MASHOKO EZVAKAITIKA mashoko, tongai runodiwa mubvunzo uye kugadzirisa dambudziko. Asi kunomboitika panguva update haisi pachena chaizvo uye zvakaoma kutsanangura kunzwisisa. Ndizvo zvinoita kuoma zvinyorwa akagadziridzwa, huchakurukurwa.

Chii shoma rave akati dzidziso ...

Update Team, sezvataurwa pamusoro apa, inoshandiswa dzifambirane huripo zvinyorwa zviri patafura. Asi tsika, vatengi angadaro ari Database servers hakusi kuzivikanwa, pane akagadzirwa mashoko ari pamabwendefa kana kwete. Rokutanga tarisa Kuwanikwa mashoko ari Database nokuda zvakazosunungurwa updating nezvibereko nguva uye kutambisa Server nezvaanogona.

Kuti izvi zvisaitike, rinokosha Database MySQL mamiriro - Insert * Update, umo muwedzero kana kunatsurudza kunogona kuitwa tisingatungamirirwi mumwe. Ndiko kana tafura aine kupinda chimwe chinhano, vachaparadzwa yoku-. Kana mamiriro ezvinhu vaiona, humboo hazvizowaniki, MySQL-Server anokwanisa kuita mashoko Uploads chikumbiro.

Update Data kana paine akagadzirwa zvakafanana

An rokuti anokosha Insert ichi - chikumbiro kuna MySQL Database utariri hurongwa - «On kutevedzera Key Update» chivakashure. The nemarongerwo ari mubvunzo kwakakwana uri sezvinotevera: «pinza kupinda test_table (employer_id, zita) tsika ( 1, 'Abramov') pamusoro nouya anokosha update last_modified = NOW (); ".

chikumbiro kwakadaro kungashandiswa kunyora zviito Somuenzaniso, kuziva mharadzano ndima nguva zvebhizimisi achiteverwa yekuverenga nguva penguva uye vasabatwa kunonoka. Kuti varege kuita tafura zvinyorwa vashoma, zvokuti mushandi mumwe nomumwe kuchengeta zvinyorwa vane kugara updating. Zviri nouya Check chakagadzirwa anosiya.

Chokwadi matambudziko ...

Tichifunga zviri pamusoro apa muenzaniso kunyoresa mudonzvo chiito pasuo, sezvo dambudziko iri kushandiswa samouvelichivayuschihsya (repair _ increment) minda, izvo yemanyorero kushandiswa kuzadza chikuru chinoita tsika (chikuru _ kiyi). Kana uri kushandisa MySQL Update murayiro mu akaitwa pamwe Insert repair _ increment, munda kuramba ichiwedzera.

Saizvozvowo, zvose zvinoitika apo uchishandisa yokutsiva kuvakwa pana nouya vasabatwa. "Auto-increment" ukoshi ichiwedzerwa kunyange nyaya apo haina kudiwa. Nokuda kwaizvozvi, zvinetso dzakayerera kupfuure tsika kana neeSultan, vakazochinja kutungamirira atadze kushanda zvakanaka nokuda Database utariri enyika.

Ungangove dambudziko

Rinotsanangura dambudziko inofanira kukurukurwa Web-Developers, sezvazviri Inonyanya kubata multi-User mugadziriro (Websites, nezvikumbaridzo, uye zvichingodaro. P.), Kana gadziriro vaurayiwa vakawanda maitirwo Insert uye Update MySQL.

PHP - kuteterera zvitsigiro kakawanda anoitwa. Naizvozvo, kuti vawane kunonyanyisa varikumahombekombe, rinorondedzerwa se auto_increment, kunoitika nokukurumidza, uye kuongorora zvipingamupinyi kusimbisa zvikonzero chete hazvishandi.

Naizvozvo, Developers vanokurudzirwa ngadziteerere kushandiswa magadzirirwo pamusoro nouya anokosha murayiro mysql update. sarudza - queries apo angadaro ari Database Server kushanda pasina kukanganisa, asi kuwedzera zvinyorwa zvitsva kuna Database hwakazara zvisingafadzi ezvinhu mune ramangwana kutungamirira nematambudziko akakura. Nerumwe Zvinokurudzirwa kuti minda car-increment pakutanga tarisa kuti zvinyorwa zvavo, uye ipapo kuasimudza yoku-.