SELECT `Name`,(@rowNum:=@rowNum+1) AS rowNo FROM bas_student,(SELECT (@rowNum :=0)) a LIMIT 10;
Mysql显示行号
原文：http://www.cnblogs.com/xbblogs/p/5633935.html
