现在有这样的一个数据库查询语句,我在Navicat里可以查询,但放到Yii2的框架已就报错,求高手指点,谢谢~
SET @ranking = 0; SELECT * FROM ( SELECT *, @ranking :=@ranking + 1 AS ranking FROM user_match WHERE user_id != '' ORDER BY CONVERT ( user_match.player_score, SIGNED ) DESC ) AS result WHERE result.player_score = 365 LIMIT 1
Database Exception – yii\db\Exception
SQLSTATE[HY000]: General error
The SQL being executed was: SET @ranking = 0;SELECT * FROM (SELECT *, @ranking :=@ranking + 1 AS ranking FROM user_match WHERE user_id != '' ORDER BY CONVERT(user_match.player_score, SIGNED) DESC) AS result WHERE result.player_score=365 LIMIT 1;
Error Info: Array
(
[0] => HY000
)
↵
Caused by: PDOException
SQLSTATE[HY000]: General error
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
PDO因为安全的原因,不支持一次发送执行两句sql,
你的SET@ranking=0;已经有个分号了