关联更新表

 

update file_copy,file  set file_copy.project_id = file.project_id   where file_copy.file_id = file.id;