How to bulk delete in wordpress posts, pages, Media Images, tags and categories

bulk delete wordpress media Images  from database

go to phpmyadmin and locate your database run sql query below by click sql paste this code one by one.

1. # First:
3. DELETE FROM wp_postmeta
4. WHERE post_id IN
5. (
6. SELECT id
7. FROM wp_posts
8. WHERE post_type = ‘attachment’
9. )
10. ;
12. # Second:
14. DELETE FROM wp_posts WHERE post_type = ‘attachment’

How to delete only Unattached wordpress mediafiles?

 Really I don’t Know How to identify Unattached and attached media.
These Media attachments are like post or pages. so

How i deleted unattached media files in from wordpress database?

1. DELETE FROM wp_posts WHERE post_type = ‘attachment’

How to bulk delete posts,pages, tags in wordpress?

DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;