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

zhijie88

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

xuezuo

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

fengshanghang

不太清楚

zhijie88

搞定了，不过差点拉死服务器！[ol]

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 '%新疆%';[/ol]复制代码

开心酒好

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

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

sbfgg.com

  拉死服务器
这个说法好可爱

zhijie88

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

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