{"id":2500,"date":"2018-06-19T10:35:24","date_gmt":"2018-06-19T08:35:24","guid":{"rendered":"https:\/\/www.ybierling.com\/v2\/?p=2500"},"modified":"2018-06-19T10:35:24","modified_gmt":"2018-06-19T08:35:24","slug":"como-agregar-una-clave-externa-en-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.ybierling.com\/v2\/es\/como-agregar-una-clave-externa-en-phpmyadmin\/","title":{"rendered":"C\u00f3mo agregar una clave externa en phpMyAdmin"},"content":{"rendered":"<p>Agregar una clave for\u00e1nea en phpMyAdmin es bastante simple, pero la opci\u00f3n puede ser dif\u00edcil de encontrar.<\/p>\n<p>Abra la tabla en la que desea agregar la clave externa. Vaya a la pesta\u00f1a Estructura, en la que encontrar\u00e1 un sub men\u00fa llamado Vista de relaci\u00f3n. All\u00ed, seleccione la columna que contendr\u00e1 la clave externa y la tabla y columna a las que hace referencia esta clave.<\/p>\n<p>Como los men\u00fas pueden ser bastante dif\u00edciles de encontrar, consulte las siguientes capturas de pantalla.<\/p>\n<p>Tambi\u00e9n es posible agregar una clave externa con el siguiente c\u00f3digo SQL:<\/p>\n<p>&nbsp;<\/p>\n<blockquote><p><span class=\"cm-keyword\"><a class=\"cm-sql-doc\" href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/alter-table.html\" target=\"mysql_doc\">ALTER<\/a><\/span>\u00a0<span class=\"cm-keyword\"><a class=\"cm-sql-doc\" href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/alter-table.html\" target=\"mysql_doc\">TABLE<\/a><\/span>\u00a0<span class=\"cm-variable-2\">`table1`<\/span>\u00a0<span class=\"cm-keyword\">ADD<\/span>\u00a0<span class=\"cm-keyword\">FOREIGN<\/span>\u00a0<span class=\"cm-keyword\">KEY<\/span>\u00a0(<span class=\"cm-variable-2\">`FK_table2`<\/span>)\u00a0<span class=\"cm-keyword\">REFERENCES<\/span>\u00a0<span class=\"cm-variable-2\">`table2`<\/span>(<span class=\"cm-variable-2\">`ID`<\/span>) <span class=\"cm-keyword\">ON<\/span>\u00a0<span class=\"cm-keyword\"><a class=\"cm-sql-doc\" href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/delete.html\" target=\"mysql_doc\">DELETE<\/a><\/span>\u00a0<span class=\"cm-keyword\">RESTRICT<\/span>\u00a0<span class=\"cm-keyword\">ON<\/span>\u00a0<span class=\"cm-keyword\"><a class=\"cm-sql-doc\" href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/update.html\" target=\"mysql_doc\">UPDATE<\/a><\/span>\u00a0<span class=\"cm-keyword\">RESTRICT<\/span>;<\/p><\/blockquote>\n<p>La creaci\u00f3n de una clave externa permite varias opciones, incluido el asegurarse de que una columna solo contenga entradas existentes en otra tabla, la posibilidad de evitar la eliminaci\u00f3n de entradas en la otra tabla, o de poner en cascada la eliminaci\u00f3n en las tablas a las que se hace referencia.<\/p>\n<p>Pero una de las opciones m\u00e1s \u00fatiles, en la interfaz phpMyAdmin, es obtener una lista desplegable con las entradas de la otra tabla, al insertar entradas en una tabla que contiene claves externas.<\/p>\n<p>Incluso es posible decidir qu\u00e9 valor se muestra de forma predeterminada en una tabla, cuando se hace referencia a una con una clave externa en otra tabla, como se muestra en el ejemplo siguiente.<\/p>\n<p>&nbsp;<\/p>\n<blockquote>\n<figure id=\"attachment_2488\" aria-describedby=\"caption-attachment-2488\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_19-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png\"><img decoding=\"async\" class=\"size-medium wp-image-2488\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_19-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x132.png\" alt=\"How to add a foreign key in phpMyAdmin : First table with a field for a foreign key referencing an identifier in another table\" width=\"300\" height=\"132\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_19-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x132.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_19-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png 742w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2488\" class=\"wp-caption-text\">\u00a0Primera tabla con un campo para una clave externa que hace referencia a un identificador en otra tabla<\/figcaption><\/figure>\n<figure id=\"attachment_2487\" aria-describedby=\"caption-attachment-2487\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_53_16-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7.png\"><img decoding=\"async\" class=\"size-medium wp-image-2487\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_53_16-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7-300x124.png\" alt=\"How to add a foreign key in phpMyAdmin : Second table to be referenced by a foreign key\" width=\"300\" height=\"124\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_53_16-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7-300x124.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_53_16-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7.png 697w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2487\" class=\"wp-caption-text\">Segunda tabla a la que se hace referencia mediante una clave externa<\/figcaption><\/figure>\n<figure id=\"attachment_2489\" aria-describedby=\"caption-attachment-2489\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png\"><img decoding=\"async\" class=\"size-medium wp-image-2489\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x103.png\" alt=\"How to add a foreign key in phpMyAdmin : Inserting a foreign key in phpMyAdmin web interface\" width=\"300\" height=\"103\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x103.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-768x265.png 768w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-1024x353.png 1024w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_05_49-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png 1509w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2489\" class=\"wp-caption-text\">\u00a0 Insertar una clave externa en la interfaz web phpMyAdmin<\/figcaption><\/figure>\n<figure id=\"attachment_2490\" aria-describedby=\"caption-attachment-2490\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2490\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x104.png\" alt=\"How to add a foreign key in phpMyAdmin : Foreign key successfully added in phpMyAdmin\" width=\"300\" height=\"104\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x104.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-768x266.png 768w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-1024x355.png 1024w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_02-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png 1078w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2490\" class=\"wp-caption-text\">\u00a0La clave externa se agreg\u00f3 con \u00e9xito en phpMyAdmin<\/figcaption><\/figure>\n<figure id=\"attachment_2491\" aria-describedby=\"caption-attachment-2491\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2491\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x109.png\" alt=\"How to add a foreign key in phpMyAdmin : Foreign key displayed with table field during entry insertion\" width=\"300\" height=\"109\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-300x109.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-768x279.png 768w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7-1024x372.png 1024w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-11_06_50-localhost-_-127.0.0.1-_-test-_-table1-_-phpMyAdmin-4.7.7.png 1043w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2491\" class=\"wp-caption-text\">Clave externa que se muestra con el campo de la tabla durante la inserci\u00f3n de la entrada<\/figcaption><\/figure>\n<figure id=\"attachment_2492\" aria-describedby=\"caption-attachment-2492\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_50_06-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2492\" src=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_50_06-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7-300x174.png\" alt=\"How to add a foreign key in phpMyAdmin : Selection of the field to display for foreign key references\" width=\"300\" height=\"174\" srcset=\"https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_50_06-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7-300x174.png 300w, https:\/\/www.ybierling.com\/v2\/wp-content\/uploads\/2018\/06\/2018-06-19-10_50_06-localhost-_-127.0.0.1-_-test-_-table2-_-phpMyAdmin-4.7.7.png 510w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-2492\" class=\"wp-caption-text\">Selecci\u00f3n del campo a visualizar para referencias de clave externa<\/figcaption><\/figure><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Agregar una clave for\u00e1nea en phpMyAdmin es bastante simple, pero la opci\u00f3n puede ser dif\u00edcil de encontrar. Abra la tabla<\/p>\n","protected":false},"author":1,"featured_media":2491,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[594],"tags":[6726,6821,6817,6811,6813,6815,6744,6819,6809,6750],"class_list":["post-2500","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-es","tag-base-de-datos","tag-campo-de-visualizacion-phpmyadmin","tag-clave-externa-mysql","tag-clave-extranjera-phpmyadmin","tag-como-agregar-una-clave-foranea-en-phpmyadmin","tag-inserte-la-clave-externa-phpmyadmin","tag-mesa","tag-mysql-clave-externa-phpmyadmin","tag-pantalla-campo-exterior-clave-phpmyadmin","tag-phpmyadmin-es"],"_links":{"self":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/2500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/comments?post=2500"}],"version-history":[{"count":1,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/2500\/revisions"}],"predecessor-version":[{"id":2501,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/2500\/revisions\/2501"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/media\/2491"}],"wp:attachment":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/media?parent=2500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/categories?post=2500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/tags?post=2500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}