SELECT LENGTH('lyw');
SELECT LENGTH('周杰伦');
SELECT CONCAT(last_name,first_name) 姓名 FROM employees;
SELECT UPPER('john');
SELECT LOWER('jOHn');
SELECT CONCAT(UPPER(last_name),lower(first_name)) 姓名 FROM employees;
SELECT UPPER('john');
SELECT LOWER('jOHn');
SELECT CONCAT(UPPER(last_name),lower(first_name)) 姓名 FROM employees;
SELECT SUBSTR('周杰伦说他爱和奶茶',6) out_put;
SELECT SUBSTR('邓紫棋的大眼睛',1,3) out_put;
SELECT CONCAT(UPPER(SUBSTR(last_name,1,1)),'_', LOWER(SUBSTR(last_name,2))) out_put FROM employees;
SELECT INSTR('杨过说他爱小龙女','小龙女') AS out_put;
SELECT TRIM(' 扽这个i其 ')AS out_put;
SELECT LPAD('邓紫棋',2,'*') AS out_put;
SELECT RPAD('邓紫棋',12,'@') AS out_put;
SELECT REPLACE('杨过喜欢小龙女','小龙女','岳不群') AS out_put;