Kutanga tafura iri MySQL Create Table Data

Database, sezvo dzakasiyana pamusoro wevasungwa mashoko kunokosha, uye pasina kwavari kuita kunyange chiduku chirongwa. Sei zvinobudirira akafunga kubuda yakarongeka, zvakanaka zvakagadzirirwa matafura, customized kukurukurirana - kunobva mharidzo mwero / kunyora mashoko, mashoko kuvimbika, pave hazvibviri netsaona kukuvadza, Kuwanikwa rollback, kukwana nomumwe kutengeserana - uye ibudirire yose.

The Database kuchikonzerwa - Conceptual pfungwa, mharidzo kwemashoko, uye pfungwa kushandiswa kwayo mune rimwe basa.

Simple inoshanda Implementation reshiyo =

Ndeyeukama pfungwa kuronga mashoko zvakajeka kwete zvakanakisisa, asi ivo nechivimbo vane dzavo kwemakumi emakore. Sezvo mafekitari nokuti kugadzirwa kwezvokudya uye zvinokosha nhumbi mutengi, ivo zvachose kudiwa.

pfungwa Revolutionary ari mashoko chaizvoizvo kakawanda akazivisa kodzero yavo upenyu, asi nhasi akakundikana kupa chinokosha uchapupu kuvapo yakadaro kodzero. Senguva dzose, nyore - abudirire. Zvisinei, nyaya ukama uye kubatana pakati date zvinhu - pfungwa, uye hurongwa mashoko nzvimbo - achiri izere mavara machena uye zvinoshamisa dzinonakidza.

Kushandisa nyore mamiriro MySQL kusikira tafura kunotungamirira kuti paumbwe nyore uye zvakakunakira kushandisa hwakawanda matafura, formalizing dambudziko dzose. Tanga kushandisa "tsandanyama" riri nyore kwazvo, asi pashure matafura gumi ndeyeukama ukama okutanga achaita kuti zvakasiyana nemafungiro ruzivo, mharidzo, okuchengetera uye kushandiswa.

Temporary, dzinodzorwa uye kugara

Salient pfungwa: "chinokosha pakuvaka" Database pfungwa pasina kutora chikamu MySQL, rakasvika kuna muupenyu Internet zvirongwa uye rava chinhu chinokosha pairi. Dynamic, yazvino akabvumira Database kuva rokutsanya, yakavimbika uye inoshanda, nyore kudzidza uye kushandisa.

Kuwedzera huru matafura kusika pfupi tafura MySQL magadzirirwo anobvumira programmer kuumba kwenguva mashoko zvivako dziripo panguva chechikamu ano, kushanya imwe User, panowanikwa chiitiko chaicho.

Kana pamberi matafura uye ukama pakati pavo vakanga kubatwa sechinhu zvazvisingarambiki, asi ikozvino hatichamuzivi vakagamuchira Database kunyange simba kureva chinokosha zvinhu. Izvi ndizvo danho kunzwisisa maumbirwo inodiwa kugadzirisa dambudziko.

Nokupa chombo kusika pfupi matafura, kusika pfupi tafura, MySQL unokubvumira akatsemura Database pamusoro kunofambira mberi uye simba zvinoriumba. Chaiyo Mhando kumunda tafura, iyo programmer anogona vapiwa kudzora yakarurama vayo inotungamirwa. Uchishandisa MySQL sika tafura Check design, akagadzira anogona kutaridzwa mamiriro ezvinhu richizadza minda. Nepo nezvechisarudzo ichi - asi mukana aivabatsira yokutama mazano nedzimwe SQL tumitauro.

Information Space: mashoko uye nehurongwa

Ose chirongwa, kana zviri nzvimbo yose, imwe peji kuroora kana nyore algorithm, riri pane imwe nzvimbo imwe ruzivo nzvimbo. "Address" venzvimbo - basa chairo, zvinhu zviri kuvapo algorithm: mashoko mamiriro pamusoro Inlet uye nzira yokubudisa, nokuumba kutendeuka rikurumidze.

