避免误解 ON DELETE NO ACTION
原文英文,约300词,阅读约需1分钟。发表于: 。Relational databases often provide several options for handling actions when a referenced row in a foreign key relationship is deleted. Among these options, ON DELETE NO ACTION can be a bit...
关系数据库中的外键删除选项包括:CASCADE 自动删除子行,SET NULL 将子行外键设为 NULL,RESTRICT 立即阻止删除有子行的父行,NO ACTION 在事务结束时阻止删除,允许在事务中解决问题后继续删除。