求解如下报错:Space is not allowed after parameter prefix ':'

[z_juny]

Space is not allowed after parameter prefix ':' [SELECT @rownum\:=@rownum+1 AS rownum, a.* FROM (SELECT @rownum\:=0) r, (select u.* from sys_user u order by rand()) a where @rownum < ?]

我的sql是
String sql = "SELECT @rownum\\:=@rownum+1 AS rownum, a.* "
+ " FROM (SELECT @rownum\\:=0) r, (select u.* from user u order by rand()) "
+ " a where @rownum < 10";

目的是将user表先随机排序,然后通过伪列取出前10个数据.占位符已转义,框架用的是ssh,但还是报占位符后不能有空格.哪位大神能帮忙看看!拜谢!

[z_juny]

没人遇到过这样的问题吗?自己顶下大神,你在哪里?

[张家强 全栈]

/'/:=/'/