Mysql 表一条记录按某一字段排序的排序号是多少

set @id:=0;
select (@id:=@id+1) as sortid,e.* from es_member e