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'