操作方法:
(1)进入dedecms网站的后台,选择“系统设置”中的“SQL命令行工具”;
(2)选择“运行SQL命令行多行命令”,并在下方的命令框中输入以下10行命令:
delete from dede_addonarticle; delete from dede_addonimages; delete from dede_archives; delete from dede_arctiny; delete from dede_co_htmls; delete from dede_co_urls; delete from dede_co_mediaurls; delete from dede_tagindex ; delete from dede_taglist; delete from dede_keywords;
(3)上述10行命令运行成功后,清空命令框中的命令,再输入下面2行命令并运行:
TRUNCATE TABLE `dede_archives`; TRUNCATE TABLE `dede_archives`;
(4)最后,再次清空命令框中第3步的2行命令,输入下列3条命令并运行:
ALTER TABLE `dede_archives` AUTO_INCREMENT =1; ALTER TABLE `dede_arctiny` AUTO_INCREMENT =1; ALTER TABLE `dede_addonarticle` AUTO_INCREMENT =1;
至此,网站原来所有的文章都被删除了,而且再新建文章时,文章ID从1开始了。
清除所有Tag语句:
delete FROM dede_tagindex where typeid not in (SELECT id FROM dede_arctype); delete FROM dede_taglist where typeid not in (SELECT id FROM dede_arctype);
【注意事项】如果修改过表头的用户注意将命令中的表头重命名。