Ndingachinja sei schema muMySQL Workbench?

Kugadziridzwa kwekupedzisira: 15/09/2023
Munyori: Sebastian Vidal

Bhenji rekushanda reMySQL Icho chishandiso chinobatsira kwazvo kubata uye kubata MySQL dhatabhesi. Kuburikidza nezvayo chimiro chemifananidzo uye akasiyana mashandiro, anobvumidza iwe kugadzira uye kugadzirisa matafura, mibvunzo uye schemas zvinobudirira. Zvisinei, pane imwe nguva ungada shandura chirongwa uye igadzirise kune zvitsva zvinodiwa kana zvinodiwa. Munyaya ino, tichatsanangura nhanho nhanho sei kuchinja schema muMySQL Workbench,⁤ kuti iwe ugone kuita⁢ basa iri nenzira iri nyore uye inoshanda.

Danho rekutanga ku shandura schema muMySQL Workbench ndiko kuvhura chishandiso uye sarudza iyo chirongwa kuti unoda kugadzirisa. Iwe unogona kuita izvi kuburikidza nekuruboshwe rekufambisa panhizha, kwaunowana runyoro nehurongwa huripo.

Kana chirongwa ichi chasarudzwa, tinya-kurudyi pairi uye sarudza sarudzo "Alter Schema" kubva pane yekudonhedza-pasi menyu. Iyi sarudzo inokubvumira iwe gadzirisa uye gadzirisa schema yazvino pasina kuda kugadzira imwe nyowani.

Kudzvanya pa "Alter Schema" kuchavhura hwindo nyowani ine zvese zvingasarudzwa. kuchinja uye kugadzirisa ⁢ inowanikwa. Pano unogona wedzera matafura matsva, ⁤ bvisa matafura aripo, shandura minda, rename matafura uye ita chero mamwe magadzirirwo anodiwa kune schema.

Kana shanduko dzakakodzera dzaitwa, tinya bhatani "Nyorera" kushandisa zvigadziriso kune schema. MySQL Workbench inokuratidza a pfupiso yekuchinja yakagadzirwa uye ndichakupa sarudzo yeku chengetedza SQL script inogadzirwa kana iwe uchida kuishandisa gare gare.

Muchidimbu, shandura schema muMySQL Workbench Iyo iri nyore maitiro ayo anogona kuitwa kuburikidza neiyo graphical interface yechishandiso. Nekutevera matanho ataurwa pamusoro, iwe unozokwanisa kugadzirisa uye kugadzirisa schemas ako nekukurumidza uye zvinobudirira, pasina chikonzero chekuita mibvunzo yakaoma kana mirairo yeSQL.

-MySQL ⁤Workbench kuisirwa

Bhenji rekushanda reMySQL Icho chishandiso chinooneka iyo inoshandiswa yekutonga nekusimudzira dhatabhesi reMySQL. Nayo, vashandisi vanogona kubata ese ane chekuita nedhatabhesi mabasa kubva kune intuitive uye nyore-kushandisa-interface. Kuburikidza Workbench, zvinokwanisika kugadzira uye kugadzirisa matafura, kunyora Mibvunzo yeSQL, ⁤perform ma backups uye kudzorera dhatabhesi, pakati pemamwe mabasa.

Imwe yeakajairika mabasa⁢ muMySQL Workbench ndeye shandura chirongwa. Iyo schema ⁤muMySQL inzira yekuronga nekuunganidza matafura. dhatabhesi. Dzimwe nguva zvinodikanwa kushandura chirongwa kuti chigadzirise kune zvitsva zvinodiwa kana kugadzirisa chimiro chiripo. Kuti uite izvi, unogona kutevera matanho anotevera:

  • Vhura MySQL⁤ Workbench: Tangisa application uye ita shuwa kuti wakabatana kune yakakodzera dhatabhesi.
  • Sarudza chirongwa: Muchikamu chekuruboshwe cheWorkbench, tsvaga chikamu che "SCHEMAS" uye tinya-kurudyi pane chirongwa chaunoda kuchinja.

