语句:select d.division_name,d.full_name,d.creat_time from es_com_staff as d
结果:
一:字符串相加
语句:select concat( d.division_name, "-", d.full_name ) AS fullname ,d.creat_time from es_com_staff as d
结果:
二:截取字符串
语句:SELECT SUBSTRING(d.creat_time,1,10) as ftime from es_com_staff as d
结果: