mysql更新一个表里的字段等于另一个表某字段的值实例

update table1 as z left join table2 as zb on z.zcatId = zb.zcatId set z.zcatName = zb.zcatName where z.zcatName is null;