表结构如下
create table houses
(
houses_id int(10) not null auto_increment,
goods_id varchar(36),
goods_type varchar(10),
goods_name varchar(20),
goods_amount int,
sh_id varchar(10),
goods_sel_price decimal(12,2),
house_goods_price decimal(12,2),
primary key (houses_id)
);
①求计算 house_goods_price(金额) = goods_sel_price(单价) 乘 goods_amount(数量)
②当数量goods_amount字段发生改变时候 更新 house_goods_price值
求简单做法。