mysql update select用法实例

http://www.3lian.com/edu/2014/05-13/147149.html

在mysql中，不能直接使用set select的结果，必须使用inner join：

　　update a inner join (select yy from b) c on a.id =b.id set a.xx = c.yy

　　如下一条经典Mysql update语句赋值嵌套select实例

　　update mem_player set `DataWarehouse`=(select `DataWarehouse` from (select * from mem_player) as b where `Pid`=100000)

==============================================

update course inner join (select courseId from course_lesson where id = 3517) c on course.id =c.courseId set course.hitNum=course.hitNum + 1