Zvisinei, haufaniri hako kutevera mitemo MySQL, nokusika tafura havagoni kusika kuti maererano kwayo nemarongerwo.

In muenzaniso uyu, munda code_back, owner_code session_code kutsanangura makiyi uye ukuwo vakadzoka, uye nemhosva chapera. Kwete chete kushandiswa nevasiri Standard Version MySQL kusika tafura, kiyi pano hahuwanikwi ayo munda kugona, uye dzakapendwa mukati zvaanoreva: kudzoka remitemo panyaya asiri kuvakwa kutengeserana, zvinoshingaira yeGmail.END_STRONG remitemo uye chechikamu code, izvo zvinogona zvinoverengeka nokuda nemhosva, asi kunoenderana payo, apo bumbiro remitemo uchaenda kudzoka zvakanaka.

Panewo kushandiswa nevasiri vomureza minda h_code, a_contents uye a_surprise. Pano pave tafura MySQL muenzaniso sei mumwe munda unogona ane data, uye semantics. Chero mamiriro ezvinhu apo uine tafura vatengi, kuchenjera kusika munhu Maive yezviri chikamu tafura. Izvi hazvirevi hazvo kuti ane zvakakwana rwokutanga date mamiriro. Somuenzaniso, a_contents munda Mukati: zita, pasiwedhi, e-mail, uye a_surprise munda - mamiriro inodzidzisa.

Pfungwa a_contents uye / kana a_surprise

musimboti kwakadaro hakurevi kuwana huru tafura, izvo zvinogona huru uye yainetsa uye achaita kutirambidza diki, rine mashoko akakodzera chete. Pano pave tafura MySQL - muenzaniso chii chingaitwa chiyamuro mutengi zita uye pasiwedhi, kana pasiwedhi uye e-mail nyore: (a_contents zvakafanana '{$ cUserName}; {$ cUserPass}%') kana (a_contents akaita '% {$ cUserPass}; {$ cUserName} ').

In muenzaniso uyu, rinoshandisa rayo pachake nerevane cheki petafura: scTableExists ( 'rm_cache') sokunge tafura haazi, unofanira kwete chete kusika nayo, asi kuti vanyore, somuenzaniso, wokutanga shoma zvinyorwa nemashoko date Resource vakuru.

Standard musiyano wezvinyorwa sika tafura kana asina iripo MySQL musimboti inopa parinoperera Kuwanikwa tafura wayo kugadzwa kana hahupo. Kazhinji, izvi hazvina kukwana. Hatifaniri chete tarisa kuti tafura, asi kuzadza pamwe kutanga mashoko.

nyore mhando Sero

Specificity pamusoro MySQL kushandisa mitauro, kunyanya PHP, kazhinji waanodzikisira uwandu akakurumbira date: pakutanga, netipirovannostyu ayo variables. The anowanzodanwa kushandiswa hungiso, sezvo zvaida - nhamba uye musi, dzimwe nguva nomusoro mashoko. More mikana achirondedzera mashoko pamusoro MySQL kusika tafura ine kushoma. Kunyange zvazvo yokupedzisira kunotemwa nedambudziko kuti kugadziriswa. Unogona kushandisa yose-siyana mashoko Via kusika tafura MySQL, muenzaniso - chero ano kugutsikana kutarisirwa hurongwa Website.

Chii uye sei kushandisa - inorondedzera yokuvaka. Panguva iyi nguva, maererano Wikipedia, inzwi uye nokukurumidza zvimwe MySQL anogona kusangana kupfuura capacious hwomoyo mutengi, kufungisisa zvakaitika yokuvaka kushandiswa. Parinoshandiswa pamusoro MySQL kusika tafura default-zvivako kubvumira kuti kusika yakachena (chiro matafura) pamwe masero shanduka urefu uye kuumba simba kugutsikana mune izvi.

Complex date mamiriro

