删除级联 [英] ON DELETE CASCADE

问题描述

ALTER TABLE `phppos_items_taxes`
ADD CONSTRAINT `phppos_items_taxes_ibfk_1` 
FOREIGN KEY (`item_id`) 
REFERENCES `phppos_items` (`item_id`) 
ON DELETE CASCADE;

这是否意味着删除phppos_items.id时，它将是phppos_items_taxes上的删除条目?

Does this mean when phppos_items.id is deleted, it will be delete entries on phppos_items_taxes?

我很难解释它.

推荐答案

是的，但是您确实需要从物理上删除该条目.有时最好在根实体中设置某种标志，该标志会告诉它是否应充当已删除/过滤的角色

yes, but do you really need to physically delete that entry. Sometimes it is better to set some kind of flag in root entity which will tell if it should act as deleted/filtered

这篇关于删除级联的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！