个人整理的dedecms清除文档最全的sql语句,希望能够帮到大家(注意:执行sql语句前请一定做好数据库备份)个人整理的dedecms清除文档最全的sql语句,希望能够帮到大家 (注意:执行sql语句前请一定做好数据库备份) DELETE FROM wmd_addonarticle WHERE aid0;DELETE FROM wmd_arctiny WHERE id0;DELETE FROM wmd_archives WHERE id0;DELETE FROM wmd_co_htmls WHERE aid0;DELETE FROM wmd_log WHERE l
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;
织梦狗教程
本文标题为:织梦dedecms最全的清除文档的sql语句


基础教程推荐
猜你喜欢
- dedecms织梦复制https链接网站图片无法本地化的解决办法 2022-06-23
- PbootCMS伪静态配置教程以及各web容器配置规则 2023-07-08
- PbootCMS的阿里云短信发送类 2023-07-09
- Thinkphp5结合layer弹窗定制操作结果页面 2022-08-16
- 织梦采集标题不完整的解决方法,修改标题长度 2022-07-14
- dedecms织梦全局变量调用方法总结 2023-07-08
- pbootcms文章插入图片不固定宽高的办法 2023-07-08
- 织梦dedecms后台添加变量提示Request var not allow 2023-07-08
- PbootCMS调用全站所有栏目最新文章的写法 2023-07-09
- 织梦dedecms不显示未审核tag标签文档的的方法 2022-11-04