创建计算字段
计算字段
计算字段并不实际存在于数据库表中。计算字段是运行时在 SELECT 语句内创建的。
拼接字段
SELECT Concat(vend_name, ' (', vend_country, ')')
FROM Vendors
ORDER BY vend_name;
SQL的 TRIM() 函数清除数据左右的空格
SELECT trim(Concat(vend_name, ' (', vend_country, ')'))
FROM Vendors
ORDER BY vend_name;
使用别名
SELECT trim(Concat(vend_name, ' (', vend_country, ')')) as vent_title
FROM Vendors
ORDER BY vend_name;
执行算术计算
SELECT prod_id,
quantity,
item_price,
quantity*item_price AS expanded_price
FROM OrderItems
WHERE order_num = 20008;