遇到问题:织梦如何批量添加友情链接?
解决办法:
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语句，如果是多条的话，直接复制粘贴，然后更换域名网址与关键词就可以了。
转载请注明：大灰牛博客 » 织梦cms如何用SQL语句批量增加或者删除友情链接