织梦DedeCMS常用sql数据库命令

入口：织梦后台-系统-SQL命令行工具

织梦批量审核所有文章

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

整站动态化

update `#@__arctype` set isdefault=-1;
update `#@__archives` set ismake=-1;

整站静态化

update `#@__arctype` set isdefault=1;
update `#@__archives` set ismake=1;