mysql 存储过程中sum 结果赋值给变量的坑
时间:2022-03-14 13:17
CREATE PROCEDURE `hejin`.`pro_redeem_check`(IN gpid int) BEGIN SLELECT SUM(amount) INTO @money FROM assets WHERE gpid = gpid; SLELECT @money; END
一直是所有的总和而不是gpid的总和。mysql居然不支持这个聚合筛选。
时间:2022-03-14 13:17
CREATE PROCEDURE `hejin`.`pro_redeem_check`(IN gpid int) BEGIN SLELECT SUM(amount) INTO @money FROM assets WHERE gpid = gpid; SLELECT @money; END
一直是所有的总和而不是gpid的总和。mysql居然不支持这个聚合筛选。