AS)輸出。SELECT CONCAT(name, '(', country, ')') AS title
FROM company
ORDER BY name;
結果範例:Google(USA)、Alibaba(CN)。
SELECT prod_num * prod_price AS total_price, prod_name
FROM products;
支援 + - * /,優先級同數學規則,可用括號控制。
SELECT 3 * 2; -- 6
SELECT NOW(); -- 當前日期時間
SELECT VERSION(); -- MySQL 版本
MySQL 5.7+ 支援 GENERATED COLUMNS:
CREATE TABLE t (
a INT,
b INT,
sum_ab INT GENERATED ALWAYS AS (a + b) VIRTUAL, -- 查詢時計算
prod_ab INT GENERATED ALWAYS AS (a * b) STORED -- 寫入時計算並存儲
);
VIRTUAL:不佔磁碟,讀取時計算。STORED:佔磁碟,寫入時計算,讀取快,可建索引。