できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
LIMIT
句LIMIT
句とWHERE
句を同時に指定した場合,WHERE
句が優先される。LIMIT 件数
LIMIT 開始行, 件数
SELECT * FROM city
WHERE CountryCode = 'JPN'
LIMIT 5;
MariaDB [world]> SELECT * FROM city WHERE CountryCode = 'JPN' LIMIT 5;
+------+---------------------+-------------+----------+------------+
| ID | Name | CountryCode | District | Population |
+------+---------------------+-------------+----------+------------+
| 1532 | Tokyo | JPN | Tokyo-to | 7980230 |
| 1533 | Jokohama [Yokohama] | JPN | Kanagawa | 3339594 |
| 1534 | Osaka | JPN | Osaka | 2595674 |
| 1535 | Nagoya | JPN | Aichi | 2154376 |
| 1536 | Sapporo | JPN | Hokkaido | 1790886 |
+------+---------------------+-------------+----------+------------+
5 rows in set (0.00 sec)
SELECT * FROM City
WHERE CountryCode = 'JPN'
LIMIT 5, 5;
MariaDB [world]> SELECT * FROM City WHERE CountryCode = 'JPN' LIMIT 5, 5;
+------+-----------+-------------+-----------+------------+
| ID | Name | CountryCode | District | Population |
+------+-----------+-------------+-----------+------------+
| 1537 | Kioto | JPN | Kyoto | 1461974 |
| 1538 | Kobe | JPN | Hyogo | 1425139 |
| 1539 | Fukuoka | JPN | Fukuoka | 1308379 |
| 1540 | Kawasaki | JPN | Kanagawa | 1217359 |
| 1541 | Hiroshima | JPN | Hiroshima | 1119117 |
+------+-----------+-------------+-----------+------------+
5 rows in set (0.00 sec)