Dzidziso kune nyore mashoko mhando, chokutanga mutsetse, kwakaita kuti vawedzere kufarira magadzirirwe zvakaoma mashoko anoramba kuti kana tichishanda pamwe Database iri kutendeukira okuchengetera ari mukuru parukungiso, nhamba (maindex - kazhinji), mazuva, uye "mashoko guru" - mifananidzo nemanzwi dzimwe capacious kugutsikana. Pano remutauro wacho kusika SQL The tafura yacho MySQL anenge asina muganhu. Nokuti vose nyore uye Accessibility kuti "tsandanyama" programmer ine panguva yayo achigona zvizere simba zvechokwadi SQL.

Nechokunze nyore panyaya muchitokisi mhando Database kwaIsakari kana varchar mudzoke ari algorithm kuverenga imwe chinhu chakakwana - kunzwisisa mashoko yakarongeka (ehupfumi, nzira, nemarongerwo uye semantics), uye kana kunyora zvakare kupinza chiine chimiro, musimboti zvakatemwa nokuda yokuvaka.

The chikwata tafura

mbiru chete, chete mitsetse uye mumwe chete chinhu panguva mharadzano dzavo, uye chete mhando - muchitokisi. Izvi nderei pokutonga mamiriro MySQL "kuumba tafura". No MySQL date mhando haisi yepakutanga: uwandu, unhu tambo, zuva ... Hazvina kutevera kubva nemarongerwo, asi zvinoitika uchidzidzira.

Programmer nokududzira Sero anogona kushivirira izvozvo chero chinhu mhando, nokuda zvinodiwa basa. Kubva nemaonero Database kuti "chero mhando" - chete mutsetse.

Zvisinei, pasinei, uye sei kushandisa yokuvaka anoda. Zvakakosha kuti panguva ino nguva (maererano Wikipedia) vhoriyamu uye nokukurumidza MySQL parameters anogona kugutsa kupfuura capacious hwomoyo mutengi, kufungisisa zvakaitika yokuvaka kushandiswa.

"Akaoma musoro" vari nyore chaizvo tafura, akaronga kupfuura nyore nzira. Kana yokuvaka anoisa ose munda zvakakodzera zvinoreva, couching pawo kwaIsakari kana varchar mhando mukati wako MySQL kusika tafura nemarongerwo, tafura achaita basa.

integer tafura

Tinofanirawo kutaura pamusoro maindex muna MySQL. Gadzira tafura unokubvumira kurondedzera navo pakarepo uye kushandisa kuwana Mavhoriyamu yakakura mashoko. Izvi zvinonzwisisika chaizvo, yaizivikanwa uye vakwana akadaro zvizere kuti Optimization kunobva CPU kumhanya, caching ivhu artful kukarukureta algorithms kazhinji vakasarudzwa date fora php.ini, my.ini uye httpd.conf.

Zvichakadai, hapana munhu yokuvaka kuumba yako maonero "Data" - "makiyi umboo" nokuda nyore integer - hapana mitsara iri tafura, chete nhamba. A micro sika tafura Int MySQL ichapa vose zvakakodzera vasara tafura: nyore kuwana, Kuvhiyiwa, azere functionality panguva yakanaka nokukurumidza.

Integers, vakarongwa somunhu chaiye mashoko makadhi huru uye kura matafura, achaita mhanyisa wokusarudza uye nadzurudzo mashoko pasina zvinetso. Optionally kusika munhu shanduro kiyi kuwana kwenguva ya basa, unogona kushandisa kusika kwekanguva tafura mamiriro, MySQL anosika kwekanguva tafura pamberi kurishandisa. Kana, somuenzaniso, mumwe nomumwe anoishandisa - chikuru tafura.

Mundima iyi, kuti nemarongerwo hakuratidzwi kushandiswa pave tafura kana asina iripo MySQL unokubvumira kusika zvakafanira matafura, kunyange apo chinhu chisingatarisirwi kusavapo Somuenzaniso, aiva sizvo chiyamuro / goho kana kombiyuta abondera, uye Indexing kwakakanganiswa.

Zviri nemitambo - MySQL +

