关联删除和关联更新
环境:Mysql7
关联删除
DELETE s from Student s
INNER JOIN Teacher t on s.teacherId=t.id
INNER JOIN course c on s.courseId=c.id
where
s.id='xiaoming' and c.score='100'
and t.id is not null
关联更新
update Student s
INNER JOIN Teacher t on s.teacherId=t.id
INNER JOIN course c on s.courseId=c.id
set s.name='小明' and c.sore='30'
where
s.id='xiaoming' and c.score='100'
and t.id is not null
这里只是简要列出mysql在关联删除和关联更新时的结构,inner join是测试过的,其他关联没测试过,
而且关联更新是可以更新多个表的字段的
还没有评论,来说两句吧...