Mysql Delete From Query

Question

How do i delete both image_media_set and media_set table in the below where the count is greater than 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;

MarcioB · Accepted Answer · 2013-01-15 19:54:00Z

1

That is the same than always delete the registry, is it not?

Is the COUNT really necessary?

Try this:

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

edited Jan 15, 2013 at 19:54

answered Jan 15, 2013 at 19:47

MarcioB

1,5681 gold badge9 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matthew Chambers Over a year ago

i need to delete where the count i greater than one

Collectives™ on Stack Overflow

Mysql Delete From Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related