Yadda za a ƙara maɓallin waje waje a cikin phpMyAdmin

PHPMyAdmin: maɓallin ƙasar waje, menene?

A cikin harshen SQL database harshen gabaɗaya, kuma musamman a cikin PHPMyAdmin, maɓallin ƙasar waje shine filin tebur na bayanan bayanan wanda ya dogara da filin wani bayanan.

Wannan yana nufin cewa ba zai yiwu a ƙirƙirar shigarwa a cikin tebur ba tare da jujjuya ba ta hanyar maɓallin baƙon wata teburin, idan ɗayan teburin ba su ƙunshi shigar da ya dace da maɓallin ƙasar waje ba.

Misali, wannan kamar haɗa kwalban da abin toshe kwalaba - ba za ku iya amfani da abin toshe kwalaba ba idan kwalban ba ya nan.

Ta hanyar sanya maɓallin ajiyar waje na PHPMyAdmin a tebur, zaku tabbatar cewa duk shigarwa a cikin wannan tebur yana da alaƙar kai tsaye ga keɓaɓɓen shigarwar tebur. Kyakkyawan aiki da aka amince da shi gaba ɗaya shine ƙirƙirar PHPMyAdmin maɓallin ƙasar waje don ɗaukar sauran filayen jeri, kamar maɓallan farko, maɓallan musamman ko maɓallan da aka lissafa, don tabbatar da cewa shigarwa guda ɗaya tak da PHPMyAdmin maɓallin ƙasar waje wanda aka ƙirƙira shi.

Yadda za a saita maɓallin waje a cikin phpmyadmin

Ƙara maɓallin waje waje a cikin phpMyAdmin yana da sauki, amma zabin zai iya da wuya a samu.

Bude teburin da kake son ƙarawa maɓallin waje. Jeka shafin Tsarin, inda za ka ga wani menu na da ake kira Relation View. A can, zaɓi zuwa shafi wanda zai riƙe maɓallin waje, da kuma teburin da shafi wanda aka rubuta ta wannan maɓallin.

Yayin da menus zasu iya zama matukar wuya a samu, koma zuwa kasafin allo.

Haka ma za a iya ƙara maɓallin waje na waje tare da bin ka'idar SQL:

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

Ƙirƙirar phpmyadmin waje waje

Koyi Abubuwan SEO: Yi rajista a yau!

Bomanceancin Gaban Yanar Gizon yanar gizonku da zirga-zirga ta hanyar kwantar da kayan aikin yau da kullun na Seo tare da maganganu masu sauƙin zuwa.

Fara koyo

Samar da maɓalli na waje don ba da damar dama da dama, ciki har da tabbatar da cewa shafi kawai yana ƙunshe da shigarwar da ke cikin wani tebur, yiwuwar hana hana sharewa a cikin sauran tebur, ko don sakawa zuwa shafukan da aka ambata.

Amma ɗayan zaɓin da ya fi dacewa, a cikin dubawa na phpMyAdmin, shine don samun jerin jerin zaɓuɓɓuka tare da shigarwar sauran launi, lokacin sakawa shigarwa a cikin tebur wanda ke dauke da maɓallin waje.

Yana da yiwuwa a yanke shawarar wane darajar da aka nuna ta tsoho daga tebur, lokacin da wannan mahimmanci ke nunawa ta hanyar maɓallin waje waje a wani tebur, kamar yadda misali ta ƙasa.

Yadda ake amfani da maɓallin waje waje a cikin PHPMyAdmin

A cikin makullin maɓallin ƙananan maɓallin kewayawa na tebur, ana iya saita ginshiƙan rubutun a matsayin maɓalli na waje, kawai ta yin amfani da keɓaɓɓen mai amfani da aka tsara.

Yadda za a cire maɓallin waje a cikin PHPMyAdmin

Bude tebur wanda kake son cire maɓallin waje a cikin phpMyAdmin dubawa. Je zuwa tsari> Duba Duba, kuma akwai, danna maɓallin Drop a cikin layi mai dacewa da maɓallin waje da kake son share dangantaka a phpMyAdmin.

PHPMyAdmin dangantaka bace bace

Bangaren haɗin yana samuwa a ƙarƙashin Siffar sunan suna, bayan an zabi tebur daga mai amfani na mai amfani na PHPMyAdmin.

Tambayoyi Akai-Akai

Yadda za a kafa maɓallin waje a MySQL phpMyAdmin?

Bude Table inda kake son ƙara maɓallin waje. Je zuwa shafin tsarin wanda zaku sami Dangantaka mai ban sha'awa Mentmenu. A can, zaɓi shafi wanda zai ɗauki maɓallin na waje, da tebur da shafi da aka ambata ta maɓallin da wannan maɓallin.

Ta yaya zan ƙirƙiri maɓallin waje a phpMyAdmin?

Don ƙirƙirar maɓallin waje a cikin phpMyAdmin, kuna buƙatar buɗe maɓallin waje inda kake son maɓallin waje, Kewaya zuwa ga dangantakar Mermenu . Daga nan za ka iya zaɓar shafi wanda zai riƙe maɓallin waje kuma zaɓi teburin da shafi shi ne nassoshi.

Wadanne matakai ya kamata a bi su ga nasarar ƙara maɓallin waje a phpMyAdmin?

Don ƙara maɓallin waje a cikin phpMyAdmin, kewaya cikin tsarin shafin tebur, zaɓi maɓallin keɓaɓɓen, sannan ku saka teburin da aka ambata. Tabbatar da duka teburin da aka ambata kuma ana tunanin ginannun ginshiƙai.