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'