Mysql update from 使用

MSSQL 的Update from…用起来可以处理很多复杂的业务，但MySQL使用方式稍有不同；如下

UPDATE project_stage_logic 
INNER JOIN project_stage on project_stage.id=project_stage_logic.project_stage_id
set project_stage_logic.plan_end_time=adddate(project_stage_logic.plan_end_time,1),
project_stage_logic.plan_start_time=adddate(project_stage_logic.plan_start_time,1)
where project_stage.project_id=393 and project_stage_logic.id>440

（注意不能使用left ，要用INNER）