外鍵測試

 primary key (par_id,child_id),
 foreign key (par_id) references parent (par_id) on delete cascade
) type = innodb;

# creat table end

# insert strat

insert into parent (par_id) values (1),(2),(3);
insert into child (par_id,child_id) values (1,1),(1,2);
insert into child (par_id,child_id) values (2,1),(2,2),(2,3);
insert into child (par_id,child_id) values (3,1);

# insert end

文章來源于領測軟件測試網 http://www.kjueaiud.com/