sql - 我有一个 SQL 删除查询

Question

有 2 个表:report(它有一个主键 reportId 和一个名为 migrated 的位字段)和 report_detail(它有一个外键 reportId)。我想从 report_detail 中删除所有具有 reportId 的行，该 reportId 在报告表中已迁移 = 1。这是选择查询，用于选择我想要的所有行:

select * 
from report r inner join report_detail d 
    on r.reportId = d.reportId 
where migrated = 1

这个删除查询会执行我想要的操作还是我做错了什么？

delete from report_detail
where exists(
    select * 
    from report r inner join report_detail d 
        on r.reportId = d.reportId 
    where migrated = 1
)

Answer 1

DELETE FROM report_detail
WHERE 
    report_detail.reportId IN
    (
        SELECT reportId 
        FROM report 
        WHERE migrated = 1
    )