方式1
SELECT (@k :=@k + 1) count,u.* FROM sys_user u,(SELECT @k := 0) c
方式2(不支持项目中执行--测试框架springboot)
set @k=0;
SELECT
(@k :=@k + 1) count,u.*
FROM sys_user u
SELECT (@k :=@k + 1) count,u.* FROM sys_user u,(SELECT @k := 0) c
set @k=0;
SELECT
(@k :=@k + 1) count,u.*
FROM sys_user u