dedecms中常用的数据表操作SQL语句

作者：袖梨 2022-06-25

删除所有注册会员

 

 代码如下 复制代码
DELETE FROM `#@__member` WHERE `#@__member`.`mid`!= 1;
TRUNCATE TABLE `#@__member_flink`;
TRUNCATE TABLE `#@__member_person`;

批量修改栏目为动态

 代码如下 复制代码

UPDATE `#@__arctype` SET `isdefault` = '-1'

批量删除文章

 代码如下 复制代码

DELETE FROM #@__addonarticle WHERE aid>0;
DELETE FROM #@__arctiny WHERE id>0;
DELETE FROM #@__archives WHERE id>0;

批量修改文章为动态显示

 代码如下 复制代码

update #@__archives set ismake=-1;

批量修改文章为静态显示

 代码如下 复制代码

update #@__archives set ismake=1;

批量删除所有内容为空文章

 代码如下 复制代码

DELETE FROM #@__arctiny where id in(select aid from #@__addonarticle where body='');
DELETE FROM #@__archives where id in(select aid from #@__addonarticle where body='');
DELETE FROM #@__addonarticle where body='';

批量删除标题为空的文章

 

 代码如下 复制代码
DELETE FROM #@__addonarticle where aid in(select id from #@__archives where title='');
DELETE FROM #@__arctiny where id in(select id from #@__archives where title='');
DELETE FROM #@__archives where where title='';


批量审核文档

 代码如下 复制代码

Update `#@__arctiny` set arcrank='0' where arcrank='-1';
Update `#@__archives` set arcrank='0' where arcrank='-1';

批量删除未审核的文档

 代码如下 复制代码

DELETE FROM #@__addonarticle where aid in(select id from #@__arctiny where arcrank='-1');
DELETE FROM `#@__arctiny` where arcrank='-1';
DELETE FROM `#@__archives` where arcrank='-1';

TRUNCATE TABLE `#@__member_space`;
TRUNCATE TABLE `#@__member_tj`;

相关文章

精彩推荐