mysql 换行变空格_去除mysql字段中的空格换行

最新推荐文章于 2022-09-02 11:47:20 发布

阿Test正经比比

最新推荐文章于 2022-09-02 11:47:20 发布

阅读量257

点赞数

文章标签： mysql 换行变空格

本文链接：https://blog.csdn.net/weixin_28698059/article/details/113278141

版权

清理垃圾数据用

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),'');

关注