Dondariadmin (トーク | 投稿記録) (ページの作成: == 環境 == *DBMS = MySQL 5ぐらい == FOUND_ROWS == *最後にSELECTした行数を取得するFOUND_ROWS()。 *ページングする場合など、分母が欲しい場...) |
Dondariadmin (トーク | 投稿記録) |
||
40行目: | 40行目: | ||
+--------------+ | +--------------+ | ||
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
+ | |||
+ | [[Category:SQL]] |
mysql> SELECT * FROM tbl_name LIMIT 10; ----------------------------- 10 rows in set (0.00 sec) mysql> SELECT FOUND_ROWS(); +--------------+ | FOUND_ROWS() | +--------------+ | 10 | +--------------+ 1 row in set (0.00 sec)
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name LIMIT 10; ----------------------------- 10 rows in set (0.00 sec) mysql> SELECT FOUND_ROWS(); +--------------+ | FOUND_ROWS() | +--------------+ | 42 | +--------------+ 1 row in set (0.00 sec)Tweet