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, '\\"','"');
上一篇:python学习笔记系列----(四)模块


下一篇:[MySQL] MySQL存储过程 事务transaction 数据表重建