当前位置:首页 > 行业动态 > 正文

如何在织梦dedecms中使用SQL语句彻底删除所有文章内容而不影响其他数据?

删除全部文章的SQL语句
注意:执行以下操作前请确保已做好数据备份,因为这将删除所有文章及其相关数据。
删除文章内容
DELETE FROM dede_arctype WHERE id > 0; 假设文章类型ID大于0
DELETE FROM dede_addonarticle WHERE aid > 0; 假设文章附加信息ID大于0
DELETE FROM dede_archives WHERE id > 0; 假设文章ID大于0
删除文章评论(如果有的话)
DELETE FROM dede_replay WHERE arc_id > 0; 假设文章ID大于0
删除文章标签(如果有的话)
DELETE FROM dede_tagArcs WHERE arcID > 0; 假设文章ID大于0
删除所有文章类型
DELETE FROM dede_arctype WHERE id > 0;
删除所有用户(如果不需要删除用户)
DELETE FROM dede_member WHERE id > 0;
删除所有图片(如果文章中包含图片)
DELETE FROM dede_arctype WHERE id > 0; 删除文章类型中的图片
DELETE FROM dede_addonarticle WHERE aid > 0; 删除文章附加信息中的图片
DELETE FROM dede_attachment WHERE aid > 0; 删除附件中的图片
删除所有分类信息
DELETE FROM dede_category WHERE id > 0;
删除所有自定义表单数据(如果有的话)
DELETE FROM dede_formdata WHERE aid > 0;
删除所有自定义表单字段(如果有的话)
DELETE FROM dede_formfield WHERE fid > 0;
删除所有自定义表单(如果有的话)
DELETE FROM dede_form WHERE fid > 0;
删除所有缓存数据(如果有的话)
DELETE FROM dede_cache;
删除所有搜索关键词(如果有的话)
DELETE FROM dede_keywords WHERE id > 0;
删除所有搜索关键词统计(如果有的话)
DELETE FROM dede_keywordsnum WHERE id > 0;
删除所有在线调查数据(如果有的话)
DELETE FROM dede_survey WHERE id > 0;
删除所有在线调查选项(如果有的话)
DELETE FROM dede_surveyitem WHERE id > 0;
删除所有在线投票数据(如果有的话)
DELETE FROM dede_vote WHERE id > 0;
删除所有在线投票选项(如果有的话)
DELETE FROM dede_voteitem WHERE id > 0;
删除所有友情链接(如果有的话)
DELETE FROM dede_links WHERE id > 0;
删除所有广告(如果有的话)
DELETE FROM dede_ad WHERE id > 0;
删除所有广告位置(如果有的话)
DELETE FROM dede_adposition WHERE id > 0;
删除所有在线客服数据(如果有的话)
DELETE FROM dede_customercare WHERE id > 0;
删除所有在线客服类别(如果有的话)
DELETE FROM dede_customercare_type WHERE id > 0;
删除所有在线客服问题(如果有的话)
DELETE FROM dede_customercare_question WHERE id > 0;
删除所有在线客服答案(如果有的话)
DELETE FROM dede_customercare_answer WHERE id > 0;
删除所有公告(如果有的话)
DELETE FROM dede_bulletin WHERE id > 0;
删除所有公告类别(如果有的话)
DELETE FROM dede_bulletin_type WHERE id > 0;
删除所有文章收藏记录(如果有的话)
DELETE FROM dede_collection WHERE id > 0;
删除所有文章推荐记录(如果有的话)
DELETE FROM dede_recommend WHERE id > 0;
删除所有用户留言(如果有的话)
DELETE FROM dede_message WHERE id > 0;
删除所有用户评论(如果有的话)
DELETE FROM dede_comments WHERE id > 0;
删除所有标签数据(如果有的话)
DELETE FROM dede_tag WHERE id > 0;
删除所有标签关联数据(如果有的话)
DELETE FROM dede_tag_relation WHERE id > 0;
删除所有标签文章关联数据(如果有的话)
DELETE FROM dede_tag_archives WHERE id > 0;
删除所有在线访谈数据(如果有的话)
DELETE FROM dede_interview WHERE id > 0;
删除所有在线访谈类别(如果有的话)
DELETE FROM dede_interview_type WHERE id > 0;
删除所有在线访谈问题(如果有的话)
DELETE FROM dede_interview_question WHERE id > 0;
删除所有在线访谈答案(如果有的话)
DELETE FROM dede_interview_answer WHERE id > 0;
删除所有在线问卷调查数据(如果有的话)
DELETE FROM dede_questionnaire WHERE id > 0;
删除所有在线问卷调查类别(如果有的话)
DELETE FROM dede_questionnaire_type WHERE id > 0;
删除所有在线问卷调查问题(如果有的话)
DELETE FROM dede_questionnaire_question WHERE id > 0;
删除所有在线问卷调查答案(如果有的话)
DELETE FROM dede_questionnaire_answer WHERE id > 0;
删除所有在线投票数据(如果有的话)
DELETE FROM dede_vote WHERE id > 0;
删除所有在线投票类别(如果有的话)
DELETE FROM dede_vote_type WHERE id > 0;
删除所有在线投票选项(如果有的话)
DELETE FROM dede_vote_item WHERE id > 0;
删除所有在线投票结果(如果有的话)
DELETE FROM dede_vote_result WHERE id > 0;
删除所有文章分类信息(如果有的话)
DELETE FROM dede_category WHERE id > 0;
删除所有自定义表单数据(如果有的话)
DELETE FROM dede_formdata WHERE aid > 0;
删除所有自定义表单字段(如果有的话)
DELETE FROM dede_formfield WHERE fid > 0;
删除所有自定义表单(如果有的话)
DELETE FROM dede_form WHERE fid > 0;
删除所有缓存数据(如果有的话)
DELETE FROM dede_cache;
删除所有搜索关键词(如果有的话)
DELETE FROM dede_keywords WHERE id > 0;
删除所有搜索关键词统计(如果有的话)
DELETE FROM dede_keywordsnum WHERE id > 0;
删除所有在线调查数据(如果有的话)
DELETE FROM dede_survey WHERE id > 0;
删除所有在线调查类别(如果有的话)
DELETE FROM dede_survey_type WHERE id > 0;
删除所有在线调查问题(如果有的话)
DELETE FROM dede_survey_question WHERE id > 0;
删除所有在线调查答案(如果有的话)
DELETE FROM dede_survey_answer WHERE id > 0;
删除所有在线投票数据(如果有的话)
DELETE FROM dede_vote WHERE id > 0;
删除所有在线投票类别(如果有的话)
DELETE FROM dede_vote_type WHERE id > 0;
删除所有在线投票选项(如果有的话)
DELETE FROM dede_vote_item WHERE id > 0;
删除所有在线投票结果(如果有的话)
DELETE FROM dede_vote_result WHERE id > 0;
删除所有友情链接(如果有的话)
DELETE FROM dede_links WHERE id > 0;
删除所有广告(如果有的话)
DELETE FROM dede_ad WHERE id > 0;
删除所有广告位置(如果有的话)
DELETE FROM dede_adposition WHERE id > 0;
删除所有在线客服数据(如果有的话)
DELETE FROM dede_customercare WHERE id > 0;
删除所有在线客服类别(如果有的话)
DELETE FROM dede_customercare_type WHERE id > 0;
删除所有在线客服问题(如果有的话)
DELETE FROM dede_customercare_question WHERE id > 0;
删除所有在线客服答案(如果有的话)
DELETE FROM dede_customercare_answer WHERE id > 0;
删除所有公告(如果有的话)
DELETE FROM dede_bulletin WHERE id > 0;
删除所有公告类别(如果有的话)
DELETE FROM dede_bulletin_type WHERE id > 0;
删除所有文章收藏记录(如果有的话)
DELETE FROM dede_collection WHERE id > 0;
删除所有文章推荐记录(如果有的话)
DELETE FROM dede_recommend WHERE id > 0;
删除所有用户留言(如果有的话)
DELETE FROM dede_message WHERE id > 0;
删除所有用户评论(如果有的话)
DELETE FROM dede_comments WHERE id > 0;
删除所有标签数据(如果有的话)
DELETE FROM dede_tag WHERE id > 0;
删除所有标签关联数据(如果有的话)
DELETE FROM dede_tag_relation WHERE id > 0;
删除所有标签文章关联数据(如果有的话)
DELETE FROM dede_tag_archives WHERE id > 0;
删除所有在线访谈数据(如果有的话)
DELETE FROM dede_interview WHERE id > 0;
删除所有在线访谈类别(如果有的话)
DELETE FROM dede_interview_type WHERE id > 0;
删除所有在线访谈问题(如果有的话)
DELETE FROM
0