Ukusebenzisa MySQL: faka ku

Ukudala egciniwe - nomsebenzi olula, kodwa wemfanelo. izici eziningi kumelwe zibhekwe. intuthuko ephawulekayo hardware ne-software yelwati akusho bathethelele ukunganakwa lobuchwepheshe ukwehluleka Amathuba okungagunyaziwe ukwephulwa ukufinyelela etafuleni isakhiwo, engeza idatha engavumelekile.

Ikhompyutha - algorithm angiyena umuntu, ngisho kakhulu "ukhaliphile", namanje kude imibono intelligence yemvelo: ngaphandle kosizo Unicode kwakukuncane ngineminyaka engu ekwaziyo. Nokho, ngokungafani nabantu, uhlelo ungakwazi afeze umgomo wayo njalo nangendlela elungile, into esemqoka - ilungelo uwubhala.

umqondo MySQL: faka ku

Ngaphandle, ifomu besiyoba sikhulu SQL kwemavi lula kakhulu ukusebenzisa. izicelo Ticeceshe kubhala izinhlamvu icala eliphezulu namanje uhlala, kodwa kancane kancane indawo sikubeke ngokusebenzisa kokubili amarejista. Kule ndaba, kubalulekile ukuba singakhohlwa: kanye okukhulunywe igama inkambu irejista nombuzo efanayo, uma sisetshenziswe futhi, nakanjani esikhathini ukupela efanayo.

Isici nobuntu imisebenzi MySQL ufake, okuningi ngenxa izinhlelo Inthanethi "akuyona into okufanele yenziwe, bengayiqondi." isicelo ngokungalungile eyahlanganiswa ngoba semininingwane Ukuvuselela zizozitshwa, futhi akusiyo njalo kungenzeka ukuba uphawule ngokushesha.

Iqiniso ngokunezela i entry Kumele alawulwe kanye nokufinyelela ku-database lonke. emkhakheni ngamunye kufanele uchichime ukubaluleka yohlobo ehambisana. Akukhona njalo kunesidingo ukuze ucacise ensimini etafuleni langempela. Akukhona njalo kunesidingo ukuze adlulisele amagugu ethile: MySQL ufake design khetha ikuvumela ukuba wengeze iqoqo amarekhodi kusuka kwenye etafuleni noma umbuzo.

Isicelo kumele kube olungile kanye ngokunengqondo lesifanele. Ukusetshenziswa kwanoma yiziphi samuntu nombuzo MySQL ufake amanani kufanele acabangele ukufaka ikhodi ye zombhalo, okuyinto, ukufaka ikhodi kwetafula egciniwe futhi, eqinisweni, wanezela imininingwane.

Classical okufakiwe ngokungeza

Noma yimuphi MySQL ithebula - ekulandelaneni amarekhodi, ngamunye ephethe emikhakheni eminingana. Engeza okufakiwe kungaba kusuka kwenye etafuleni. Kwanele ucacise embuzweni ukukhetha, futhi lapho, futhi ku - okuningi. Uphawu "*" kusho ukuthi isicelo osebenza ku yonke imikhakha nalelo rekhodi.

Ngenxa yalokho yamakholi lo msebenzi okuqukethwe ithebula $ cSrcTable ebhaliwe ngokuphelele ethebuleni $ cDstTable, kusukela lapho bonke okufakiwe izosuswa kusengaphambili.

Ukungeza amarekhodi

MySQL ufake amagugu design ivumela eyodwa ukuze ungeze okufakiwe ekhombisa emasimini athile futhi ohambelana namagugu abo ethize.

Lokhu nombuzo kungenziwa ihlukaniswe izicelo ezintathu, ngamunye okuyinto uhlu eyodwa Amasimu ( `code_back`,` owner_code`, ... ) oluhambisana eyodwa umugqa idatha ( '~', '{$ cSChip}', '{$ SChip_s } ', ...), (' ~ ',' {$ cPetr} ',' {$ cPetr_s} ', ...) noma (' ~ ',' {$ cTest} ',' {$ cTest_s} ' , ...), kodwa-ke kulula. Ngokwesibonelo, kuleli cala ukungezwa isethi eziyisisekelo abasebenzisi: umlawuli, dispatcher, futhi umhloli.

Ukungeza amarekhodi ngohlelo ayo

Indlela ukusebenza MySQL yaqaphela ngokusebenzisa ifomu imibuzo. Lokhu kuwusizo batch mode futhi ngendlela efanayo luyasetshenziswa ngezilimi ezahlukene zokuhlela. Ngo-PHP, ngokukhethekile, isebenzisa string nombuzo - ukulandelana ezivamile nezinhlamvu, okuqukethwe okuyinto ugcwele phakathi algorithm. Khona-ke umbhalo acatshangelwe isicelo iza mysqli_query () umsebenzi wenziwa.

Hlobo luni lomsebenzi database ukukhetha - ukunquma endabeni ethile, unjiniyela, kodwa kuzo zonke izimo kungcono ukwethula inkinga ngokuya wokufundwayo yayo / bhala idatha ukusuka / database ngesimo interface yabo. Lo mbono ezingase zithathwe njengoba iqoqo imisebenzi noma into eyodwa.

Kulesi samuntu, ukusebenza ngokunezela ngqo amarekhodi ukuze kufihlwe, futhi inqubo izokuba ngendlela imisebenzi ezilandelanayo siqu kokuba icele. Ngokwesibonelo, scfAddUser ( 'Ivanov', 'Ivan') kuzoholela isicelo MySQL ufake `all_users` ( 'LAST_NAME', 'FIRST_NAME', 'isimo') namanani ( 'Ivanov', 'Ivan', 'omusha'). Lolu khetho konga ikhodi bese kwenza kube efundekayo kakhulu nokunenjongo.

Umehluko ebalulekile phakathi esibonakalayo ezabo Ukulisebenzisa ngokuqondile kanjena ukusebenza database ngefomu yabo yangempela ukuthi senziwe ifayela ehlukile, yonke imisebenzi engeza, shintsha futhi ususe amarekhodi zingalawulwa futhi okushintshiwe ngaphandle ukulungisa ikhodi esebenzisa kubo. Kuyinto ephephile futhi iyashelela.

esibonakalayo siqu kusuka into idatha

Uma ungenalo acabangele eziguquguqukayo elula, uhlelo zanamuhla ibuthelelo lezinto. bakufanelekele kahle ukuxazulula le nkinga, kulapho kahle eklanyelwe uhlelo izinto kanye nokuxhumana yabo nomunye.

Ngokusobala, ukusebenza zokuqopha Ukufundwa idatha ukuthatha umongo: into ungazigcina database, ungakwazi okuzivuselela kusukela database, ukubheka isimo saso, ukudlulisa okuqukethwe kwenye into, njll

Le ndlela usekhuluma okugcizelelwe kusukela ngqo esephepheni MySQL ufake izicelo esibonakalayo: scfAddObject ( 'contens', ...), okuyinto esetshenziswa into ngayinye ngendlela yalo.

usuku into uyobe unendlela myDate-> Gcina () nokwenza ukuphathwa scfAddObject ('04 .12.2016 '), futhi into umsebenzisi currUser-> Gcina () kwenza scfAddObject (' Ivanov - ngemvume '), ... futhi inselele ngayinye scfAddObject () kuzoholela ukwakhiwa kwalesi okufana MySQL ufake isicelo.