好记性不如烂笔头。

mysql查询中自增列

SELECT a.user, @i:=@i+1 as id FROM user a,(SELECT @i:=0) b;