WordPress批量替换链接域名

WordPress批量替换链接域名

2020-07-10 xenice 91 阅读

UPDATE wp_options SET option_value = replace(option_value, 'www.mydomain.com','www.newdomain.com') ; UPDATE wp_posts SET post_content = replace(post_content, 'www.mydomain.com'...

WordPress批量删除指定分类下的所有文章

WordPress批量删除指定分类下的所有文章

2020-04-14 xenice 367 阅读

#删除指定分类的文章 delete from xn_posts using xn_posts, xn_term_relationships, xn_term_taxonomy where xn_posts.id = xn_term_relationships.object_id and xn_term_rel...

mysql常用语句

mysql常用语句

2020-04-13 xenice 198 阅读

#解决升级 WordPress 时提示“另一更新正在进行” delete from wp_options where option_name='core_updater.lock'; #替换字符串 UPDATE ir_art SET cnt = REPLACE (cnt, '旧字符串', '新...

mysql批量去除重复记录

mysql批量去除重复记录

2019-10-09 xenice 1461 阅读

删除表中多余的重复记录,根据单个字段判断,如字段名md5,重复记录只留有id最小的记录。 DELETE FROM ir_art WHERE md5 IN ( SELECT md5 FROM...