您当前的位置: 以下是针对新闻模型进行写的语句。
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