mysql 添加外键

最新推荐文章于 2025-04-12 00:55:13 发布

wang603603

最新推荐文章于 2025-04-12 00:55:13 发布

阅读量305

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/wang603603/article/details/78218472

版权

CREATE TABLE `ws_name` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8


//-----------------------------------------------------------------
//创建表时，添加外键
CREATE TABLE `ws_3` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_wsname_ws3` (`name`),
  CONSTRAINT `fk_wsname_ws3` FOREIGN KEY (`name`) REFERENCES `ws_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8


 //创建表之后， 添加外键
 alter table ws_3 add CONSTRAINT fk_wsname_ws3 FOREIGN KEY (name)  REFERENCES ws_name(name)