concat_ws函数:
concat_ws(‘需要插入的字符’,拼接字段1,拼接字段2)
SELECT concat_ws('-' ,substring(a.tax_month,1,4), substring(a.tax_month,5,2)) AS yy FROM vat_tax_return a
concat_ws函数:
concat_ws(‘需要插入的字符’,拼接字段1,拼接字段2)
SELECT concat_ws('-' ,substring(a.tax_month,1,4), substring(a.tax_month,5,2)) AS yy FROM vat_tax_return a