SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b
一句话实现Mysql查询结果带行号
原文：https://www.cnblogs.com/BobXie85/p/8855037.html
