MySQL - Windows kunyaradzana murayiro

Development mashoko michina - mumwe vaitungamirira munzvimbo mabasa evanhu. Naizvozvo, munharaunda ino vari bhizimisi guru mari. Sezvo pakutanga uye yakawanda mabasa akasiyana yave akasarudza zvevakomana, izvo zvakakomba ufare hwezuva nezuva hwevanhu vakawanda. Zvisinei, pamwe mberi mune zvemichina, zvinetso, mumwe icho - ane kunyanyisa Kuwanda kwemashoko kuti kuchengetwa. Databases akagadzirirwa kugadzirisa mamiriro ezvinhu.

Zvakaita Database utariri nehurongwa

Sezvo dambudziko pokuzviunganidzira yakawanda mashoko akakosha kuti nhasi, pane nzira dzakawanda kugadzirisa. Mumwe nomumwe wavo nezvezvakanaka basa imwe nhungamiro. Zvisinei, pamwe chete zvinoumba kunzwisisa zvizere iyo nyore dambudziko chekuchengeta.

Pane chaicho kupatsanura, izvo anosarudza kudiwa imwe Database uye DBMS (Database kutarisirwa hurongwa). Rakajairika iri parizvino vaiona kuva nemhosva-Server chekuchengeta michina. Izvi zvinosanganisira zvinotevera: Firebird, Interbase, IBM DB2, MS SQL Server, Sybase, Oracle, PostgreSQL, Linter, MySQL. Tiri kuziva ekupedzisira kuzvipedza - MySQL, iyo chikwata chose kusvika SQL mureza. Michina iyi ndiyo imwe yenzvimbo dzine mukurumbira uye raiwanzoshandiswa kuti vazoita yomunharaunda kushanda uye kugadzirwa zvinetso pamwero muduku.

Client-Server michina Precursors vari faira-Server Database, izvo vakafirwa zvinzvimbo zvavo nokuda dzinoverengeka yaivapo zvainovhiringidzawo, ramakagadzwa kudiwa govera kupararira DBMS tsanga imwe neimwe kombiyuta uye chinokosha mutoro pamusoro yomunharaunda nzvimbo network, zvichiguma yakawedzera nguva. boka iri rinosanganisira ari Microsoft ari Access, kuti Borland ane Paradox.

New ruzivo kuwedzera kukurumbira

Zvisinei, makore mashomanana apfuura paiva michina yemhando yepamusoro kuti ari kuwedzera kukurumbira uye kudiwa nekugadzirisa matambudziko duku romunzvimbo. Tiri kutaura midzi Database utariri enyika. The chikuru chinoratidza Database ichi - hapana divi Server. The Hurongwa pachahwo raibhurari, vachibvumira yunifomu nzira kugadzirisa yakawanda mashoko vaipinda pamusoro yomunharaunda kombiyuta. nzira iyi anobvisa zvazvakaipira ikwidzwe Server zviwanikwa, uye mukuru zvikuru yeGmail.END_STRONG-Server Michina nokukurumidza.

Mienzaniso kuoneka OpenEdge, SQLite, BerkeleyDB, mumwe Firebird kusarudza pakati Zigzag Sav, kuti Microsoft kuti SQL Server ari Compact, Linter, uyewo mumwe MySQL sarudzo kuti chikwata yakasiyana nezvaishandiswa mune yeGmail.END_STRONG-Server Database hapana. Zvisinei, midzi hurongwa anogona rirasikirwe kwayo nyore kana dambudziko kuchanyarara kuva yomunharaunda.

The chikuru zvakanakira ari MySQL Database

utariri hurongwa MySQL Database ndechimwe chezvinhu mukurumbira ano, nokuti inogona kusashanda kugadzirisa guru nhamba mabasa. Kana tikaenzanisa paro dzomuzana ano, zvinobvira kuziva zvinoverengeka mikuru zvakanakira.

Kunakisa chikuru pamusika wokuRussia anonzi kuva kwayo Kuwanikwa, sezvo zviri pachena kakawanda. Chechipiri chine ndiyo nokukurumidza. Chimwe chezvinhu dzakakurumbira hurongwa ndiye MySQL. Team zviri kutsanya, ane nguva norudaviro mashoma. No zvainoita kumhanya kubudiswa rinorayira kubatanidza kuti Server akawanda vatengi vari multithreaded muoti nokushandisa InnoDB rutsigiro nomazviri kutsanya kwema.

