WordPress批量替换链接域名
2020-07-10 xenice 405 阅读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 1317 阅读#删除指定分类的文章 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 863 阅读#解决升级 WordPress 时提示“另一更新正在进行” delete from wp_options where option_name='core_updater.lock'; #替换字符串 UPDATE ir_art SET cnt = REPLACE (cnt, '旧字符串', '新...
mysql批量去除重复记录
2019-10-09 xenice 4163 阅读删除表中多余的重复记录，根据单个字段判断，如字段名md5，重复记录只留有id最小的记录。 DELETE FROM ir_art WHERE md5 IN ( SELECT md5 FROM...
热门文章
-
OneNice简洁大方且开源免费的WordPress主题 17106 阅读 -
Bootstrap4显示和隐藏元素 5072 阅读
-
mysql批量去除重复记录 4163 阅读
-
OneNice Pro简洁且强大的WORDPRESS主题 4124 阅读
-
-
loadjs - javascript动态载入css和js文件 2088 阅读
-
BT宝塔中安装nodejs 2023 阅读
-
github无法加载或不显示图片问题 1907 阅读
