关联删除和关联更新

环境：Mysql7

关联删除

DELETE s from Student s INNER JOIN Teacher t on s.teacherId=t.idINNER JOIN course c on s.courseId=c.idwhere s.id='xiaoming' and c.score='100' and t.id is not null  

关联更新

update  Student s INNER JOIN Teacher t on s.teacherId=t.idINNER JOIN course c on s.courseId=c.idset s.name='小明' and c.sore='30'where s.id='xiaoming' and c.score='100' and t.id is not null 

这里只是简要列出mysql在关联删除和关联更新时的结构，inner join是测试过的，其他关联没测试过，

而且关联更新是可以更新多个表的字段的