SELECT `value`
INTO bonus
FROM ssc_params
WHERE name = 'scoreProp'
LIMIT 1 ;
SET bonus = bonus * _amount;
IF bonus THEN UPDATE ssc_members u,
ssc_params p SET u.score = u.score + bonus,
u.scoreTotal = u.scoreTotal + bonus WHERE u.`uid` = _uid;
END IF ;
end$$
MySQL 返回: 文档
#1227 - Access denied; you need the SUPER privilege for this operation 作者: zening888 时间: 2016-7-7 08:18
为什么用户名和密码不对作者: 折腾侠 时间: 2016-7-14 12:35
admin进不了作者: wwf8713653 时间: 2016-7-28 11:13