mysql - 根据mysql中的条件从另一个表更新一个表

Question

我想从另一个表project_progress_detial.PPD_Progress更新project_progress.project_progress列并进行此查询

UPDATE project_progress   
set progress_percent   =
(select PPD_Progress from project_progress_detial
where project_progress.project_id =project_progress_detial.PPD_ProjID and
project_progress.project_part_no = 1) table where 

但问题是它返回和错误

子查询返回多于一行

实际上我想将我的 PPD_PRogress 数据转移到另一个表中的 Project_Progress 列中。

标签： mysqlsql

Answer 1

    update project_progress 
    inner join project_progress_detial
    on project_progress.project_id=project_progress_detial.PPD_ProjID


    set project_progress.project_progress=project_progress_detial.PPD_Progress
where project_progress.project_part_no = 1