56,682
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$;
DROP TRIGGER `my_test`.`cfsgb1`$$
create trigger `cfsgb1` AFTER INSERT on `sgb`
for each row BEGIN
set @a=new.bh;
set @d=new.name;
set @jinjzh=new.jinjia*new.sl;
set @maijzh=new.mj*new.sl;
if @d<>'' then
insert into sgb1(bh,name,jinjzongh,maijzongh)
values(@a,@d,@jinjzh,@maijzh);
end if;
if new.name='' then
delete from sgb where bh=new.bh;
end if;
END;
$$
DELIMITER ;$$
insert into sgb(name,mj,jinjia,sl)
values('',10,10,10);
if new.name='' then
delete from sgb where bh=new.bh;
end if;