mysql能有alter设置外键吗_mysql外键设置

最新推荐文章于 2023-04-06 00:01:31 发布

妞妞脾气灰常大

最新推荐文章于 2023-04-06 00:01:31 发布

阅读量467

点赞数

本文链接：https://blog.csdn.net/weixin_27015733/article/details/113464098

版权

数据库设计表关系外键约束级联操作数据完整性

关键词由CSDN通过智能技术生成

CREATE TABLE person ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) )type=innoDB; CREATE TABLE shirt ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, style ENUM('t-shirt', 'polo', 'dress') NOT NULL, color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL, owner SMALLINT UNSIGNED NOT NULL, FOREIGN KEY (owner) REFERENCES PERSON(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) )type=innoDB; CREATE TABLE person ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) )type=innoDB; CREATE TABLE shirt ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, style ENUM('t-shirt', 'polo', 'dress') NOT NULL, color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL, owner SMALLINT UNSIGNED NOT NULL, FOREIGN KEY (owner) REFERENCES PERSON(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) )type=innoDB;