UPDATE roncoo_education_course_dev.video_study_duration INNER JOIN (SELECT * FROM roncoo_education_user_dev.organization_staff ) b on roncoo_education_course_dev.video_study_duration.user_no=b.user_no SET roncoo_education_course_dev.video_study_duration.org_id=b.org_id
要是跨库的话就是在表前面加上库名 批量要用条件连接 最后的时候加上set