level 1
mjp540607315
楼主
Rt
CREATE DEFINER=`root`@`localhost` trigger trigger_price
after insert
on purchases for each row
update purchases inner join products on purchases.pid=products.pid set purchases.total_price=purchases.qty*products.original_price*(1-products.discnt_rate)
2017年12月18日 16点12分
1
CREATE DEFINER=`root`@`localhost` trigger trigger_price
after insert
on purchases for each row
update purchases inner join products on purchases.pid=products.pid set purchases.total_price=purchases.qty*products.original_price*(1-products.discnt_rate)