UPDATE `jq_config_gd_address` SET city_code = REPLACE(REPLACE(city_code,CHAR(10),''),CHAR(13),'')WHERE ID = xxxxx;
将city_code 字段里面的空行和回车全部清除
UPDATE `jq_config_gd_address` SET city_code = REPLACE(REPLACE(city_code,CHAR(10),''),CHAR(13),'')WHERE ID = xxxxx;
将city_code 字段里面的空行和回车全部清除