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技術網站建設源碼以及服務器配置搭建相關技術文章。轉載請保留鏈接: http://www.bifwcx.com/article/web_33954.html
