事务或者触发器级联删除
这里我有两张表,一张是cat_tb表(大类别表),另一张是小类别表(subCat_tb)
我想修改\删除\大类别表cat_tb的时候,小类别表也随着改变
create table cat_tb(
cat_id int primary key,
cat_name varchar(20)
)
select * from cat_tb
insert into cat_tb(cat_id,cat_name) values(2001,'电子产品')
insert into cat_tb values(2000,'美容产品')
create table subCat_tb(
subCat_id int primary key,
subCat_name varchar(20),
cat_id int foreign key(cat_id) references cat_tb
)
select * from subCat_tb
insert into subCat_tb(subCat_id,subCat_name,cat_id) values(200,'电脑',2001)
insert into subCat_tb(subCat_id,subCat_name,cat_id) values(201,'美容护理水',2000)