Mysql显示行号

SELECT `Name`,(@rowNum:=@rowNum+1) AS rowNo FROM bas_student,(SELECT (@rowNum :=0)) a LIMIT 10;

 

posted @ 2016-07-01 17:50  .追风逐月  阅读(897)  评论(0)    收藏  举报