优艾设计网

SQL?

按理说,应该从 下面的两个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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