mysql批量替换zencart数据中的反斜杠\

最新推荐文章于 2024-02-02 14:20:07 发布

weixin_33923762

最新推荐文章于 2024-02-02 14:20:07 发布

阅读量152

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/afish/p/3949490.html

版权

update products_description set products_description=replace(products_description, "\\'","'");
update products_description set products_name=replace(products_name, "\\'","'");
update categories_description set categories_name=replace(categories_name, "\\'","'");
update meta_tags_categories_description set metatags_title=replace(metatags_title,  "\\'","'");
update meta_tags_categories_description set metatags_keywords=replace(metatags_keywords,  "\\'","'");
update meta_tags_categories_description set metatags_description=replace(metatags_description,  "\\'","'");
update meta_tags_products_description set metatags_title=replace(metatags_title,   "\\'","'");
update meta_tags_products_description set metatags_keywords=replace(metatags_keywords,   "\\'","'");
update meta_tags_products_description set metatags_description=replace(metatags_description,   "\\'","'");

update products_description set products_description=replace(products_description, '\\"','"');
update products_description set products_name=replace(products_name, '\\"','"');
update categories_description set categories_name=replace(categories_name, '\\"','"');
update meta_tags_categories_description set metatags_title=replace(metatags_title,  '\\"','"');
update meta_tags_categories_description set metatags_keywords=replace(metatags_keywords,  '\\"','"');
update meta_tags_categories_description set metatags_description=replace(metatags_description,  '\\"','"');
update meta_tags_products_description set metatags_title=replace(metatags_title,   '\\"','"');
update meta_tags_products_description set metatags_keywords=replace(metatags_keywords,   '\\"','"');
update meta_tags_products_description set metatags_description=replace(metatags_description,   '\\"','"');