SQL 별칭

SQL Aliases

SQL 별칭

1 예시

mysql> SELECT COUNT(*) FROM Customers;
+----------+
| COUNT(*) |
+----------+
|        3 |
+----------+

mysql> SELECT COUNT(*) AS cnt FROM Customers;
+-----+
| cnt |
+-----+
|   3 |
+-----+

mysql> SELECT CustomerName, CONCAT(Address,', ',City,', ',PostalCode,', ',Country) FROM Customers WHERE CustomerID=4;
+-----------------+--------------------------------------------------------+
| CustomerName    | CONCAT(Address,', ',City,', ',PostalCode,', ',Country) |
+-----------------+--------------------------------------------------------+
| Around the Horn | 120 Hanover Sq., London, WA1 1DP, UK                   |
+-----------------+--------------------------------------------------------+

mysql> SELECT CustomerName, CONCAT(Address,', ',City,', ',PostalCode,', ',Country) AS Address FROM Customers WHERE CustomerID=4;
+-----------------+--------------------------------------+
| CustomerName    | Address                              |
+-----------------+--------------------------------------+
| Around the Horn | 120 Hanover Sq., London, WA1 1DP, UK |
+-----------------+--------------------------------------+

2 참고 자료

• http://www.w3schools.com/sql/sql_alias.asp