[TOC] # union 注意union默認會去重,`union all`可以包含重復 # update可以修改多表 ~~~ update boys bo inner join beauty b on bo.`id` = b.`boyfriend_id` set b.`phone` = '113' where bo.`boyName`='jack'; ~~~ # delete刪除多表 delete后面跟你要刪除表的別名,寫那個就刪那個符合條件的行 ~~~ delete 表1的別名,表2的別名 from 表1 別名, 表2 別名 where 連接條件 and 篩選條件; ~~~ # inset后跟select ~~~ insert into beauty(id, name, phone) select 26, 'jack', '113'; ~~~