Kare, kuti Database ndiyo hune mashoko mamiriro. Design M ySQL kusika tafura pakutanga vakatevera dzenhoroondo Dzidziso Data vavo nzvimbo pamusoro dhisiki nzvimbo. Internet zvirongwa, uye kupfuura zvose zvokusarudza unobva uye pfungwa yakakurumbira kugutsikana utariri hurongwa, akaita chinoshamisa, pakutanga aitarire, misha: chimwe nechimwe angava mubatanidzwa anoverengeka. Kuparadzana iri patafura chivakashure zita.

Vamwe nemitambo rinobatsirwa kunge zvavakatemerwa pamusoro Database mazita zvinodiwa zvavo, dzakadai Database zita rinotanga nezita muridzi Hosting.

Kazhinji, hazvina basa chii kudana Database uye sei kuti vanouti patafura. Zvisinei, mamiriro ezvinhu akatanga kumiririra kwete MySQL nemarongerwo uye zvinodiwa unobva ndinoiitawo nemarongerwo, kureva MySQL +.

A tafura duku, nyore hwakarongwa, uye zvishoma records, iyo denser zvakanyorwa muchibereko mumutauro zvirongwa kuburikidza izvo zvaaida zviito anoteererwa nevanhu mashoko.

In Zvinotaurwa, chero basa iri nyore kunyora kupinda zvokutanga zvinoriumba, mubvunzo chete iri, sei achaita mari nyore zvakadaro.

Kana uchida kuva MySQL yakachena, izvozvo pachake nemitambo kwako Server, apo hapazovi rairambidzwa nhamba Databases kana nemitemo ndivanani uye dzavo nhengo pamatafura.

A-siyana shanduro Apache / MySQL / PHP

Pazviri nemitambo kwezvakatipoteredza - dambudziko kwete zvokuti, sechinhu chinokosha ezvinhu kuti ano kuzvidzivirira zvirongwa. Unogona kunyora muna PHP 7.0.13, shandisa MySQL 5.7.16, asi mutengi achange nemitambo, vachibvumira chete shanduro Perl uye "tsandanyama" 4.1.1 kana yakwegura shanduro PHP.

Kazhinji (izvo, sezvinei, harisi chokwadi) nemitambo pa Linux, FreeBSD, UBUNTU uye nezvimwe zvakasiyana yunikosopodobnyh hurongwa. Vose vanoshanda akanaka, asi mumwe nomumwe wavo ane pachake zvachiri, dzavo shanduro pamagungano AMP (Apache, MySQL, PHP). Kwete nguva dzose kwete chikwata dzose kuenda kunoshanda inotevera shanduro, kunyange iye aishanda yaimbovapo.

nyore zvakadai oparesheni munhu ave Database ekisipoti chero shanduro MySQL anoita pasina matambudziko, vaviri kubva Import Import phpMyAdmin, uye kubva murayiro mutsetse. Contact imupota akavhiyiwa haagoni kutora nzvimbo. Kazhinji kacho kuchinja chinhu PHP yako, MySQL Server kana Apache. Kana zvachinja regai kubatsira, zvakakodzera kutsvaka zvinotsiva.

The nyore Chokwadi, kuvhiyiwa kunogona kuitwa kuburikidza resetting ari Database, mutauro zvirongwa kana Server. Izvi hazvisi yakanakisisa mhinduro, asi kazhinji inobudirira.

The Database Zvisikwa / chivimbo chakasimba tafura

Nemarongerwo MySQL sika tafura kashoma kushanda kwaro mureza musimboti. Kana asina munyaya yacho akakurumbira kugutsikana utariri hurongwa: pachagara kuva chaiwo ari Genre. The daily basa nyore kufunga izvozvo ari akapoteredza tsika: iyo minda chinoda patafura, yavanofanira kuva mhando uye kukura. Vamwe vachiri kufanira kunatsiridza chirongwa pakukura: nezvounhu yakatarwa, zvemarudzi hurongwa, kiyi.

Optimum iri shanduro algorithm, iyo kunyange kushaya munhu Database asingadi kukanganisa nzvimbo kutanga. Unogona kunyora pachake nerevane yako tarisa Database uye / kana tafura kana unofanira kusika ruzivo zvivako kwete chete, asiwo kuti zadza ruzivo kwavo kwokutanga.

