011-多表操作更新记录

多表操作更新记录

1、多表操作修改记录

# 修改张三女朋友的手机号为 13500000000
update boys bo inner join beauty b on bo.id = b.boyfriend_id
set b.phone = '13500000000' where bo.boyName = '张三';

2、多表操作删除记录

# 1）删除张三的女朋友信息
delete b from beauty b inner join boys bo on b.boyfriend_id = bo.id
where bo.boyName = '张三';

# 2）删除李四的信息以及他女朋友的信息
delete b,bo from beauty b inner join boys bo on b.boyfriend_id = bo.id
where bo.boyName = '李四';