Mune iyo pop-up hwindo, sarudza iyo "Set seDefault Schema" sarudzo yekuita iyo schema iyo yakasarudzika kana ichibatanidza kune dhatabhesi. Iwe unogona zvakare kusarudza iyo "Alter ⁤Schema" sarudzo kana iwe uchida kugadzirisa ikozvino schema marongero. Rangarira kuti shanduko kune schema inogona kukanganisa matafura uye data yakachengetwa mudhatabhesi, saka ita shuwa kuita a kuchengetedza usati waita chero shanduko.

- Svika dhatabhesi iripo

Svika dhatabhesi iripo

Kamwe kubatana kwakabudirira kwave kwakatangwa neMySQL Workbench, zvinokwanisika kukurumidza kuwana database iripo. Ichi dhatabhesi manejimendi chishandiso chinopa intuitive uye nyore-kushandisa interface iyo inokutendera iwe kuti ufambe kuburikidza akasiyana dhatabhesi uye matafura. zvinobudirira.⁣ Ingosarudza iyo yakasimbiswa yekubatanidza muhwindo reimba uye hwindo idzva richavhurika otomatiki nesarudzo dzese dziripo dzekugadzirisa dhatabhesi.

Kana tangowana dhatabhesi iripo muMySQL Workbench, kune akasiyana mavhisi anogona kuitwa. Zvinogoneka kuona ⁢kuumbwa ⁤kwedhatabhesi, gadzirisa uye bvunza data rakachengetwa, ita tsika SQL mibvunzo. uye kuita mabasa ekugadzirisa.⁣ Pamusoro pezvo, Matafura, indexes, maonero, uye akachengetwa maitiro anogona kugadzirwa uye kugadziridzwa sezvinodiwa. Aya mabasa anoita kuti MySQL Workbench ive yakakwana uye ine simba chishandiso chekudyidzana nemadatabase aripo.

Exclusive content - Click Here  Ndeupi musiyano uripo pakati peOracle Database Express Edition neStandard Edition?

Zvakakosha kuziva kuti MySQL Workbench inobvumirawo kupinza uye kutumira kunze data kubva uye kuenda kune dhatabhesi. ⁤Zvakare, MySQL Workbench inopa sarudzo dzekugadzirisa uye tune query performance⁤ SQL, iyo yakakosha kuve nechokwadi chekuwana nekukurumidza kune dhatabhesi uye kushanda kwakanaka mune zvese.

Tarisa schema yazvino

Paunenge uchishanda muMySQL Workbench, zvakakosha kuti uzive mafambiro uye kufamba uchitenderera ikozvino chirongwa. Izvi zvinotibvumira kuwana matafura akasiyana, maonero uye mibvunzo yakachengetwa mudhatabhesi redu. Neraki, chishandiso chinopa nzira dzinoverengeka dzekuita izvi⁢ nekukurumidza uye nemazvo.

Nzira iri nyore yekufambisa yazvino ndeye kushandisa kuruboshwe zvinhu pani. Pano tinowana runyoro rwematafura ese uye zvinhu mune yazvino schema. Tinogona ⁤ wedzera nekuputsira matafura kuratidza makoramu ayo uye humwe humbowo hwakakodzera.. Tinogona zvakare kudzvanya-kurudyi patafura kuti tivhure menyu yemamiriro ekunze nemamwe sarudzo, sekuona data retafura kana kugadzirisa chimiro chayo.

Imwe nzira inobatsira yekufamba nayo ikozvino ndeye kushandisa navigation toolbar. Iyi bar iri pamusoro pehwindo rebasa uye inotibvumira famba nekukurumidza pakati pezvinhu zvakasiyana mu schema. Tinogona kushandisa miseve yekufambisa kuenda kune yakapfuura kana inotevera chinhu, kana isu tinogona kusarudza chimwe chinhu tichishandisa yekudonha-pasi menyu. Uyezve, mudziyo wekushandisa navigation inotipa mukana wekukurumidza kune zvimwe zviito, senge gadzira tafura itsva kana kugadzira ⁤ER report.

