できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
演算子 | 意味 |
---|---|
= |
等しい |
<> , != |
等しくない |
>= , <= |
以上,以下 |
> , < |
より大きい,より小さい |
()
を利用する。TRUE
,FALSE
,NULL
で返される。world
を使用USE world;
MariaDB [world]> use world
Database changed
SELECT Name FROM country
WHERE Region = 'Eastern Asia';
MariaDB [world]> SELECT Name FROM country WHERE Region = 'Eastern Asia';
+-------------+
| Name |
+-------------+
| China |
| Hong Kong |
| Japan |
| South Korea |
| Macao |
| Mongolia |
| North Korea |
| Taiwan |
+-------------+
8 rows in set (0.00 sec)
SELECT Name FROM country
WHERE Population = 0;
MariaDB [world]> SELECT Name FROM country WHERE Population = 0;
+----------------------------------------------+
| Name |
+----------------------------------------------+
| Antarctica |
| French Southern territories |
| Bouvet Island |
| Heard Island and McDonald Islands |
| British Indian Ocean Territory |
| South Georgia and the South Sandwich Islands |
| United States Minor Outlying Islands |
+----------------------------------------------+
7 rows in set (0.01 sec)
SELECT Name, Population FROM city
WHERE Population > 9000000;
MariaDB [world]> SELECT Name, Population FROM city WHERE Population > 9000000;
+-----------------+------------+
| Name | Population |
+-----------------+------------+
| S?o Paulo | 9968485 |
| Jakarta | 9604900 |
| Mumbai (Bombay) | 10500000 |
| Shanghai | 9696300 |
| Seoul | 9981619 |
| Karachi | 9269265 |
+-----------------+------------+
6 rows in set (0.01 sec)
SELECT * FROM city WHERE Name = 'Hamamatsu';
MariaDB [world]> SELECT * FROM city WHERE Name = 'Hamamatsu';
+------+-----------+-------------+----------+------------+
| ID | Name | CountryCode | District | Population |
+------+-----------+-------------+----------+------------+
| 1549 | Hamamatsu | JPN | Shizuoka | 568796 |
+------+-----------+-------------+----------+------------+
1 row in set (0.01 sec)
SELECT * FROM city WHERE District = 'Mie';
MariaDB [world]> SELECT * FROM city WHERE District = 'Mie';
+------+-----------+-------------+----------+------------+
| ID | Name | CountryCode | District | Population |
+------+-----------+-------------+----------+------------+
| 1601 | Yokkaichi | JPN | Mie | 288173 |
| 1645 | Suzuka | JPN | Mie | 184061 |
| 1660 | Tsu | JPN | Mie | 164543 |
| 1708 | Matsusaka | JPN | Mie | 123582 |
| 1744 | Kuwana | JPN | Mie | 106121 |
| 1751 | Ise | JPN | Mie | 101732 |
+------+-----------+-------------+----------+------------+
6 rows in set (0.01 sec)