mysql排序后返回序号
mysql中排序后根据排序的内容显示序号，需要在子查询中select @rownum:=0，只有外层的@rownum并不会起作用。select a.num, a.content, t.tagname, @rownum:=@rownum+1 as sortorder from (select count(*) as num, content, @rownum:=0 from action ...