Muchidimbu, kufambisa schema iripo muMySQL Workbench kwakakosha kuti ushande nemazvo. nzira inoshanda nemadatabase edu. ⁢Ose ari maviri eruboshwe chinhu chepaneru uye bhara rekufambisa zvinotipa sarudzo dzakasiyana dzekuwana uye kuongorora zvinhu zviri muchirongwa. Tichishandisa maturusi aya, tinogona kuchengetedza nguva nekuvandudza chigadzirwa chedu kana tichishanda⁢ neMySQL Workbench.

- Shandura schema muMySQL Workbench

1. Kugadzirisa schema muMySQL Workbench kwakakosha kuti uvandudze uye⁤ kuronga dhatabhesi rako.

Kugadzirisa schema muMySQL Workbench Iri ibasa rakakosha kune avo vanoda kugadzirisa uye kuronga dhatabhesi ravo nemazvo. Kunyangwe iwe uchida kutumidzazve schema iripo, gadzira nyowani, kana kudzima schema isingachashandi, ichi chishandiso chinokupa sarudzo dzese dzinodiwa kuita aya mabasa. zvakachengeteka uye inoshanda.

Paunoshanda neMySQL‍ Workbench, unogona pinda iyo schematic editor kugadzirisa zvese zvinodiwa. Pano iwe unogona kuona rondedzero yearipo schemas mune yako dhatabhesi uye wowedzera matafura matsva kana makoramu, gadzirisa zviripo kana kudzima izvo zvausingachada. Izvo zvakakosha kuti uzive kuti chero shanduko yaunoita kune schema inofanirwa kutorwa nekuchenjerera, sezvo inogona kuve nemhedzisiro yakakura pakushanda kwedhatabhesi.

2. Matanho ari nyore ⁤kuchinja schema muMySQL Workbench

Kana uchida shandura schema muMySQL Workbench, tevera matanho ari nyore kuti uzviwane zvinobudirira:

1. Vhura MySQL Workbench uye sarudza ⁤kubatanidza kune⁢ database yaunoda kuchinja.
2. Muchikamu chepamusoro chepamusoro, chengetedza pa "Schemes" tab, iyo ichakuendesa kune schematic editor.
3. Pano iwe uchaona runyoro rwezvirongwa zviripo mudhatabhesi. Tinya-kurudyi pane chirongwa chaunoda kushandura uye sarudza iyo inoenderana sarudzo maererano nezvaunoda: "Rename chirongwa", "Delete chirongwa" kana "Gadzira chirongwa chitsva".
4. Kana ukasarudza "Rename Scheme", hwindo rinoputika richazarura kwaunogona kuisa zita idzva rechirongwa uye kusimbisa kuchinjwa. Kana ukasarudza "DeleteScheme", iwe unozokumbirwa imwe simbiso kuti uve nechokwadi chekuti unoda kudzima zvachose chirongwa. Pakupedzisira, kana ukasarudza "Gadzira chirongwa chitsva", iwe unongofanira kuisa zita raunoda rechirongwa chitsva.
5. Kana uchinge waita shanduko dzinodiwa, chengetedza uye shandisa zvigadziriso kuitira kuti zviitike mu database.

Exclusive content - Click Here  MongoDB inoshanda sei?

3. Kukosha kwekugadzira makopi ekuchengetedza usati wachinja schema

Usati waita chero shanduko kune yako database⁢ schema muMySQL Workbench, zvakakosha kuti uite makopi ekuchengetedza. kudzivirira chero kusingatarisirwe data kurasikirwa. Izvi zvinokutendera kuti udzorere dhatabhesi kana matambudziko amuka panguva yekuchinja maitiro.

Pane nzira dzakasiyana dzekuita ma backups muMySQL Workbench, kusanganisira basa rekutumira iro rinokutendera kuti uchengetedze kopi yedhatabhesi kuSQL faira. Pamusoro pezvo, iwe unogona zvakare kushandisa maturusi ekunze kuchengetedza dhatabhesi, sekugadzira nguva nenguva uchishandisa zvinyorwa zvetsika kana kushandisa otomatiki backup maturusi.

