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

SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b
posted @ 2018-04-16 11:30  Bob.Xie  阅读(605)  评论(0)    收藏  举报