1.concat()语句:拼接
将值连起来构成单个值,concat()语句
#vend_name(vend_country)
SELECT CONCAT(vend_name,'(',vend_country, ')')
FROM vendors
2.RTrim():去掉右边的所有空格;LTrim():去掉右边的所有空格;
SELECT CONCAT(RTRIM(vend_name),'(',RTRIM(vend_country), ')')
FROM vendors
3.算数计算
SELECT prod_id,quantity,item_price,quantity*item_price AS expanded_price
FROM orderitems
WHERE order_num ='20005'
操作符 | 说明 |
---|---|
+ | 加 |
- | 减 |
* | 乘 |
/ | 除 |