参考下面:

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