where id in (select * from music) subquery NoPlan select count(*) from user where name = 'foo' 多⽚片聚合 NoPlan insert into user(id) values (1), (2) 多⾏行插⼊入 NoPlan update user set val = 1 更新多⽚片 NoPlan update