dedecms使用sql批量維護網(wǎng)站內(nèi)容：

1.將所有文檔設(shè)置為“僅動態(tài)”：update dede_archives set ismake=-1
2.將所有文檔設(shè)置為“僅靜態(tài)”：update dede_archives set ismake=1

頭條[h]推薦[c]幻燈[f]特薦[a]滾動[s]加粗圖片[p]跳轉(zhuǎn)[j]

sql批量刪除全部文章

DELETE FROM dede_addonarticle
DELETE FROM dede_arctiny
DELETE FROM dede_archives

刪除標(biāo)題小于5個字的文檔
DELETE FROM dede_addonarticle where aid in(select id from dede_archives 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

刪除內(nèi)容小于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