set @my_int = 1;
select
@my_int := @my_int + 1 as rownum,e.*
from
aoteman e;
select
@rownum := @rownum + 1 as rownum,
e.*
from (
select @rownum := 0) r,
aoteman e;
- 版权声明：本站原创文章，于2周前，由admin发表，共 131字。
- 转载请注明：给mysql结果集加编号 | 老鄢博客 +复制链接
set @my_int = 1;
select
@my_int := @my_int + 1 as rownum,e.*
from
aoteman e;
select
@rownum := @rownum + 1 as rownum,
e.*
from (
select @rownum := 0) r,
aoteman e;