Kuvapo ODBC mutyairi anobvumira Developers kurerutsa mhinduro nezvinetso zvakawanda. Kubatsira uyewo zvinofanira kusanganisira urongwa mikana yamashoko yatarwa uye shanduka kureba. Asi chikuru basa izvo kunoongwa zvikuru pakati programmers - inowanikwa pamwe mitauro C uye PHP. Mikana yakapiwa MySQL, akabvumira kushandisa Database ichi kuti vakawanda rubatsiro kubva Web Hosting mabasa.

Uye nokuda nyore munhuwo zvake, kukudziridza kufarira ano ruzivo mashoko kuchengetwa, zvinokosha kuti vadzidze MySQL, iyo SQL mirayiro nemarongerwo nokuti nyanzvi munzvimbo iyi Zvinodiwa guru kwazvo vakabhadhara pose munyika. Naizvozvo, kana mumwe munhu aifarira mirayiridzo iyi pasina kunonoka mutengo. Tinofanira kuenda kudzidza ikozvino.

Chii chandichiri kudzidza

Pakutanga zvingaita sokuti nzvimbo iyi zvakaoma nokuzvidzora kudzidza uye kunoda kugara kutaurirana pamwechete chiremba. Zvisinei, hazvina kudaro. Study akitekicha uye zvimwe MySQL, chikuru boka racho mubvunzo mutauro uye zvose zvine chokuita nayo, unogona ndorwangu, pasina kushandisa achibatsirwa consultant. Zviri zvakakwana kuva chido uye kuita kuti aenderere mberi. okuzvifunga kukura uye kudzidza nzvimbo ino chete kuchaita kuti tiwane zivo itsva, kusimbisa kuti vawana unyanzvi uye, zvichida, tangai kuvaka basa uye kutama mune mirayiridzo iyi.

Kudzidza mirayiro inokosha, pakutanga kwezvose, unofanira kuva pasi noruoko yepachena shanduro MySQL kunyaradzana utility. Kuti hwekudzidza rinotanga nayo. Unogona kukopa kubva pamutemo MySQL nzvimbo. Zvinonzi nyore yakaiswa pamusoro chero uchishandisa hurongwa, pova server nemhosva pamusoro chete kombiyuta, riri nyore kwazvo.

Zvino zvakafanira kushandisa uchiwana dzidzo Chinyorwa rine mashoko anokosha pamusoro MySQL kwezvakatipoteredza. Kunyaradzai unoraira kuti zvinokosha tsvakurudzo, sezvinoita mutemo, ivo vari ine. Information nezvazvo chaizvo chaizvo. Zvisinei, unofanira kuuya kusarudza zvakakomba. Information inofanira kukurukurwa dzose uye zvakajeka muronga.

Kana uine ruzivo inokosha mutauro Chirungu, unogona kushandisa pakuvara kunyaradzana rutsigiro. Nokuti chinangwa ichi pane chinokosha rubatsiro murayiro, izvo zvinotibatsira kunzwisisa kushandisa MySQL Ezvemutauro.

Huru kunyaradzana mirayiro

A kumeso achichinja kubva dzinokosha features, nezvaanogona uye makomborero, Pataisvika pamazita mirayiro inokosha. Pakutanga MySQL utility ine mushandisi rimwe chete, iro chete kushandiswa pakudzidza. mushandisi ichi anonzi mudzi, ane pasiwedhi ndiye akafanana kuti zita.

Apo wokutanga uye nekutambira chinonyengera ari kunyaradza MySQL User vanofanira kupinda mudzi pasiwedhi nokuda mberi basa pamwe DBMS MySQL. mirayiro CLI dziripo chete pashure akabudirira authentication.

Pashure rakabudirira bvunzo zvivanakire, unogona kuratidza huripo mirayiro kushandisa rubatsiro murayiro. Pashure paizvozvo, vakuru kunyaradza zvichakurukurwa zvose zviripo mirayiro uye tsanangudzo pfupi pamusoro pavo.

uye kuratidza masimba mirayiro

