php - 如果在两个表中都没有出现，则删除一行(删除孤立的行)

Question

我想删除 banners 中的任何行，如果它在 banners_pp 中没有相应的行

如何处理 {doesn't exist} 部分？

DELETE banners.* FROM banners
LEFT JOIN banners_pp
USING(banner_id)
WHERE banners_pp.banner_id {doesn't exist}

Answer 1

DELETE FROM banners
WHERE NOT EXISTS (
    SELECT *
    FROM banners_pp
    WHERE banner_id  = banners.banner_id 
)

参见 more详情