group_concat
concat_ws
concat_ws()函数
功能:concat_ws()函数 和 concat()函数一样,也是将多个字符串连接成一个字符串,但是可以指定分隔符!
语法:concat_ws(separator, str1, str2, ...) 第一个参数指定分隔符, 后面依旧是字符串
cast函数
其中 decimal(m,n) ,其中 m>n,表示总共 m 位数据,其中小数 n
select cast(18.345 as decimal(10, 2)) as num
//结果:18.35
select cast('2022-10-08 15:31:26' as datetime ) as date
//结果:2022-10-08 15:31:26
select cast('2022-10-08 15:31:26' as date ) as date
//结果::2022-10-08
select cast('2022-10-08 15:31:26' as time ) as date
//结果:15:31:26
select cast('2022-10-08 15:31:26' as char ) as date
//结果:2022-10-08 15:31:26