mysql中的cascade级联,setnull,restrict限制都是什么意思,有何差别.zip

[{"title":"（6个子文件4KB）mysql中的cascade级联,setnull,restrict限制都是什么意思,有何区别.zip","children":[{"title":"cascade级联在父表上更新删除记录时，同步掉子表的匹配记录.txt <span style='color:#111;'>0B</span>","children":null,"spread":false},{"title":"setnull在父表上更新删除记录时，将子表上匹配记录的列设为null.txt <span style='color:#111;'>0B</span>","children":null,"spread":false},{"title":"Restrict同Noaction一样如果子表中有匹配的记录则不允许对父表匹配字段进行更新删除操作.txt <span style='color:#111;'>0B</span>","children":null,"spread":false},{"title":"mysql级联删除-----Mysql的CascadeRestrict.txt <span style='color:#111;'>1.88KB</span>","children":null,"spread":false},{"title":"级联(cascade)改删子表不会解发trigger.txt <span style='color:#111;'>0B</span>","children":null,"spread":false},{"title":"每当从主表中删除一个主键id时，由于与他相关联的表中有相关的字段数据，所以无法删除.txt <span style='color:#111;'>0B</span>","children":null,"spread":false}],"spread":true}]