update table_a a
/* 更新a表col字段值等于b表中coll字段的值,其中a.id=b.id */
set col=(select coll from table_b b where a.id=b.id and coll is not null)
/* 只更新a.id再b表中存在的记录 ,如果不加该条件会有问题*/
where exists (select 1 from table_b b where a.id=b.id)
update table_a a
/* 更新a表col字段值等于b表中coll字段的值,其中a.id=b.id */
set col=(select coll from table_b b where a.id=b.id and coll is not null)
/* 只更新a.id再b表中存在的记录 ,如果不加该条件会有问题*/
where exists (select 1 from table_b b where a.id=b.id)