mybatis报错while setting parameters

Question

set @ID=0;
SELECT num from (SELECT *,@ID:= @ID+1 as num from user ORDER BY userid ) a where userid = #{userid}

在查询某一个结果所在的行数时，报错The error occurred while setting parameters

参数就只有一个userid

Answer 1

你的接口参数写对了吗