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

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,   \\",");

 

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

上一篇:《数据库原理》课程笔记 (Ch02-数据模型)


下一篇:sql server转mysql数据导入