数据库

MySql查询新增顺序索引

云博小周宇1 Min Read

Sql如下:

SELECT
    ( @id := @id + 1 ) AS id,   
    t.* 
FROM
    sys_user t,
    ( SELECT @id := 0 ) AS id_temp

如果要分页,请把@id的初始值设置为动态传入即可