できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
演算子 | 意味 |
---|---|
AND , && |
いずれも真 |
OR , || |
いずれかが真 |
NOT , ! |
否定 |
SELECT Name, Population FROM city
WHERE CountryCode = 'JPN'
AND Population > 2000000;
MariaDB [world]> SELECT Name, Population FROM city WHERE CountryCode = 'JPN' AND Population > 2000000;
+---------------------+------------+
| Name | Population |
+---------------------+------------+
| Tokyo | 7980230 |
| Jokohama [Yokohama] | 3339594 |
| Osaka | 2595674 |
| Nagoya | 2154376 |
+---------------------+------------+
4 rows in set (0.00 sec)
SELECT Name, Population FROM city
WHERE Not Population <= 90000000;
MariaDB [world]> SELECT Name, Population FROM city WHERE Not 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)