mysql - Xenice

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批量删除指定分类下的所有文章

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常用语句

2020-04-13 xenice 198 阅读

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