参考下例,查询的同时也进行了更新
UPDATE resource r JOIN
(SELECT photo FROM customer ORDER BY id DESC LIMIT 370000,10000) c
SET r.create_time='2099-12-31 00:00:03' WHERE r.innerid=c.photo