Usakanganwa kuti ⁢the kuchengetedzeka kwedata rako kwakakosha uye iwe unofanirwa kugara uine chokwadi chekuti une backup usati waita chero shanduko kune schema. Nenzira iyi, iwe unogona kuva nerunyararo rwepfungwa kuti kana paine kusagadzikana, iwe unozokwanisa kudzoreredza dhatabhesi yako pasina matambudziko uye kuenderera mberi nemabasa ako pasina kunonoka kukuru.

- Ita shanduko kumatafura aripo

Kuita shanduko kumatafura aripo muMySQL Workbench, zvakakosha kuchengeta matanho mashoma mupfungwa. Chekutanga pane zvese, isu tinofanirwa kuvhura dhatabhesi umo tafura yatinoda kugadzirisa iripo. Kuti tiite izvi, tinogona kusarudza dhatabhesi mubhara rekuruboshwe uye tinya-kurudyi pairi kusarudza "Open Database" sarudzo.

Kana tangove nedhatabhesi rakavhurika, tinowana tafura yatinoda kugadzirisa uye tinya kaviri pairi kuti uvhure mupepeti wayo. Mune ino edhita tinogona kuona ese makoramu uye zvivakwa zvetafura. Zvakakosha kuchengeta mupfungwa kuti pakuita shanduko kune tafura iripo, izvi zvinogona kukanganisa data yakatochengetwa mairi.. Naizvozvo, zvinokurudzirwa kuita kopi yekuchengetedza yedatabase usati waita chero shanduko.

Kuita shanduko kune chimiro chetafura, tinogona kushandisa sarudzo dziripo mupepeti yetafura. Semuenzaniso, tinogona kuwedzera makoramu matsva, kudzima makoramu aripo, kana kugadzirisa zvimiro zvemakoramu aripo. Isu tinogona zvakare kushandura zita retafura kana kuwedzera indexes kuti tivandudze kuita kwemubvunzo. Zvakakosha chengetedza shanduko dzakaitwa patafura usati wavhara mupepeti. Kana isu tichida kuve nechokwadi chekuti shanduko dzinoshandiswa nemazvo, tinogona kuyedza neimwe bvunzo data tisati tagadzirisa tafura mukugadzira.

-Wedzera matafura matsva kune schema

Kuti uwedzere matafura matsva kune schema muMySQL Workbench, unogona kutevera matanho aya:

1. Gadzira chinongedzo kune database: Vhura ⁢MySQL Workbench uye enda ku "Database" tab. Dzvanya bhatani re "Manage Connections" uye gadzira chinongedzo chitsva nekuisa ruzivo rwesevha yako yedatabase. Paunenge uchinge wagadzira kubatana, iwe uchaona yako yazvino dhatabhesi schema mune yekuruboshwe pane.

2. Sarudza hurongwa hwekuenda: Mupaneruboshwe, wedzera iyo schema yedatabase yaunoda kuwedzera iyo tafura nyowani. Tinya-kurudyi pane schema uye ⁢ sarudza ⁣»Seta seDefault Schema»⁤ kuti uve nechokwadi chekuti matafura matsva anogadzirwa mune icho schema.

Exclusive content - Click Here  Zvinokwanisika here kubatanidza Redis Desktop Manager kune mawebhusaiti ekunze?

3. Gadzira tafura itsva: Tinya-kurudyi schema wosarudza ‌»Gadzira Tafura» kuti uvhure ⁤mupepeti wetafura.⁤ Pano, unogona kudoma zita retafura uye wotsanangura ⁢ makoramu, marudzi edata rawo, uye zvinomanikidza. Iwe unogona kushandisa edhita sarudzo kuwedzera makoramu, kutsanangura makiyi ekutanga, kutanga hukama, nezvimwe. Paunenge wapedza kutsanangura tafura, tinya bhatani rekuti "Shandisa" kuti uigadzire mune yakasarudzwa schema.

Rangarira kuti kana uchiwedzera matafura matsva kune schema, unogona zvakare kushandisa mamwe maficha eMySQL Workbench senge chizvarwa cheSQL zvinyorwa, kupinza uye kutumira kunze kwedata, kana dhizaini yekuona yematafura. Zvishandiso izvi zvinokutendera kuti ugadzirise uye uite otomatiki maitiro ekushanda ne⁤ dhatabhesi muMySQL Workbench. Ongorora zvese zvingangopihwa neiyi ine simba dhatabhesi manejimendi chishandiso!