Kazhinji kushandisa nhevedzano mazano Gadzira tafura kana asina iripo, MySQL haana kushamisa muridzi nzvimbo kana mushanyi kuti pakarepo munoti: hakuna Database kana tafura Murongerwo runovhuniwa.

Mazuva zvirongwa Kazhinji kuti "ruvimbo asi ongorora" haasi kushanda, kana panzvimbo achashandisa pfungwa yacho "tarisa uye kushandisa."

Gadzira tafura: MySQL User tafura yokuenzanisira

Registration nevashanyi itsva uye pamukova / mbudo nzvimbo vanoshandisa zvave kakawanda, asi Pamuganhu vakakwana ichi chinokosha chero nzvimbo asi.

Munzira dzakawanda, chiyamuro / goho uye kunyoresa vari kunorondedzerwa mashoko nezve kwenzvimbo uye / kana kushandisa kugutsikana utariri hurongwa, asi kakawanda - chido kuva chinhu akachengeteka zvikuru, kudzivirira User nyaya, kudzivirira kugura nzvimbo.

Kazhinji MySQL Database zvakawanda akachengeteka kupfuura Website, asi kana kukundikana dzisingabviswi kuratidza Browser kukanganisa mashoko ari configuration bumbiro nzvimbo ine mazita uye mavara echivande kuna Database,.

tsika Good - kugoverana umboo pamusoro kunofambira mberi uye simba zvinoriumba. On muenzaniso tafura rokushandisa, unogona kuva unorema spreadsheet vanoshandisa uye zvinoshingaira cache_users. Tafura wokutanga ine vakawanda vanoshandisa, wechipiri - avo chete aishanda pazuva rokupedzisira (somuenzaniso). Ose mushandisi itsva kuti vasipo iri tafura wechipiri, akasvika pashure pamukova / mabiko uye inochengeterwa imwe nguva.

Asi weboka matafura maviri pano kwete chete kunopa mashoko mharidzo mwero (a tafura duku iri nguva dzose kudarika kura uye makuru), asiwo chokwadi chokuti inonyatsoenderana chete mashoko zvinodiwa kakawanda kana kushanda chero mutengi imwe nzvimbo. Nokuti zvakabudiswa kana mashoko kuchinja sezvingatarisirwa kushandiswa huru tafura.

Memory, mashoko uye Databases

Mumunda mashoko michina sezvineiwo haana yakatanga kumiririra mutauro ndangariro zvirongwa. Language - the variables, constants uye zvivako, vachibvumira chinhu uye zvimwe zvinomukira. Database - chinhu dzokufusha nokuchengeta. Pairi unogona nguva dzose kusarudza chinhu mairi unogona kunyora chinhu.

Combined mutauro uye yemibvunzo chinangwa kushanda mashoko, asi pfungwa yacho ukama muna vanamwari vatatu vatatu ichi hachisi saka vakakwana, kunyange iri nyore boka AMP: Apache, PHP, MySQL. Pano zvose zviri pachena: ari Server, mutauro zvirongwa uye Database - zvose zvinodiwa kuti ruzhinji mabasa.

SQL mutauro - zvakafanana zvirongwa mutauro, uye zvirokwazvo vari Database ine yayo zvisingarambiki kushandiswa, zvirongwa pachake pfungwa. Pano tine chido kurutivi Database zvirongwa. PHP - chakanaka chokushandisa, asi kutaura kuti iye akaita kuti vanyatsokwanisa Database divi, zvakaoma. Zvisinei, ayo mamiriro uye mashandiro dzakabudirira uye akavandudzika.

Kana isu sangana PHP uye MySQL mune rimwe Unit, imi makakohwa chokushandisa, ane ndangariro. Option mubatanidzwa anopa pfungwa chinhu vaifarira zvirongwa: chinhu inotsanangurwa mutauro panguva Kusabatsira yavo ndangariro (ari Database) ari tsindirana ezvinhu. Kana zvinovawo zvakakodzera kuti ipfupi kuva zvizere chinhu uye unoshanda maererano kugona kwaro.