mysql创建触发器是修改一个表的字段时另外一个表的字段值也跟着改变

create TRIGGER tb before insert on product for each ROWBEGIN set new.subprice = new.nums*new.price;end;