//a.用两个语句来实现
set @rownum=0;
SELECT @rownum:=@rownum+1 AS rownum , id FROM table;
//b.用一个sql语句来实现
SELECT @rownum:=@rownum+1 AS rownum, table_name.* FROM (SELECT @rownum:=0) r, table_name ;
//把rownum的设置初值放到了from 和需要查询的表的前面
//使用命令将mysql中某表的某列实现自增:
set @n=0;
update test set a=@n:=@n+1;