1.用两个语句来实现
set @rownum=0;
SELECT @rownum:=@rownum+1 AS rownum , id FROM table;
2.用一个sql语句来实现
SELECT @rownum:=@rownum+1 AS rownum, table_name.* FROM (SELECT @rownum:=0) r, table_name ;
MySql伪自增列
最新推荐文章于 2023-06-29 17:18:40 发布
1.用两个语句来实现
set @rownum=0;
SELECT @rownum:=@rownum+1 AS rownum , id FROM table;
2.用一个sql语句来实现
SELECT @rownum:=@rownum+1 AS rownum, table_name.* FROM (SELECT @rownum:=0) r, table_name ;