Mysql 从查询中删除

Question

如何同时删除下面的 image_media_set 和 media_set 表其中计数大于 1。

SELECT media_set.id,
       (SELECT COUNT(*)
        FROM   image_media_set
        WHERE  image_media_set.media_set_id = media_set.id) AS imageCount
FROM   media_set
       INNER JOIN image_media_set
         ON media_set.id = image_media_set.media_set_id
WHERE  image_media_set.image_id = 6405; 

Answer 1

这与总是删除注册表是一样的，不是吗？

COUNT 真的有必要吗？

试试这个:

   DELETE FROM media_set, image_media_set
   WHERE image_media_set.media_set_id = media_set.id
   AND image_media_set.image_id = 6405;