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