select @rownum:=@rownum+1 as rownum, b.* from (select @rownum:=0) a, b b表是数据表 转载于:https://www.cnblogs.com/vijayfly/p/6899330.html