UPDATE wp_posts SET post_content = REPLACE(post_content, '旧字符', '新字符') WHERE post_type = 'post' AND post_status = 'publish' and post_content like '%旧字符%';
Categories:
数据库运维
Related Posts:-
MySQL8 1396错误处理
Last_SQL_Errno: 1396 Last_SQL_Error: Coordinator stopped because there were error(s) in…
MySQL8 2061错误的处理
Last_IO_Errno: 2061 Last_IO_Error: error connecting to master 'repl@210.14.75.1:3306' - retry-time:…
MySQL8.0 执行脚本恢复报错@@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@
从线上 dump 出 sql 脚本，恢复到本地新建数据库报错。 在复制后执行sql导入数据库的时候，报错:@@GLOBAL.GTID_PURGED cannot be changed: the…