create table organization( o_no int not null auto_increment, o_name varchar(32) default '', primary key (o_no) ) engine=innodb; create table member( m_no int not null auto_increment, m_name varchar(32) default '', o_no int, primary key (m_no), constraint organization_member_fk foreign key (o_no) references organization(o_no) ) engine=innodb; insert into organization(o_no, o_name) values (null, 'o1'), (null, 'o2'); insert into member(m_no,m_name,o_no) values (null, 'm1',1), (null, 'm2',1), (null, 'm3',1), (null, 'm4',2), (null, 'm5',2); delimiter $$ create trigger organization_delete_before_trigger before delete on organization for each row begin delete from member where o_no=old.o_no; end; $$ delimiter ; select * from member; delete from organization where o_no=1; select * from member;
mysql 触发器
最新推荐文章于 2024-08-22 21:30:00 发布