SELECT (@i:=@i+1) i,id,p_name FROM province,(SELECT @i:=0) AS it WHERE id BETWEEN 2 AND 5
mysql查询出来的集合生成序号
最新推荐文章于 2024-06-13 08:50:37 发布
SELECT (@i:=@i+1) i,id,p_name FROM province,(SELECT @i:=0) AS it WHERE id BETWEEN 2 AND 5