- Shandisa shanduko kune schema

Danho rekutanga: Vhura MySQL Workbench uye sarudza iyo dhatabhesi yekubatanidza kwaunoda kushandisa shanduko ye schema.

Danho rekutanga: Tinya-kurudyi schema yaunoda kuita shanduko uye sarudza "Alter Tafura" kubva pane yekudonha-pasi menyu. ‍

  • Danho rekutanga: Iwindo rinobuda richaonekwa riine akati wandei sarudzo dzekugadzirisa. Pano iwe unogona kuwedzera, kudzima kana kugadzirisa makoramu, pamwe nekuchinja marudzi e data kana zvirambidzo.
  • Danho rekutanga: Kana uchida wedzera a⁢ column,⁢ sarudza "Wedzera Column" uye ⁣ zadzisa ruzivo rwunodiwa, senge zita rekoramu, mhando yedata, uye zvipingaidzo.
  • Danho rekutanga: Kana muchida bvisa chikamu, sarudza "Drop Column" uye sarudza iyo column yaunoda kudzima.
  • Danho rekutanga: Kana uchida shandura chikamu chiripo, sarudza "Modify Column" uye ita chero shanduko inodiwa, yakadai semhando yedata kana zvirambidzo.
  • Danho rechishanu: Paunenge waita shanduko dzese dzinodiwa, tinya "Shandisa" kushandisa shanduko kune schema. Ndapota cherechedza kuti dzimwe shanduko dzingada kuti tafura igadzirwezve, izvo zvingatora nguva zvichienderana nekukura kwetafura.

Mazano: Usati waisa shanduko kune ⁢schema, ⁢inokurudzirwa kuita backup yedatabase kudzivirira kurasikirwa kweruzivo kana paine zvikanganiso panguva yekuita. Pamusoro pezvo,⁢ zvakakosha kuziva kuti shanduko ku schema inogona kuve nemhedzisiro pamibvunzo iripo uye mamwe mabasa ane chekuita nedhatabhesi, saka zvakakosha kuita bvunzo dzakakura usati waita shanduko kunharaunda yekugadzira.

- Export uye chengetedza iyo yakagadziridzwa schema

Kana uchinge waita shanduko inodiwa kune yako dhatabhesi schema⁣ muMySQL Workbench, zvakakosha kuti ugone kutumira kunze uye kuchengetedza shanduko idzi kuti ugone kudzishandisa mukuvandudza mune ramangwana kana kutama. Neraki, MySQL Workbench inopa nyore uye inoshanda mashandiro kuita basa iri.

Kuendesa kunze iyo yakagadziridzwa schema, iwe unongotevera aya matanho:

1. Sarudza chirongwa chakagadziridzwa: Mu "Schemas" tebhu yeMySQL Workbench, tsvaga uye ⁢sarudza iyo ⁤schema yawakagadzirisa. ⁤Unogona kuita izvi nekudzvanya-kurudyi pakarongwa uye wosarudza “Sarudza Scheme.”

2. Export the schematic: MuMySQL⁤ Workbench menyu bar⁤, sarudza "Server" uyezve "Data Export." Muwindo re "Data Export", sarudza schema yakagadziridzwa yaunoda kutumira kunze uye isa nzvimbo uye zita refaira rekuenda. Iva nechokwadi chekusarudza sarudzo dzese dzaunoda kutumira kunze, senge matafura, maitiro akachengetwa, uye maonero.

3. Sevha yakagadziridzwa ⁢chirongwa: Kana uchinge watumira kunze kwenyika schematic, iva nechokwadi chekuchengeta faira munzvimbo yakachengeteka kuitira ramangwana. Iwe unogona kuchengetedza iyo faira kune vhezheni control repository kana kune chaiyo folda muprojekiti yako. Pamusoro pezvo, zvinokurudzirwa kuchengeta rekodhi yeshanduko dzakaitwa mugwaro rakaparadzana kufambisa manejimendi nekubatana nedzimwe nhengo dzechikwata.