mysql 之排序显示行号

select @r := @r+1 as rownum,birth,cardNo from card,(select @r:=0)torder by birth ASC