[できるPRO MySQL できるPROシリーズ Kindle版] まとめ

Logo

できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。

View the Project on GitHub nekonisi/MySQL

13_列に別名をつけて表示

概要

AS

概要

文法

列名 AS 別名

サンプル

列に別名を付けて表示

SELECT Continent, SUM(Population) AS TotalPop FROM country 
GROUP BY Continent WITH ROLLUP;
MariaDB [world]> SELECT Continent, SUM(Population) AS TotalPop FROM country GROUP BY Continent WITH ROLLUP;
+---------------+------------+
| Continent     | TotalPop   |
+---------------+------------+
| Asia          | 3705025700 |
| Europe        |  730074600 |
| North America |  482993000 |
| Africa        |  784475000 |
| Oceania       |   30401150 |
| Antarctica    |          0 |
| South America |  345780000 |
| NULL          | 6078749450 |
+---------------+------------+
8 rows in set (0.01 sec)