dedecms织梦常用sql命令批量修改总结示例

select namerule from dede_arctype
select namerule2 from dede_arctype
update dede_arctype set namerule='{typedir}/{aid}.html'
update dede_arctype set namerule2='{typedir}/list_{page}.html'

update dede_addonarticle set body=replace(body,'原来的字符','替换后的字符')

update dede_archives set litpic=replace(litpic,'原来的字符','替换后的字符')

update dede_addonarticle set body=replace(body,'src="http://ebingou.cn/img/','src="http://ebingou.cn/images/');

update dede_addonarticle set body=replace(body,'href="http://www.ebingou.cn','href="http://ebingou.cn');

update dede_addonarticle set body=replace(body,'alt="http://www.ebingou.cn/','alt="http://ebingou.cn/');

update dede_addonsoft set introduce=replace(introduce,'href="http://www.ebingou.cn/index.html');

update dede_archives set writer=replace(writer,'http://www.ebingou.cn','http://ebingou.cn');

update dede_archives set source=replace(source,'代码号www.ebingou.cn','代码号ebingou.cn');

update `dede_arctype` set namerule='{typedir}/{aid}.html';

update dede_addonsoft set writer=replace(officialUrl,'http:/www.ebingou.cn','http://ebingou.cn');

update dede_archives set arcrank=0;
update dede_arctiny set arcrank=0;
update dede_taglist set arcrank=0;