/*concat*/
select concat('Hello','MySQL');
/*lower*/
select lower('Hello');
/*upper*/
select upper('Hello');
/*lpad*/
select lpad('01',5,'-');
/*rpad*/
select rpad('01',5,'-');
/*trim*/
select trim(' Hello MySQL ');
/*substring*/
select substring('Hello MySQL',1,5);/*下标从1开始*/
/*企业员工的工号统一为5位子,不足5位在前补0,比如1->00001*/
update emp set workno = lpad(workno,5,'0');
select workno from emp;