备忘：帝国CMs分表语句、按条件替换删除略缩图、处理tags等语句 – 国外主机测评

也想出现在这里？点击联系我~

1、分表处理语句

/*首先插入1到5万的数据到目标分表中*/

INSERTINTOphome_ecms_news_data_2SELECT*FROMphome_ecms_news_data_1T2WHERET2.ID>50000ANDT2.ID<90000;

/*然后删除原始分表中1到5万的数据*/

deletefromphome_ecms_news_data_1WHEREID>50000ANDID<90000;

/*做完这些后，更新数据库缓存*/

2、图片前缀替换处理语句

/*替换略缩图前缀*/

UPDATEphome_ecms_newsSETtitlepic=replace(titlepic,'https://www.haobbc.com/upload/','https://img.ipipp.com/haobbc/upload/');

/*处理文章内容前缀*/

UPDATEphome_ecms_news_data_1SETnewstext=replace(newstext,'/upload/','https://img.ipipp.com/haobbc/upload/');

/*上面两段处理后运行下面两段*/

selectidfromphome_ecms_newswhereidnotin(selectidfromphome_ecms_news_data_1)

updatephome_ecms_newssetstb=2whereidin(selectidfromphome_ecms_news_data_2)

3、按条件清空略缩图：

updatephome_ecms_newssettitlepic=""wheretitlepiclike'%https://img.ipipp.com/haobbc/upload/kook/%';

4、Tags处理：

UPDATEphome_enewstagsdataSETclassid=replace(classid,'5','39')whereclassid=5;

5、点击处理：

UPDATEphome_ecms_newsSETonclick=replace(onclick,'0','1');