create trigger t1
after
insert
on ord
for each row
begin
update goods xxxxx
end;
create table goods(
gid int,
name varchar(20),
num smallint
);
create table ord(
oid int,
gid int,
much smallint
);
insert into goods values
(1,"cat",34),
(2,"dog",65),
(3,'pig',21);
delemiter $
create trigger t1
after
insert
on ord
for each row
begin
update goods set num=num-2 where gid=1;
end$
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。