将表B的某列更新到表A的某列，根据某个条件 

UPDATE tableA AS t1, tableB AS t2
SET t1.colA = t2.colB
WHERE t1.code = t2.code

 

posted @ 2019-08-19 11:57  new_boys  阅读(210)  评论(0)  编辑  收藏  举报