UPDATE log_history a ,(SELECT * FROM detail_history WHERE REMARK IS NOT NULL ) b SET a.REMARK=b.REMARK WHERE a.KEY_ID=b.RELA_LOG_ID
将一张表的字段赋给另一张表的字段
最新推荐文章于 2024-08-09 15:01:36 发布
UPDATE log_history a ,(SELECT * FROM detail_history WHERE REMARK IS NOT NULL ) b SET a.REMARK=b.REMARK WHERE a.KEY_ID=b.RELA_LOG_ID