题解 | #顾客登录名#字段截取函数和拼接函数
顾客登录名
http://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
SELECT cust_id, cust_name,
UPPER(CONCAT(SUBSTRING(cust_name, 1, 2), SUBSTRING(cust_city, 1, 3))) AS user_login
FROM Customers;
顾客登录名
http://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
SELECT cust_id, cust_name,
UPPER(CONCAT(SUBSTRING(cust_name, 1, 2), SUBSTRING(cust_city, 1, 3))) AS user_login
FROM Customers;
相关推荐