我有一个查询行号的sql
SELECT * from (Select id,(@rowNum:=@rowNum+1) as rowNo From spread_source, (Select (@rowNum :=0) ) b order by id asc) as a
但是执行的时候被转义成了
SELECT * from (Select id,(?:=?+1) as rowNo From spread_source, (Select (? :=0) ) b order by id asc) as a
请问这该怎么处理呢
sql类没有这个方法啊
Sql sql = Sqls.create("SELECT * from (Select id,(@rowNum:=@rowNum+1) as rowNo From spread_source, (Select (@rowNum :=0) ) b order by id asc) as a " +
"where mod(a.rowNo, 100) = 0 AND (a.source = '0014' OR a.source = '999999' OR a.source = '888888') ORDER BY a.rowNo DESC LIMIT 1");
sql.setCallback(Sqls.callback.records());
dao.execute(sql);
List<Record> list = sql.getList(Record.class);