关于hibernate中占位符和mysql中:=的问题SQL语句如下.实现排名,并将排名赋值到rank列表中.setsqlsafeupdates=0;set@num=0;updateusera,(select@num:=@num+1rank,idfromuserorderbysolvedesc,acdesc,allSubmit)bseta.r

Question

关于hibernate中占位符和mysql中:=的问题 SQL语句如下.实现排名,并将排名赋值到rank列表中.
set sql_safe_updates=0;
set @num =0;
update user a,
(
select @num:=@num+1 rank,id
from user order by solve desc ,ac desc ,allSubmit
) b
set a.rank=b.rank
where a.id=b.id;
在workbench中执行无误.
但使用hibernate的时候出现

Space is not allowed after parameter prefix ':'
求助.

Answer 1

=:
查询的命名参数
~~~~~~~~~~~~