MySQL5.6 触发器的使用(条件分支、变量的使用)
create trigger check_record_delete_trigger after DELETE
on check_record FOR EACH ROW
begin
set @count = (select count(*) from check_record where INSTRUMENT_ID = old.INSTRUMENT_ID);
if @count = 0 the
转载
2015-03-02 10:01:19 ·
1103 阅读 ·
0 评论