UPDATE tbl_taskfilling_student a JOIN
(SELECT userId,classes FROM tbl_taskfilling_student WHERE taskFillingId=166) b ON a.userId=b.userId
SET a.classes=b.classes
WHERE a.taskFillingId=172
或者
数据库版本过高时最好使用该方式:
UPDATE tbl_users
SET CODE=username WHERE id=id AND id>5343 AND id<5348