Zvino iwe unofanira kuenda padanho rinotevera. Kuti aite izvi, unofanira kusarudza yaivapo kana kuumba Database idzva. Kusarudza huripo Database anofanira kushandisa kushandiswa murayiro. Uye kuburikidza pakakoromoka kupinda Database zita. Pakutanga, utility aripo mumwe chete - pamwe zita bvunzo. Naizvozvo, mubvunzo vachatarira seizvi: kushandiswa bvunzo.

Kuti pave Database unofanira kushandisa rokusika murayiro, achinongedza kwaari guru Database uye chaiyo yakakodzera zita. Nemamiriro anotora zvinotevera chimiro: kusika Database Name_of_database. Kushanda richangobva akasika Database zvakafanira kushandisa nokushandisa kushandiswa murayiro.

Svikiro ane mashandiro kuratidza huripo Databases, matafura, chikuru makiyi kana zvimwewo kubatana uye outputting ruzivo kuwanikwa pamusoro pavo MySQL kunyaradzana. Zvikwata iyi nyaya kunofanira nguva dzose kutanga vaitaura anoratidza. Somuenzaniso, kuratidza mazita dziripo Databases kuti magetsi User, anongoti kupinda zvinotevera mubvunzo: anoratidza Databases. Kuratidza tafura zvakakwana mushure guru change kuratidzwa chinhu nokunyorera matafura.

Matafura Management Team

Asati rwuchibuda mberi, zvakakodzera kamwe zvakare kuyeuka kuti zvaidiwa SQL mureza inopa mikana Developers, pasinei Database uye uchishandisa enyika. Requests mune chero mamiriro ezvinhu kuti anotsigira SQL mureza, achashanda zvinobudirira (kana Database riripo, uye matafura) muna MySQL zvakatipoteredza. Windows kunyaradzana mirayiro havana vakasiyana nezvaishandiswa mune dzimwe uchishandisa hurongwa.

Spreadsheet pane zvinoverengeka mirayiro yakananga kuti, kana isu kushandura kuti Chirungu, taura kuti pachavo. On the sika murayiro pamusoro apa. Rinogonawo kusashanda kuwedzera matafura kuti kare akasika Database. Kubvisa Database zvinhu zvakadai matafura uye vakashandisa akadonha murayiro, kuti icho akawedzera zita chinhu kuparadzwa. Muenzaniso: donhwe zita _ pamusoro _ yenyu _ tafura.

Nemarongerwo zvikumbiro kuna Database Server nguva dzose ane vakawanda mamiriro. Saka, chikumbiro, zvakagadzirirwa pamusoro Windows, uye ndichaita kushanda zvakanaka MySQL Linux kunyaradzana. Zvikwata zvakaipa Server pasina kukanganisa chimwe uchishandisa hurongwa haagoni kukonzera zvikanganiso zvevamwe.

Select chikwata

Asi chinonyanya kukosha spreadsheet murayiro nemarongerwo iri nyore, - kusarudza chikwata. Rinoshandiswa kusarudza umboo kubva Database. The chepakutanga nemarongerwo iri sezvinotevera: sarudza * kubva tafura _ zita. Nokutuma chikumbiro kuna Database Server, kuti nemhosva vanofanira kuwana zvose zvinyorwa mumabhatiri patafura.

Vanhu vazhinji kumbofa, asi kana vachivhura Internet zvinhu zviri kuramba kushandiswa MySQL anorayira. The PHP-queries vanoshandisa SQL mutauro nemarongerwo kuratidza zviri imwe Directory paIndaneti zvitoro kana nhau munzanga network. Panzvimbo "+" pashure vakasarudzwa inopiwa, somunhu ushe, pakarongwa huru kuminda patafura kana matafura inoverengeka Data kuti kupatsanurwa. Kana zvakabudiswa multiple matafura, chaiwo svinga kubatana, iyo inoshanda kubatanidza navo iripo kwokunze kubatana. Zvisinei, ichi chirwere chinogona kushandurwa vakazvimiririra chaairatidza iyo minda yaifanira papi.

Chakaita zvakabudiswa kurambidzwa

Dzimwe nguva pane mamiriro ezvinhu apo kufarira kugamuchira kubva Database Server rine nouya mashoko. Kuti anoishandisa kuti vaonekwe chete nemamwe vakanyoresa, uchishandisa vanopa zvakasiyana. It anoiswa pamberi ndandanda akakumbira minda uye anoshanda kuyamura kuvanza akagadzirwa zvakafanana.