将表B的某列更新到表A的某列,根据某个条件 UPDATE tableA AS t1, tableB AS t2 SET t1.colA = t2.colB WHERE t1.code = t2.code 温故而知新