sql语句：按照id顺序把帝国已发文章的tags字段值全部替换成关键字的字段值

按照id顺序把帝国已发文章的tags字段值全部替换成关键字的字段值！
以下是针对新闻模型进行写的语句。
tags字段infotags在分表中：phome_ecms_news_data_1
关键字字段keyboard在主表中：phome_ecms_news

update A set A.列=(select B.列 from B where A.关联列 = B.关联列)

update phome_ecms_news_data_1 set phome_ecms_news_data_1.infotags=(select phome_ecms_news.keyboard from phome_ecms_news where phome_ecms_news_data_1.id = phome_ecms_news.id)

相关阅读：
帝国cms批量替换字段值sql语句
https://www.iduyao.cn/topics/241