mySQL RESTRICT和NO ACTION [英] mySQL RESTRICT and NO ACTION
本文介绍了mySQL RESTRICT和NO ACTION的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
RESTRICT和NO 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文档: http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints .html
某些数据库系统有延期的
支票,NO ACTION是延期的
支票。在MySQL中,立即检查外键
约束,
,所以NO ACTION和RESTRICT是一样的。
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.
这篇关于mySQL RESTRICT和NO ACTION的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文