{"id":5302,"date":"2026-01-19T16:44:22","date_gmt":"2026-01-19T15:44:22","guid":{"rendered":"https:\/\/sutilweb.eu\/?page_id=5302"},"modified":"2026-01-19T16:44:23","modified_gmt":"2026-01-19T15:44:23","slug":"36-crear-tablas-en-mysql","status":"publish","type":"page","link":"https:\/\/sutilweb.eu\/index.php\/lenguajes\/php\/php-practico\/36-crear-tablas-en-mysql\/","title":{"rendered":"36. Crear tablas en MySQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Vamos a trabajar con <strong>MySQL Workbench<\/strong>, el cual permite crear tablas de dos maneras, o bien mediante un script o bien mediante una de las opciones que permite Workbench.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creaci\u00f3n mediante las opciones de Workbench<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La ruta a seguir es:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Schemas &gt; base de datos a elegir &gt; Tables &gt; Create Table<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Luego hay que ir siguiendo los pasos que te indica el asistente de Workbench.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00cdndice<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Una tabla siempre ha de tener uno o varios campos que identifiquen cada registro como \u00fanico en cada tabla. La clave primaria, que es un tipo de \u00edndice, puede ser campo de cualquier tipo, pero debe tener en cuenta que MySQL dar\u00e1 un error si intenta guardar dos registros con el mismo valor de ese campo. Lo que debemos hacer es, de los campos que hemos creado, uno de ellos deber\u00e1 ser una clave primaria, algo que identifique a cada uno de los registros. Cuando no existe ning\u00fan campo que pueda hacer de clave primaria, incluiremos un campo al que se le suele llamar <strong><em>id.&nbsp;<\/em><\/strong>Estos ids van a llevar n\u00fameros \u00fanicos que vamos a utilizar para identificar a un usuario. Nuestro campo id ser\u00e1 del tipo INT, PK (Primary Key o clave primaria), NN (Not Null o no nulo) y AI (Auto Increment o autoincremental). Este id suele ser el primer campo que se crea.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez tengamos todos los campos creados, hemos de darle en nuestro Workbench al bot\u00f3n <strong><em>Apply<\/em><\/strong> para que se cree la tabla.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creaci\u00f3n de tabla mediante un script<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Para ello hacemos clic en el bot\u00f3n SQL que est\u00e1 arriba a la izquierda de nuestro Workbench, y vamos a escribir el siguientd c\u00f3digo SQL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ejm<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE `ejemplo`.`contactos`(\n`id` INT NOT NULL AUTO_INCREMENT,\n`nombre` VARCHAR(64) NOT NULL,\n`apellido` VARCHAR(64) NOT NULL,\n`direccion` VARCHAR(255) NOT NULL,\n`tlfo` VARCHAR(9) NOT NULL,\n`email` VARCHAR(255) NOT NULL,\n`fecha_nacimiento` DATE DEFAULT NULL,\n`familia` TINYINT DEFAULT NULL,\nPRIMARY KEY(`id`)\n)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a trabajar con MySQL Workbench, el cual permite crear tablas de dos maneras, o bien mediante un script o bien mediante una de las opciones que permite Workbench. Creaci\u00f3n mediante las opciones de Workbench La ruta a seguir es: Schemas &gt; base de datos a elegir &gt; Tables &gt; Create Table Luego hay que [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4518,"menu_order":35,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-5302","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":"Vamos a trabajar con MySQL Workbench, el cual permite crear tablas de dos maneras, o bien mediante un script o bien mediante una de las opciones que permite Workbench. Creaci\u00f3n mediante las opciones de Workbench La ruta a seguir es: Schemas &gt; base de datos a elegir &gt; Tables &gt; Create Table Luego hay que&hellip;","_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=5302"}],"version-history":[{"count":4,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5302\/revisions"}],"predecessor-version":[{"id":5306,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/5302\/revisions\/5306"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/4518"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=5302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}