当前位置:Gxlcms > mysql > MySQL查询某个记录行号

MySQL查询某个记录行号

时间:2021-07-01 10:21:17 帮助过:51人阅读

mysql>SELECT count(*)  FROM test  where id <= (SELECT id FROM test  where id=16); 
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)

人气教程排行