mysql 显示行号

mysql 显示行号

SELECT (@rowNum := @rowNum + 1) AS "rowNum", u.* FROM `user` u,  ( SELECT @rowNum := 0 ) r;