SELECT @ROWNO := @ROWNO + 1 AS no, T.*
FROM (SELECT* FROM view_monitor_info) T,
(SELECT @ROWNO := 0) T3
ORDER BY no
mysql 显示行号
最新推荐文章于 2024-03-25 14:30:54 发布
SELECT @ROWNO := @ROWNO + 1 AS no, T.*
FROM (SELECT* FROM view_monitor_info) T,
(SELECT @ROWNO := 0) T3
ORDER BY no