update和left join连用(多表关联更新)

原文链接：这里这里!

参考下面：

update student s
left join class c
on 
d.index_id = c.id
set d.number =0,d.age=0
WHERE c.type='all'