MySql AS (Alias、別名) (SQL Alias)

AS (Alias、別名) (SQL Alias)

SQL 中我們可以替資料表或欄位名稱取一個別名 (Alias)，這可以使名稱複雜的 SQL 查詢語句更易讀且可以有更直觀的查詢結果。

SELECT `Name` AS `C_Name`, `City` AS `C_City`,`Salary` FROM `customers`;

Example

SELECT o.Product, SUM(o.Quantity) AS Total FROM orders AS o GROUP BY o.Product;