织梦dedecms最全的清除文档的sql语句 发布时间:2023/10/11 dedecms 织梦 sql 清除 个人整理的dedecms清除文档最全的sql语句,希望能够帮到大家(注意:执行sql语句前请一定做好数据库备份) DELETE FROM wmd_addonarticle WHERE aid>0; DELETE FROM wmd_arctiny WHERE id>0; DELETE FROM wmd_archives WHERE id>0; DELETE FROM wmd_co_htmls WHERE aid>0; DELETE FROM wmd_log WHERE lid>0; DELETE FROM wmd_co_mediaurls WHERE nid>0; DELETE FROM wmd_co_urls WHERE id>0; DELETE FROM wmd_search_keywords WHERE aid>0; DELETE FROM wmd_tagindex WHERE id>0; DELETE FROM wmd_uploads WHERE aid>0; ALTER TABLE `wmd_archives` AUTO_INCREMENT =1; ALTER TABLE `wmd_addonarticle` AUTO_INCREMENT =1; ALTER TABLE `wmd_arctiny` AUTO_INCREMENT =1; ALTER TABLE `wmd_taglist` AUTO_INCREMENT =1; ALTER TABLE `wmd_tagindex` AUTO_INCREMENT =1; ALTER TABLE `wmd_uploads` AUTO_INCREMENT =1; ALTER TABLE `wmd_co_htmls` AUTO_INCREMENT =1; ALTER TABLE `wmd_log` AUTO_INCREMENT =1; ALTER TABLE `wmd_search_keywords` AUTO_INCREMENT =1; DELETE FROM wmd_addonsoft WHERE id>0; DELETE FROM wmd_addonimages WHERE id>0; ALTER TABLE `wmd_addonsoft` AUTO_INCREMENT =1; ALTER TABLE `wmd_addonimages` AUTO_INCREMENT =1;复制代码