自我评价:走在路上的菜鸟,想着CMS|WEB|SEO,做着可以成为牛掰程序seoer的梦!

当前位置:博客 > 问题汇总 >

[已解决]织梦cms如何用SQL语句批量增加或者删除友情链接

作者:灰牛站长•发布时间:2021-07-15 17:46:08•浏览

遇到问题:织梦如何批量添加友情链接?

解决办法:

insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'网址+http/HTTPS','关键词1,关键词2','域名','','',1576053956,1,2);
//此为增加友链的SQL语句

举例代码:

insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','北京','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','吉林','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','湖北','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','甘肃','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','广东','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','新疆','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','上海','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','黑龙江','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','湖南','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','内蒙古','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','广西','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','天津','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','江苏','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','海南','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','辽宁','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','云南','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','重庆','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','福建','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','四川','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','浙江','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','西藏','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','河北','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','江西','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','贵州','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','安徽','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','青海','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','山西','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','山东','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','陕西','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','河南','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','宁夏','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','台湾','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','香港','','','',1576053956,1,2);
insert into dede_flink(id,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck) values(DEFAULT,1,'javascript:;','澳门','','','',1576053956,1,2);

delete from dede_flink where url like '%域名%' //此为删除友链SQL语句

这是一条增减友情的SQL语句,如果是多条的话,直接复制粘贴,然后更换域名网址与关键词就可以了。

相关文章

手机端