destoon采集论坛 › 产品使用 › 有没有办法批量移动文章到某个地区下？

zhijie88 发表于 2014-9-1 15:39:23

有没有办法批量移动文章到某个地区下？

以前数据少没在乎发布文章所属地区，现在文章量大了，想做城市分站了，但是不知道怎么样把一些文章批量的移动到相应的城市中，希望大家指点指点，后台没这功能的话masql语句也可以的，在此谢过！

xuezuo 发表于 2014-9-1 18:17:56

一些文章？这个一些，具体是什么条件？
update destoon_article_23 SET `areaid` = ‘新地区id' WHERE 条件;

fengshanghang 发表于 2014-9-1 19:04:10

不太清楚

zhijie88 发表于 2014-9-1 19:23:08

搞定了，不过差点拉死服务器！[*]UPDATE ckexc_buy_6 SET areaid = '1' WHERE title like '%北京%';
[*]UPDATE ckexc_buy_6 SET areaid = '2' WHERE title like '%上海%';
[*]UPDATE ckexc_buy_6 SET areaid = '3' WHERE title like '%天津%';
[*]UPDATE ckexc_buy_6 SET areaid = '4' WHERE title like '%重庆%';
[*]UPDATE ckexc_buy_6 SET areaid = '5' WHERE title like '%河北%';
[*]UPDATE ckexc_buy_6 SET areaid = '6' WHERE title like '%山西%';
[*]UPDATE ckexc_buy_6 SET areaid = '7' WHERE title like '%内蒙古%';
[*]UPDATE ckexc_buy_6 SET areaid = '8' WHERE title like '%辽宁%';
[*]UPDATE ckexc_buy_6 SET areaid = '9' WHERE title like '%吉林%';
[*]UPDATE ckexc_buy_6 SET areaid = '10' WHERE title like '%黑龙江%';
[*]UPDATE ckexc_buy_6 SET areaid = '11' WHERE title like '%江苏%';
[*]UPDATE ckexc_buy_6 SET areaid = '12' WHERE title like '%浙江%';
[*]UPDATE ckexc_buy_6 SET areaid = '13' WHERE title like '%安徽%';
[*]UPDATE ckexc_buy_6 SET areaid = '14' WHERE title like '%福建%';
[*]UPDATE ckexc_buy_6 SET areaid = '15' WHERE title like '%江西%';
[*]UPDATE ckexc_buy_6 SET areaid = '16' WHERE title like '%山东%';
[*]UPDATE ckexc_buy_6 SET areaid = '17' WHERE title like '%河南%';
[*]UPDATE ckexc_buy_6 SET areaid = '18' WHERE title like '%湖北%';
[*]UPDATE ckexc_buy_6 SET areaid = '19' WHERE title like '%湖南%';
[*]UPDATE ckexc_buy_6 SET areaid = '20' WHERE title like '%广东%';
[*]UPDATE ckexc_buy_6 SET areaid = '21' WHERE title like '%广西%';
[*]UPDATE ckexc_buy_6 SET areaid = '22' WHERE title like '%海南%';
[*]UPDATE ckexc_buy_6 SET areaid = '23' WHERE title like '%四川%';
[*]UPDATE ckexc_buy_6 SET areaid = '24' WHERE title like '%贵州%';
[*]UPDATE ckexc_buy_6 SET areaid = '25' WHERE title like '%云南%';
[*]UPDATE ckexc_buy_6 SET areaid = '26' WHERE title like '%西藏%';
[*]UPDATE ckexc_buy_6 SET areaid = '27' WHERE title like '%陕西%';
[*]UPDATE ckexc_buy_6 SET areaid = '28' WHERE title like '%甘肃%';
[*]UPDATE ckexc_buy_6 SET areaid = '29' WHERE title like '%青海%';
[*]UPDATE ckexc_buy_6 SET areaid = '30' WHERE title like '%宁夏%';
[*]UPDATE ckexc_buy_6 SET areaid = '31' WHERE title like '%新疆%';复制代码

开心酒好 发表于 2014-9-3 11:36:56

zhijie88 发表于 2014-9-1 19:23

搞定了，不过差点拉死服务器！
亲，如何搞定的？

sbfgg.com 发表于 2014-9-1 19:23:00

http://bbs.destoon.com/static/image/smiley/default/titter.gif
拉死服务器
这个说法好可爱

zhijie88 发表于 2014-9-5 15:31:16

开心酒好 发表于 2014-9-3 11:36

亲，如何搞定的？
就用我发出来的这么一段查询语句啊，对的你的表执行就是了！

查看完整版本: 有没有办法批量移动文章到某个地区下？