sql 级联删除

create table a(
id int primary key,
name varchar(20) not null
);
create table b(
id int primary key,
name varchar(20) not null
);
create table c(
id int primary key,
aid int not null,
bid int not null,
constraint fka foreign key (aid) references a (id) on delete cascade,
constraint fkb foreign key (bid) references b (id) on delete cascade
);

insert into a values(1,'aaa');
insert into a values(2,'aaa');
insert into a values(3,'aaa');
insert into a values(4,'aaa');
insert into a values(5,'aaa');

insert into b values(1,'aaa');
insert into b values(2,'aaa');
insert into b values(3,'aaa');
insert into b values(4,'aaa');
insert into b values(5,'aaa');

 

insert into c values(1,1,1);
insert into c values(2,1,2);
insert into c values(3,1,3);
insert into c values(4,1,4);
insert into c values(5,1,5);

insert into c values(6,2,1);
insert into c values(7,2,2);
insert into c values(8,3,4);
insert into c values(9,4,1);
insert into c values(10,1,5);

insert into c values(11,5,5);
insert into c values(12,5,3);
insert into c values(13,2,5);
insert into c values(14,2,4);
insert into c values(15,3,3);

insert into c values(16,4,1);
insert into c values(17,4,1);
insert into c values(18,1,4);
insert into c values(19,1,4);
insert into c values(20,1,1);

 

c表中有两个外键，当主表删除某一记录时，比如a表删除id=1的记录时（delete from a where id=1），c表对应aid=1的记录也会被删除