去除mysql字段中的空格换行

清理垃圾数据用


UPDATE quality_rule_detail SET rule_detail_id = REPLACE(REPLACE(REPLACE(REPLACE(rule_detail_id, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET rule_type_id = REPLACE(REPLACE(REPLACE(REPLACE(rule_type_id, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET rule_field_id = REPLACE(REPLACE(REPLACE(REPLACE(rule_field_id, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET field_key = REPLACE(REPLACE(REPLACE(REPLACE(field_key, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET field_name = REPLACE(REPLACE(REPLACE(REPLACE(field_name, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET field_type = REPLACE(REPLACE(REPLACE(REPLACE(field_type, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');
UPDATE quality_rule_detail SET platform = REPLACE(REPLACE(REPLACE(REPLACE(platform, CHAR(34), ''),CHAR(13),''),CHAR(10),''),CHAR(9),'');

原文链接: 去除mysql字段中的空格换行 版权所有,转载时请注明出处,违者必究。
注明出处格式:流沙团 ( https://gyarmy.com/post-593.html )

发表评论

0则评论给“去除mysql字段中的空格换行”