mysql学习记录（一）

最新推荐文章于 2022-05-01 22:21:34 发布

代码痴汉

最新推荐文章于 2022-05-01 22:21:34 发布

阅读量275

点赞数

分类专栏：数据库文章标签： mysql 数据库数据库建模

本文链接：https://blog.csdn.net/lieyanhaipo/article/details/52088185

版权

数据库专栏收录该内容

16 篇文章 0 订阅

订阅专栏

使用mysqlworkbench数据库建模生成的数据库，其中外键显示：
**ON DELETE NO ACTION
ON UPDATE NO ACTION**
Oracle allows three different definitions under the definition of the foreign key:

ON DELETE CASCADE (when a referenced parent table row is removed all the child are removed automatically)

The ON DELETE SET NULL action allows data that references the parent key to be deleted, but not updated. When referenced data in the parent key is deleted, all rows in the child table that depend on those parent key values have their foreign keys set to null.

ON DELETE NO ACTION (which is the default) prevents deleting a parent when there are children (would be nice arrangement for real life)