Kushandisa MySQL: pinza kupinda

Kutanga Database - nyore basa, asi mhosva. Zvinhu zvakawanda zvinofanira kukurukurwa. Kunooneka mberi Hardware uye Software ruzivo rwokugadzira hakuiti tuzvikonzero hanya hwokugadzira kukundikana ndingangokuvara kunze komutemo kuwana kutyorwa tafura mamiriro, wedzera zvazvinoreva mashoko.

Computer - kwete munhu, uye kunyange "akangwara", iro algorithm iri kure vachiri kubva pfungwa rwokuzvarwa njere; pasina achibatsirwa programmer zvishoma ndaikwanisa. Zvisinei, kusiyana nevanhu, purogiramu aite basa rayo dzose uye nemazvo, chinhu chikuru - kodzero kuzvinyora.

MySQL pfungwa: pinza kupinda

Externally, asi kura chimiro SQL nemarongerwo zviri nyore chaizvo kushandisa. Practice zvikumbiro vachinyora tsamba repamusoro nyaya yasara, asi zvishoma nezvishoma chikatsiviwa zvikuru pfupi kuposha evoruzhinji. Panyaya iyi, zvakakosha Haazombokanganwi: kamwe raireva munda zita mubhuku remazita zvakafanana mubvunzo, kana kushandiswa zvakare, akasungwa kuva zvakafanana zviperengo.

A maitiro chinoratidza remapazi MySQL pinza mumba, sezvo zvikuru nokuda Internet zvirongwa "hachisi chinhu chinofanira kuitwa, haina kunzwisiswa." Zvisiri akaanyora kukumbira Database updating zvichabviswa kungosiyiwa, uye hazvibviri nguva dzose kuona ndangotanga.

Chokwadi zvokuwedzera ane kupinda anofanira kudzorwa uyewo kuenda Database yose. munda mumwe nomumwe inofanira kuzadzwa kukosha runoenzanirana mhando. Hazvina nguva zvakakodzera kuti kutaridzwa munda chaidzo tafura. Hazvina nguva zvakakodzera kuti ape chaizvo tsika: MySQL pinza kupinda kufanosarudza design Inokutendera kuwedzera kuva zvinyorwa kubva imwe tafura kana mubvunzo.

The chikumbiro anofanira syntactically uye zvine musoro zvawataura. Kushandiswa chero pachake ari MySQL mubvunzo pinza kupinda netsika vanofanira kufunga yeEncoding pamusoro manyorero, iro ndiro yeEncoding petafura Database uye, chaizvoizvo, akawedzera mashoko.

Classical achiwedzera Entries

Chero tafura MySQL - kutevedzana kwezviitiko zvinyorwa, imwe neimwe ine nhamba yeminda. Wedzerai Entries inogona kubva imwe tafura. Zvaringana kuti zvakanyatsonanga mune mubvunzo kuti asarudze izvozvo, uye kupi, uye kupinda - zvikuru. Chiratidzo "*" anoti chikumbiro unoshanda minda zvose nerimwe chinyorwa.

Somugumisiro panodana basa iri zviri patafura $ cSrcTable zvakanyorwa zvachose tafura $ cDstTable, umo zvose vakanyoresa ichabviswa pachine.

achiwedzera zvinyorwa

MySQL pinza kupinda tsika zvakagadzirwa kunoita munhu kuwedzera vakanyoresa achiratidza chaizvo minda yavo tsamba yakananga tsika.

mubvunzo uyu unogona kukamurwa zvikumbiro zvitatu, chimwe nechimwe chiri chete mazita minda ( `code_back`,` owner_code`, ... ) unoenderana mumwe musara Data ( '~', '{$ cSChip}', '{$ SChip_s } ', ...), (' ~ ',' {$ cPetr} ',' {$ cPetr_s} ', ...) kana (' ~ ',' {$ cTest} ',' {$ cTest_s} ' , ...), asi zviri nyore. Somuenzaniso, muchiitiko ichi akawedzera inokosha akagadzirwa vanoshandisa: mutariri, dispatcher, uye tester.

Achiwedzera zvinyorwa kuburikidza yayo inowanikwa

How kushanda MySQL chaitwa kuburikidza muchimiro queries. Izvi zvaibatsira batch mangé muoti uye nenzira yakafanana iri rakatangwa muna mapurogiramu mitauro yakasiyana. In PHP, kunyanya, anoshandisa mubvunzo tambo - vakawanda kutevedzana kwezviitiko vatambi, zviri izvo yakazadzwa panguva algorithm. Ipapo chinyorwa akarigadzirira chikumbiro anouya mysqli_query () basa rinoitwa.

Wakadiniko basa pamwe Database kusarudza - kusarudza imwe nyaya, ari yokuvaka, asi nguva dzose zviri nani kupa dambudziko tichitarisa ayo iverengwe / nyora mashoko kubva / kusvika Database muchimiro pachavo interfaces dzavo. Pfungwa iyi inogona chinozoiswa somunhu seti mitambo kana imwe chinhu.

In musimboti ichi, kuvhiyiwa zvakananga achiwedzera zvinyorwa kuti kuvanzwa, uye muitiro panofanira vari sequential pachake mabasa vari naro. Somuenzaniso, scfAddUser ( 'Ivanova', 'Ivan') hunotungamirira chikumbiro MySQL pinza mu `all_users` ( 'last_name', 'first_name', 'mamiriro') tsika ( 'Ivanova', 'Ivan', 'itsva'). Ipfungwa ichi anoponesa bumbiro uye inoita zvakawanda verengeka uye zvazvinoreva.

The zvinokosha musiyano yavo inowanikwa pamusoro zvakananga kushandisa kushanda ari Database zvavo yepakutanga muchimiro iri kuti akaita ari oga faira, akavhiyiwa zvose wedzera, kuchinja uye zvinomuomera kuikanganwa zvinyorwa zvinogona kudzorwa ikashandura pasina kunatsiridza bumbiro anodzishandisa. Zviri nani uye rikurumidze.

Own inowanikwa kubva date chinhu

Kana musingadi kufungawo nyore variables, purogiramu ano muunganidzwa zvinhu. More vanonyatsokwanisa kugadzirisa chinetso, zviri zvakanyanya yakagadzirwa maitiro zvinhu uye kudyidzana kwavo nomumwe.

Zviri pachena, kushanda kurekodha uye kuverenga Data tora akasiyana akapoteredza: chinhu anogona kuramba pachako uri Database, anogona kuzvigadzirisa kubva Database, tarisa mamiriro ayo, uchatamisa zviri mumwe chinhu, etc.

Izvi vachambokanganwa kusimbisa kubva zvakananga Coding MySQL pinza kupinda zvikumbiro kuna inowanikwa: scfAddObject ( 'contens', ...), iro rinoshandiswa mumwe chinhu yazvo nenzira.

musi chinhu achava nzira myDate-> Save () uye tongai scfAddObject kurapwa ('04 .12.2016 '), uye aishandisa chinhu currUser-> Save () anoita scfAddObject (' Ivanova - login '), ... mumwe chinetso scfAddObject () kuchatungamirira pakuvaka musiyano wezvinyorwa MySQL dzinoisa kupinda chikumbiro.