mysql update from

UPDATE zcarlevelNew INNER JOIN zcarlevel ON zcarlevelNew.zflag=zcarlevel.zflag

SET zcarlevelNew.zflagName=zcarlevel.zlevel

update ecs_goods_attr
inner join  ecs_goods
set ecs_goods_attr.attr_value = '否'
where ecs_goods_attr.attr_id = 53
and ecs_goods_attr.goods_id = ecs_goods.goods_id
and ecs_goods.goods_name like '%已售%'