56,687
社区成员
发帖
与我相关
我的任务
分享
MariaDB [demo]> select * from t_demo;
+------------+------------+
| id | name |
+------------+------------+
| 3 | 1234567890 |
| 1 | a2 |
| 2 | b2 |
| 98765432 | t |
| 2147483647 | t |
+------------+------------+
5 rows in set (0.48 sec)
MariaDB [demo]> select * from t_demo limit 2;
+----+------------+
| id | name |
+----+------------+
| 3 | 1234567890 |
| 1 | a2 |
+----+------------+
2 rows in set (0.01 sec)
MariaDB [demo]> select SQL_CALC_FOUND_ROWS * from t_demo limit 2;
+----+------------+
| id | name |
+----+------------+
| 3 | 1234567890 |
| 1 | a2 |
+----+------------+
2 rows in set (0.03 sec)
MariaDB [demo]> select FOUND_ROWS();
+--------------+
| FOUND_ROWS() |
+--------------+
| 5 |
+--------------+
1 row in set (0.05 sec)