Kana iwe wakambove nedambudziko rekubata dhatabhesi kubva kune imwe server, usazvidya moyo, nhasi tirikukuudza zvese zvine chekuita nazvo MYSQL inoraira.
MYSQL inoraira
Kutaura nezvemhando idzi dzemafomati nemirairo kuri kungo tarisa munzira iyo dhatabhesi ichaiswa muwebhu peji. Izvo zvakakosha kuti uzive maitiro ekupinda MYSQL mirairo kuburikidza nefaira yepakati, pamwe nepakati peiyo terminal.
Mubvunzo wedhatabhesi wakakosha kuti ishandiswe chero sisitimu. Iko kushandiswa kunowanzoitwa kuburikidza neiyo PHP peji, asi iko kubata kuri nyore kuzviita uchishandisa iyo PhpMyAdmin chirongwa; Nekudaro, zvinoitika kuti kana paine matambudziko, imwe nzira inoshanda ndeyekuvapinza kuburikidza netambo yekuraira.
Nenzira imwecheteyo, kana isu tiri pane server iri kure uye tichipinda kuburikidza neiyo terminal, zvinodikanwa kushandisa chishandiso ichi kudzoreredza mafaera aya. Nhasi tichakupa mimwe mirairo kuti iwe ugone kuziva kuti maitiro aya anoitwa sei.
Tsvaga iyo faira
MySQL mafaera anoshandiswa kuburikidza necustomer software, iyo yaanogovana yakafanana dhinominesheni, MySQL. Iyo inoshandiswa mune dzakawanda zviitiko kudzora dhatabhesi kuburikidza nemutsetse wekuraira; Ivo vanoshanda kana akasiyana faira chirongwa ichiitwa uye MySQL inoraira.
Mune chero mudziyo une Windows software yakaiswa, iyi faira inogona kuwanikwa, nzvimbo yayo iri pakero inotevera: C: Chirongwa mafaeraMySQLMySQL Server 4.1bin.
Iwe unogona zvakare kuiwana muC: xamppmysql; dhairekitori iri rinogona kunge rakasiyana asi muzita chete.
Pamawindo
Semuenzaniso, dzimwe nguva uye zvinoenderana neshanduro yeWindows inoshanda sisitimu, iri pane diski C: kana mune chero imwe nzvimbo mukati mekurangarira komputa, saizvozvo, inogona kuwanikwa mune imwe chinongedzo uko programmer yasarudza kuisa it. Zvinoenderana nezvakawanda kuti ndechipi chirongwa chakashandiswa kuiisa.
Asi usazvidya moyo nezvekutsvaga, uchishandisa injini dzeGoogle dzinogona kuwanikwa zviri nyore, kunyanya kuwana rakakodzera dhairekitori, nekuti dzimwe nguva komputa yega yekutsvaga haina kupa ruzivo rwatinoda.
Iyo chaiyo dhairekitori kana iyo iwe yaunoda maneja inowanikwa sekurairwa neGoogle. Semuenzaniso, kana isu tiri paWindows uye tichida kuwana iyo MySQL imwe nzira, tinozviwana isu mukati medhairekitori kana kuisa dhairekita mukati mekumisikidzwa kwePATH.
PaLinux
Isu tinoziva kureruka kunopihwa neLinux kune vese programmers uye vanogadzira, kunyangwe izvi hazvireve kuti zviri nyore kuwana mafaira eMySQL, zviri nyore kuzviita kuburikidza nemiraira yekuraira; inogona zvakare kuwanikwa kubva kune chero dhairekitori.
Saka kana iyo dhatabhesi injini yaiswa, iyo imwechete sisitimu inopa iyo "MySQL" faira, zvisinei kuti ndeipi folda yatiri, saka iko kusununguka kweLinux kuita ichi chiito.
PaMac
Vamwe vanofunga kuti iyi sisitimu inogara yakati siyanei ichienzaniswa nevakwikwidzi vayo Windows neLinux, asi zvinonakidza kuziva kuti paMac zvinoenderana zvakanyanya nemabatirwo akaitwa faira reMySQL pakombuta. Mune ino kesi, iwo murairo hauna kuwanikwa zvakananga senge muLinux kana Windows, kunyangwe ine dhatabhesi injini yakagadzirirwa.
Kuti tiite izvi, isu tinofanirwa kutsvaga paGoogle, iyo inotipa ruzivo rwese rwatinoda kuti twuwane pakombuta uye nekuwana zvakananga iyo "MySQL" faira. Kugadziriswa kunoitwa murudzi urwu rwefaira ndiko kushandiswa mukumisikidza chirongwa cheMamp; mhinduro yekukurumidza yesystem ichave FAQ, inozotibatsira kushandisa rairo "mysql" paMac uye kuiisa neMamp server.
Unganidza kune MySQL server
Mushure mekuwana iyo MySQL faira, iwe unofanirwa kubatana kune maneja kuburikidza neraira tambo. Wobva waenderera mberi kukumbira MySQL, uchiisa chinongedzo chefaira rine zita rimwe chete uye uchiratidza sarudzo dzekutanga dzekubatanidza.
Kana isu tikaisa "% mysql", isu tinowana mukana kune iyo yekuraira tambo uye kubva ipapo isu tinokwanisa kudzivirira iyo inokurumidza Mavambo, zvisinei nekuisa; c: mysqlbin>. Isu tinofuratira zvakananga "%" hunhu.
Icho chiratidzo chinobatana nedhatabhesi zvinoenderana nematanho uye mamiriro ezvinhu ane chirongwa nekutadza. Kuisa nekusunga iyo server yemuno ine zita rekushandisa kana password mune tambo dzisina chinhu; Ipapo iwe unofanirwa kuisa chimwe chidimbu cheruzivo kuti ugone kubatanidza kune dhatabhesi, semuenzaniso, isa zvinotevera parameter: mysql -h server_name -u username -p.
Zvino, kana tichida kubatanidza dhatabhesi kune server yemuno tichishandisa iro zita remushandisi, tinofanirwa kunyora zvinotevera: mysql -h localhost -u mudzi -p, mupfungwa iyi system inokumbira password yeiyo mhando yemudzi mushandisi Mushure mekuisuma, tinopinda mutsetse wekuraira weMySQL; saka iyo yekukurumidza shanduko kune inotevera: mysql>
Muchiitiko chekuratidza pasiwedhi zvakananga pamutsetse wekuraira, iko iko iko iko iko iko kwekuita kunogona kuitwa, asi hazvikurudzirwe nekuda kwezvikonzero zvekuchengetedza, mune ino murairo unenge uri: mysql -h localhost -u mudzi -pmi_key, pinda mu - py iyo my_key haifanire kusiya chero nzvimbo kunze kwekunge uri pane server yemuno.
Aya maitiro ekuronga akakosha mune yega yega sisitimu yekushandisa, kana iwe uchida kuwana rumwe ruzivo rwakanangana nemusoro uno, tinokukoka kuti uverenge inotevera chinyorwa Ndichiri muchirongwa
Uchishandisa iyo MySQL koni
Mushure mekuti isu tiri mukati mekoni, isu tinadzo dzese dzimwe nzira dzeMySQL yekuraira, iyo inotibvumidza isu kubata uye kuita chero chiitiko ne database uye iyo SQL kodhi. Nekudaro, zvinofanirwa kuve zvakajairwa kuti ubatanidze kune main database kutanga, kuve nesarudzo yekushanda zvakanyanya zvakachengeteka.
Nekudaro, iyo "shandisa" yekuraira inofanirwa kushandiswa ichiteverwa nezita re database yatinoda kubatanidza, ngatione muenzaniso: mysql> shandisa database yangu; isu tinobva tapinda "mybaseddata" dhatabhesi. Nekudaro, isu tinofanirwa kufunga nezvese zvirevo zvinofanirwa kunge zviri mukati meMySQL yekuraira mutsara.
Imwe neimwe inoperera muna ";". Saka kana tikasaisa iyo semicolon, rairo haizoitwe uye nekudaro rairo yekuraira ichaonekwa zvakare, chinova chiratidzo chekuti tinofanira kuramba tichipinda mitsara.
Nekudaro, kana isu tichingoda chete kuita chirevo icho isu chataive takasarudza nekungoisa «;» Zvichava zvakakwana. Neichi chikonzero, iwo wakazara kuraira haufanire kutaipwa zvekare uye unongoratidza ";" ndokurova kupinda.
Dhatabhesi runyorwa
Kusarudza dhatabhesi chaiyo tinofanirwa kuita chiito, icho chichatibvumira kuti tione kuti ndeapi aripo; nekuda kweizvi isu tinofanirwa kuisa syntax inotevera: mysql> ratidza dhatabhesi; Rondedzero inowanikwa neese dhatabhesi akawanikwa pakombuta yedu. Uye kumagumo zvinotevera zvinoratidzwa: mysql> ratidza dhatabhesi ->; 5 mitsara mune set (0.02 sec).
Gadzira dhatabhesi
Rangarira kuti isu tiri mukati meMysql faira, iri kutipa zviwanikwa zvekuita zviito zvakasiyana zvine chekuita nedatabhesi, chimwe chinhu chinodiwa kutama, kubata uye kurodha ruzivo kune chero server. Kana isu tichida kugadzira dhatabhesi, isu tinofanirwa kuita zvinotevera:
Nyora "gadzira dhatabhesi", ichiperekedzwa nezita ratiri kuda kuisa kune dhatabhesi nyowani, ngatione: mysql> gadzira dhatabhesi muenzaniso; izvi zvinogadzira iyo faira.
Izvo zvichagadzira dhatabhesi inonzi "muenzaniso", iyo inonyoreswa muMySQL, uye tinogona kuishandisa gare gare, saka kana tichida kuishandisa mune ramangwana tinoita zvinotevera chiitiko: mysql> shandisa muenzaniso.
Dhatabhesi manejimendi
Iyi dhatabhesi haina basa sezvo ichangogadzirwa, asi dai isu taive tichishandisa dhatabhesi yatove kushandiswa, isu tinofanirwa kunyora zita rayo. Zvakare, kana tichida kushandisa kana kuona matafura anoinyora, tinofanirwa kunyora "show tables", ngatione: mysql> show tables.
Mupfungwa iyi, dhatabhesi harina matafura, ruzivo rwakadai runobva rwaonekwa: "Empty set". Pane kupokana, kana paine akati wandei matafura mukati meiyo faira, rondedzero yematafura ichaonekwa ichiperekedzwa neinotevera: 2 mitsara museti (0.00 sec).
Kuti uwane data rakanangana nechero imwe uyezve uzive nzvimbo dziripo, pamwe nekirasi, isu tinofanirwa kushandisa rairo inotsanangura kudomwa uye zita retafura, seinotevera: mysql> tsananguro yemutungamiriri. 3 mitsara mune set (0.11 sec).
Kana iwe uchida kuziva zvakawanda nezve izvi nemimwe misoro, tinokurudzira kuverenga chinyorwa chinotevera PowerShell inoraira kwaunowana rumwe ruzivo rwakanangana nemusoro uyu
Zvimwe Zviito uye Kutongwa
Paunenge uri muMySQL koni, zvinongedzo zvinogona kuitwa kuburikidza nemirairo yekuraira: Mupfungwa iyi, chero mhando yekodhi inogona kukumbirwa uchishandisa SQL; ipapo tinogona kuita sarudzo, kugadzirisa, kugadzira tafura uye kuiswa.
Nzira yekuzviita iri nyore, kunyanya kana iwe uchiziva kumwe kuronga, maitiro acho ari enuitive uye ari nyore kubata, isu tinongofanirwa kuita chirevo ichocho mushure mekuisa semicolon. Ngatione muenzaniso:
- mysql> gadzira tafura bvunzo (test id int);
- Query OK, 0 mitsara yakakanganiswa (0.08 sec).
- Iwe unogona zvakare kushandisa zvinotevera: mysql> isa mu test (test id) kukosha (1);
- Query OK, 1 mutsara wakanganiswa (0.00 sec).
Chekupedzisira, tinotarisira kuti takagadzirisa kusahadzika kwakanangana nenyaya iyi ye database yeMySQL, iyo inobatsira zvikuru kumakambani nemasangano, kana iwe uchida kuwana rumwe ruzivo nezvayo, usakanganwa kuziva nekuverenga zvimwe zvirimo zviri mukati medu. portal.
