‘JPA Space is not allowed after parameter prefix ‘‘:‘‘‘

查询时候想根据分数排序并且添加对应的名词序号,所以mysql语句中出现了(@i:=@i+1),在navicat下可以正常的运行.但是在使用@Query时出现’JPA Space is not allowed after parameter prefix ‘’:’’'错误;

@Query注解如下:

    @Query(value = "select (@i:=@i+1)pm from record s,(select @i:=0)t  order by score desc;",nativeQuery = true)

去查资料,解决方案是把:转义 变成//:

@Query(value = "select (@i\\:=@i+1)pm from record s,(select @i\\:=0)t  order by score desc;",nativeQuery = true)