给mybatis mysql 查询结果添加序号

一、需求

使用 mybatis 从 mysql 数据库中查询数据，并给查询结果添加自增的序号。

二、实现

SELECT
    @i:= @i+ 1 AS row,
    u.create_time
FROM
    user u,
    ( SELECT @i:= 0 ) r

实际应用代码如下：

<sql id="selectDataPeriodInspectContentAll">
        select @i:= @i+ 1 AS rows,
            data_period_inspect_content.id, inspect_method, plan_inspect_date, inspector, data_period_inspect_content.rmk,public_id,factory_num, user_department,storage_site, apparatus_name, apparatus_model,
            data_period_inspect_public.year,write_Date,writer,approve_Date,approver
        from data_period_inspect_content LEFT JOIN data_apparatus ON data_period_inspect_content.apparatus_id = data_apparatus.id
                                         LEFT JOIN data_period_inspect_public ON data_period_inspect_content.public_id = data_period_inspect_public.id,
            ( SELECT @i:= 0 ) r
    </sql>

查询结果：

参考链接：
https://blog.youkuaiyun.com/libusi001/article/details/96974622