MySQL 给数据排序同时追加序号列

无分组select @rownum:=@rownum+1 as autoSeq,sid,pid,oprimary,seqfrom singlechoice,(select @rownum:=0) rorder by pid,sid单字段分组select (@i := case when @tableName=a.tablename then @i + 1 else 1 end ) as rowIndex,a.,(@tableName:=a.tablename)from tablestyle a,(select @i:=0,@tableName:=’’) as tgroup by tablename,fieldnameorder by tablename,(@i := case when @tableName=a.tablename then @i + 1 else 1 end )多字段分组select (@i := case when @tableName=concat(a.dbname,a.tablename) then @i + 1 else 1 end ) as rowIndex,a.,(@tableName:=concat(a.dbname,a.tablename)) as tempfrom tablestyle a,(select @i:=0,@tableName:=’’) as tgroup by dbname,tablename,fieldnameorder by dbname,tablename,(@i := case when @tableName=concat(a.dbname,a.tablename) then @i + 1 else 1 end )