enlazar tablas

[gnzsoloyo]

Algo así si quieres hacerlo mientras creas las tables:

Código MySQL:

CREATE TABLE  `categoria` (
  `id_cat` int(10) unsigned NOT NULL auto_increment,
  `cat_nombre` varchar(50) NOT NULL,
  `cat_descripcion` longtext NOT NULL,
  `cat_img` longtext NOT NULL,
  PRIMARY KEY  (`id_cat`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
CREATE TABLE  `subcategoria` (
  `id_sub` int(10) unsigned NOT NULL auto_increment,
  `subcat_nombre` varchar(50) NOT NULL,
  `subcat_descripcion` longtext NOT NULL,
  `id_cat` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id_sub`),
  KEY `categoria` USING BTREE (`id_cat`),
  CONSTRAINT `FK_subcategoria_cat` FOREIGN KEY (`id_cat`) REFERENCES `categoria` (`id_cat`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
CREATE TABLE  `producto` (
  `id_prod` int(10) unsigned NOT NULL auto_increment,
  `nombre_prod` varchar(100) NOT NULL,
  `descripcion_prod` longtext NOT NULL,
  `img_prod` longtext NOT NULL,
  `id_cat` int(10) unsigned NOT NULL,
  `id_sub` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id_prod`),
  KEY `categoria` USING BTREE (`id_cat`),
  KEY `subcategoria` USING BTREE (`id_sub`),
  CONSTRAINT `FK_producto_subcat` FOREIGN KEY (`id_sub`) REFERENCES `subcategoria` (`id_sub`)  ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_producto_cat` FOREIGN KEY (`id_cat`) REFERENCES `categoria` (`id_cat`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;