select (@i:=@i+1) i_index,user_name from user, (select @i:=0) as i;
MYSQL 查询结果加上自增序号
最新推荐文章于 2024-06-18 16:14:45 发布
select (@i:=@i+1) i_index,user_name from user, (select @i:=0) as i;