计算字段
select prod_id,quantity,item_price*100 as expanded_price from orderitems;
拼接字段
select concat(vend_name,'(',vend_country,')') from vendors;
使用别名
select concat(vend_name,vend_country) as name_country from vendors; // 使用别名 select concat(vend_name,vend_country) name_country from vendors; // 可以不加as
执行算数计算
select item_price*100 as expanded_price from orderitems;
