原sql
UPDATE t_cc_usercourse t SET t.commenttime = DATE_ADD( t.commenttime, interval 462652 SECOND),
t.createtime = DATE_ADD( t.commenttime, interval 332254 SECOND)WHERE t.usercourse_id IN
(SELECT MIN(usercourse_id) as usercouseid FROM t_cc_usercourse t GROUP BY course_id ) ;
错误提示1093
修改如下:
UPDATE t_cc_usercourse t SET t.commenttime = DATE_ADD( t.commenttime, interval 462652 SECOND),
t.createtime = DATE_ADD( t.commenttime, interval 332254 SECOND)WHERE t.usercourse_id IN
( SELECT m.usercouseid FROM (SELECT MIN(usercourse_id) as usercouseid FROM t_cc_usercourse t GROUP BY course_id ) m ) ;