mysql返回自动生成序号

mysql返回自动生成序号

<select id="getPageData" parameterType="java.util.Map" resultMap="BaseResultMap2">
    SELECT
    @rownum :=@rownum + 1 AS ID,
    SUB1.*
    FROM
    (
    select
    <include refid="Base_Column_List2"/>
    FROM
    qzq_ljqlx t1
    LEFT OUTER JOIN
    s_user t2
    ON
    t1.create_uid = t2.user_id AND
    t2.del_flag = 0
    WHERE
    t1.del_flag = 0
    AND
    (t1.ljqlx_name LIKE '%${ljqlxName}%' OR t1.`LJQLX_CONTENT` LIKE '%${ljqlxContent}%')
    limit #{beginIndex},#{pageSize}
    ) SUB1,
    (SELECT @rownum := 0) r
</select>