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
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