concat函数连接时如果某一字段有null时连接结果就是null,真是个妖怪【·~·】
用ifnull处理一下,默认值设为’’~~
select
c.name_zh,
c.registration_number,
c.manufacturer_zh,
c.manufacturer_en,
concat(ifnull(c.manufacturer_zh,""),ifnull(c.manufacturer_en,""))
from cfdas c
where length(c.registration_number) >0