MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT VERSION();


VERSION()


8.0.17


DROP TABLE IF EXISTS `categoria`, `productos`;
CREATE TABLE IF NOT EXISTS `productos` (
  `id_producto` SERIAL
);
CREATE TABLE IF NOT EXISTS `categoria` (
  `id_categoria` SERIAL
);
ALTER TABLE `productos`
  ADD CONSTRAINT `fk_procat` FOREIGN KEY (`id_producto`)
  REFERENCES `categoria` (`id_categoria`) ON UPDATE CASCADE ON DELETE CASCADE;
SHOW CREATE TABLE `productos`;


Table
Create Table


productos
CREATE TABLE `productos` (
  `id_producto` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id_producto` (`id_producto`),
  CONSTRAINT `fk_procat` FOREIGN KEY (`id_producto`) REFERENCES `categoria` (`id_categoria`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci