Nzira yekuwedzera kiyi yekunze mune phpMyAdmin

PHPMyAdmin: kiyi yekune imwe nyika, chii ichi?

Mune SQL database yemitauro yakawanda, uye kunyanya muPPMyAdmin, kiyi yekune imwe nzvimbo munda wefurafura iyo inoenderana nemunda weimwe dhatabhesi.

Izvi zvinoreva kuti hazvigoneke kugadzira yekupinda tafura inodzvinyirira neimwe kiyi yekune imwe tafura, kana imwe tafura isine yekupinda inoenderana nekiyi yekune imwe nyika iri kuiswa.

Semuenzaniso, izvi zvakafanana nekubatanidza bhodhoro uye cork yayo - haugone kushandisa cork kana bhodhoro risipo.

Nekuwedzera iyo PHPMyAdmin yekune kiyi kune tafura, iwe unoita shuwa kuti chero inopinda mutafura iyo ine chirevo chakananga kune yakasarudzika yekupinda mune imwe tafura. Iyo inogamuchirwa yakanaka tsika ndeyekugadzira PHPMyAdmin yekune kiyi yekureva mamwe matafura akaiswa nzvimbo, senge makiyi ekutanga, makiyi akasiyana kana indexed makiyi, kuitira kuti uve nechokwadi chekuti kupinda kumwechete kwakasarudzika kwakasiyana neiyo PHPMyAdmin yekune imwe kiyi yakagadzirwa.

Nzira yekugadzirisa sei chinyorwa chekunze mu phpmyadmin

Kuwedzera kiyi yekunze mune phpMyAdmin yakanaka kwazvo, asi chisarudzo chingave chakaoma kuwana.

Vhura tafura iyo iwe unoda kuwedzera kiyi yekunze. Endai kuTabhu Urongwa, maunowana mutsamba inonzi Relation View. Ikoko, sarudza kugovera iyo inobata kiyi yekunze, uye tafura uye chinyorwa chinotsanangurwa nekiyi.

Sezvo menus angangodaro akaoma kuoma kuwana, tarisa pasi pezvifananidzo.

Izvo zvinogona zvakare kuwedzera kiyi yekunze nekutevera SQL code:

ALTER TABLE `table1` ADD FOREIGN KEY (`FK_table2`) REFERENCES `table2` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT;

Gadzira kune imwe nyika kiyi phpmyadmin

Master webhusaiti wegumi: Nyoresa izvozvi!

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!

Nyoresa pano

Kugadzira kiyi yekunze kubvumira zvimwe zvingasarudzwa, kusanganisira kuve nechokwadi chekuti chinyorwa chine zvinyorwa zviripo pane imwe tafura, zvingaita kudzivirira kubviswa kwezvinyorwa mune imwe imwe tafura, kana kuti kuparadza kubviswa pane tafura dzakataridzwa.

Asi chimwe chezvinhu zvinonyanya kukosha, mu phpMyAdmin interface, ndeye kuwana dhiriri rezasi yezvinyorwa zvinyorwa zveimwe imwe tafura, kana kuisa zvinyorwa mutafura ine zvigori zvekunze.

Zvinokwanisika kusarudza kukosha kweiyo inoratidzirwa kubva pane tafura, kana iyi iri imwe inotsanangurwa nekwenyika yekunze kune imwe imwe tafura, sezviri pasi apa muenzaniso.

Nzira yekushandisa kiyi yekunze mune PHPMyAdmin

Mune zvigori zvekunze zvinopesana chikamu chetafura, chinyorwa chinyorwa chinogona kuiswa sechinhu chekune imwe nyika, kungoshandisa kushandisa graphical user interface.

Nzira yekubvisa sei keni yekunze mu PHPMyAdmin

Vhura tafura yaunoda kubvisa imwe kiyi yekune dzimwe nyika mune Phpmyadmin Interface. Enda kuhurongwa> Hurukuro Yevanoona, uye ipapo, tinya pane Drop mutsara unoenderana nekiyi yekune dzimwe nyika iwe yaunoda kudzima hukama mu phpmyadmin.

PHPMyAdmin ukama hunoonekwa hunofa

Ihu hukama hwehukama huri pasi pezita reTurati yebumbiro, mushure mokunge tafura yakasarudzwa kubva muFPMyAdmin mifananidzo yemashandisi ekushandisa.

Mibvunzo Inowanzo Bvunzwa

Maitiro ekuisa kiyi yekune dzimwe nyika muMYSQL PHPMYADMin?

Vhura tafura yaunoda kuwedzera iyo yekune dzimwe nyika kiyi. Enda ku chimiro tab, umo iwe uchawana iyo yehukama maonero submenu. Ikoko, sarudza iyo ikholamu iyo ichave nekiyi yekune imwe nyika, uye tafura uye column chinoratidzwa neiyi kiyi.

Ini ndinogadzira sei imwe kiyi yekune dzimwe nyika mu phpmyadmin?

Kuti ugadzire kiyi yekune dzimwe nyika muPHPMYADMin, iwe unofanirwa kuvhura tafura yaunoda iyo kiyi yekune imwe nyika, farai kune iyo chimiro tab, uye kubva ipapo, pinda mu submenu. Iwe unogona kubva sarudza iyo ikholamu iyo inobata iyo yekune imwe nyika kiyi uye sarudza tafura uye tsananguro yacho.

Matanho api anofanira kuteverwa kuti abudirire kuwedzera kiyi yekune dzimwe nyika yekumanikidza mu phpmyadmin?

Kuti uwedzere kiyi yekune dzimwe nyika muPHPMYARMin, farai kune iyo tab tab yeTafura yemwana, tinya iyo Yekukurukurirana Ita shuwa matafura ese ari matafura uye manyorerwo emakwenzi anorehwa ane nyorwa.