dedecms使用sql批量維護網站內容：

1.將所有文檔設置為“僅動態”：update dede_archives set ismake=-1
2.將所有文檔設置為“僅靜態”：update dede_archives set ismake=1

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

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_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

刪除內容小于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