Question

我可以使用

select * from sent_txts s 
LEFT JOIN received_txts r ON s.msg_link_id = r.id 
WHERE r.action_id = 6;

最高选择配对器,

我怎么能写一问,删除双方的对等之行?

类似于

delete sent_txts s 
LEFT JOIN received_txts r ON s.msg_link_id = r.id 
WHERE r.action_id = 6;

Answer 1

申斥: 我目前无法利用我的仪表数据库进行测试,但我认为你可以使用:

delete s, r from send_txts s left join received_txts r on s.msg_link_id = r.id where r.action_id = 6;

Answer 2

我个人更喜欢美国的条款,但先前的答复同样有效。我对研究如何使用外国关键制约因素的建议提出二,这为实现这一目标提供了更有效的途径。

DELETE FROM s, r USING sent_txts s LEFT JOIN received_txts r ON s.msg_link_id = r.id WHERE r.action_id = 6;