(1)select Concat(user,'(', user_id ,')') from users order by user;
#concat函数拼接两个列。其他DBMS采用+或者||拼接
(2)select Concat(Rtrim(user),'(',RTrim(last_name ), ')') from users order by user;
#Rtrim去除右边空格,还有ltrim(),Trim()函数
(3)select Concat(Rtrim(user),'(',RTrim(last_name ), ')') AS user_title from users order by user;
#使用别名
(4) select first_name , last_name from users where user_id =3;
#执行算术计算
(5)select prod_id, quantity, item_price, quantity*item_price AS expended_price FROM orderitems WHERE order_num=2005;
#计算order_num为2005中两个列的乘积
mysql必知必会第十章创建计算字段
最新推荐文章于 2022-05-10 16:00:53 发布