一句话实现Mysql查询结果带行号

SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b
原文地址:https://www.cnblogs.com/BobXie85/p/8855037.html