优艾设计网

SQL?

优艾设计网 https://www.uibq.com 2023-04-20 10:32 出处:网络 作者:在线设计
按理说,应该从 下面的两个select SQL中取一个得到idx,然后再执行delete from user where idx in (xxx,xxx);即可 但是,我想一次性删除,即不再另外运行一条 delete from语句get的两条语句均可以。但是将里面的sele

按理说,应该从 下面的两个select SQL中取一个得到idx,然后再执行
delete from user where idx in (xxx,xxx);即可

但是,我想一次性删除,即不再另外运行一条 delete from语句

get的两条语句均可以。但是将里面的
select * from
改为 delete from 就不成功了,

delete from user b join (select * from user a where idx in (29,35)) c on (b.source_user = c.source_user and b.target_us优艾设计网_电脑技术er = c.target_user) or (b.source_user = c.target_user and b.target_user = c.source_user);

select a.*from user a join user bon((b.source_user = a.source_user and b.target_user = a.target_user) or (b.source_user = a.target_user and b.target_user = a.source_user))where b.idx in (29,35);

select b.*from user bjoin (select * from user a where idx in (29)) con (b.source_user = c.source_user and b.target_user = c.target_user) or (b.source_user = c.target_user and b.target_user = c.source_user)


0

精彩评论

暂无评论...
验证码 换一张
取 消