mysql触发器中包含select语句

在mysql的触发器中,如果直接写select * from d_shop_ware 会报错

Not allowed to return a result set from a trigger

查找原因是：MYSQL5以后，不允许触发器返回任何结果，因此使用into @变量名，将结果赋值到变量中，用select调用即可

如下sql语句,@flag_price_copy就可以进行值的判断

select b.flag_price into @flag_price_copy from `dst_111yao_doms`.`d_shop_ware` as a,`dst_111yao_doms`.`d_platform` as b where a.pfid = b.pfid and a.olshopid = NEW.olshopid and a.tfid = NEW.pfid and a.warecode = NEW.outter_id and a.skuid = NEW.sku;

if @flag_price_copy = '1' then...