mysql update 将一个表某字段设为另一个表某字段的值

UPDATE ps_plan_exe e,
ps_plan p
SET e.plan_class = p.plan_class
WHERE
e.plan_id = p.plan_id