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

时间：2022-06-25 19:31:14 编辑：袖梨来源：一聚教程网

删除所有注册会员

代码如下	复制代码
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`;

推荐专题

最新下载

热门教程

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

相关文章

热门栏目

php教程

asp.net教程

手机开发

css教程

网页制作

办公数码

jsp教程