SELECT (@rowNO := @rowNO+1) AS rownum, table1.column1 FROM table1 , (SELECT @rowNO :=0) b
SQL查询添加序号
最新推荐文章于 2024-05-05 11:01:29 发布
SELECT (@rowNO := @rowNO+1) AS rownum, table1.column1 FROM table1 , (SELECT @rowNO :=0) b