J
jwrjnh
Unregistered / Unconfirmed
GUEST, unregistred user!
两个表A,B
A的a字段和B的b字段关联,
能否用一句语句,将表A.a=B.b的记录删除????
A的a字段和B的b字段关联,
能否用一句语句,将表A.a=B.b的记录删除????
M
mawei0913_green
Unregistered / Unconfirmed
GUEST, unregistred user!
用存储过程可以一下删除
J
jwrjnh
Unregistered / Unconfirmed
GUEST, unregistred user!
能详细说说吗?多谢!
L
lxggc
Unregistered / Unconfirmed
GUEST, unregistred user!
delete from a where a.id in
(select a.id from a, b where a.id=b.id)
(select a.id from a, b where a.id=b.id)
L
lxggc
Unregistered / Unconfirmed
GUEST, unregistred user!
或者:
delete from a where exists (select id from b where b.id=a.id)
记得给分
delete from a where exists (select id from b where b.id=a.id)
记得给分
J
jwrjnh
Unregistered / Unconfirmed
GUEST, unregistred user!
感谢lxggc:
问题解决了,分数全给你,多谢啦!
问题解决了,分数全给你,多谢啦!
J
jwrjnh
Unregistered / Unconfirmed
GUEST, unregistred user!
接受答案了.