POST TIME:2018-08-09 00:48
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