MySQL/語言/別名

可以利用 AS 為表示式和列指定別名。別名用作表示式的列名稱，並且可與 order by 或 having 子句一起使用。例如：

 SELECT 
     CONCAT(last_name,' ', first_name) AS full_name,
     nickname AS nick 
 FROM
     mytable 
 ORDER BY
     full_name

這些別名可以在 ORDER BY、GROUP BY 和 HAVING 子句中使用。它們不應用在 WHERE 子句中。

可以利用 AS 為表名稱分配更短的名稱以便引用。您可以省略 AS 這個詞，並且仍然使用別名。例如：

 SELECT
     COUNT(B.Booking_ID), U.User_Location 
 FROM
     Users U
 LEFT OUTER JOIN
     Bookings AS B
 ON 
     U.User_ID    = B.Rep_ID AND
     B.Project_ID = '10'
 GROUP BY
     (U.User_Location)

別名在您使用自連線時起到了至關重要的作用。例如：人員表分別被稱為 p 和 c 別名！

 SELECT
     p.name                                   AS parent,
     c.name                                   AS child,
     MIN((TO_DAYS(NOW())-TO_DAYS(c.dob))/365) AS minage
 FROM
     people AS p 
 LEFT JOIN
     people AS c 
 ON
     p.name=c.parent WHERE c.name IS NOT NULL
 GROUP BY
     parent HAVING minage > 50 ORDER BY p.dob;