1、类型替换
CAST类型强制转换
CAST(expr AS type)
CONVERT类型转换
CONVERT(expr,type)
type值:BINARY,CHAR,DATE,DATETIME,TIME,DECIMAL,SIGNED,UNSIGNED
2、替换字符串
REPLACE(str,from_str,to_str)
1、类型替换
CAST类型强制转换
CAST(expr AS type)
CONVERT类型转换
CONVERT(expr,type)
type值:BINARY,CHAR,DATE,DATETIME,TIME,DECIMAL,SIGNED,UNSIGNED
2、替换字符串
REPLACE(str,from_str,to_str)