MySQL RESTRICT 和无操作

2022-01-20 00:00:00 foreign-keys mysql cascade

RESTRICTNO ACTION 在 MySQL FK 中有什么区别?从文档来看,它们似乎完全相同.是这样吗?如果有,为什么两者都有?

What's the difference in a MySQL FK between RESTRICT and NO ACTION? From the doc they seem exactly the same. Is this the case? If so, why have both?

推荐答案

来自 MySQL 文档:https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html

From MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html

某些数据库系统已延迟检查,并且 NO ACTION 是延迟的查看.在 MySQL 中,外键立即检查约束,所以 NO ACTIONRESTRICT 是一样的.

Some database systems have deferred checks, and NO ACTION is a deferred check. In MySQL, foreign key constraints are checked immediately, so NO ACTION is the same as RESTRICT.

相关文章