查询结果update字段到另外一张表中

http://www.jb51.net/article/71790.htm

UPDATE t_advs_order a INNER JOIN tk_zyt_scenery_order s ON s.order_id=a.`on` SET
  
 a.attribute1=s.order_id,
  
 a.attribute2=s.order_id;

UPDATE course_courses a INNER JOIN (SELECT courseId,mediaId, COUNT(*) FROM course_lesson  GROUP BY courseId HAVING COUNT(*) =1 ORDER  BY courseId ) s ON s.courseId=a.`id` 
 SET a.mediaId=s.mediaId

本文转载:CSDN博客