dedecms使用sql语句批量维护网站内容,DEDE技术
导读:DEDE技术
dedecms使用sql批量维护网站内容：
1.将所有文档设置为“仅动态”：update dede_archives set ismake=-1 2.将所有文档设置为“仅静态”：update dede_archives set ismake=1
头条[h]推荐[c]幻灯[f]特荐[a]滚动[s]加粗图片[p]跳转[j]dede模板安装
sql批量删除全部文章
DELETE FROM dede_addonarticle DELETE FROM dede_arctiny DELETE FROM dede_archives
删除标题小于5个字的文档 DELETE FROM dede_addonarticle where aid in(select id from dede_arc织梦模板hives where LENGTH(title)<10) DELETE FROM dede_arctiny where id in(select id from dede_archives where LENGTH(title)<10) DELETE FROM dede_archives where LENGTH(title)<10
删除内容小于100个字的文档 DELETE FROM dede_arctiny where id in(select aid from dede_addonarticle where LENGTH(body)<50) DELETE FROM dede_archives where id in(select aid from dede_addonarticle where LENGTH(body)<50) DELETE FROM dede_addonarticle where LENGTH(body)<50 dede
相关织梦首页模板织梦后台模板。声明: 本文由我的SEOUC技术文章主页发布于:2023-07-22 ，文章dedecms使用sql语句批量维护网站内容,DEDE技术主要讲述批量,语句,DEDE技术网站建设源码以及服务器配置搭建相关技术文章。转载请保留链接: https://www.seouc.com/article/web_33954.html
