MySQL查询某个记录行号
来源：懂视网
责编：小采
时间：2020-11-09 09:17:34
MySQL查询某个记录行号
MySQL查询某个记录行号:mysql>SELECT count(*) FROM test where id <= (SELECT id FROM test where id=16); +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec)
导读MySQL查询某个记录行号:mysql>SELECT count(*) FROM test where id <= (SELECT id FROM test where id=16); +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec)
mysql>SELECT count(*) FROM test where id <= (SELECT id FROM test where id=16);
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
MySQL查询某个记录行号
MySQL查询某个记录行号:mysql>SELECT count(*) FROM test where id <= (SELECT id FROM test where id=16); +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec)
