Скачать или смотреть How to Delete All Trashed Posts & Comments in WordPress Database using phpMyAdmin

In this wordpress tutorial for beginners you will learn how to remove unused data from wordpress database using mysql query in phpmyadmin. So you can removed all post and page and comment at same time or once by using sql query. So you can optimize your database table using this step.

** in query add your database prefix.

-------------------------

1- Remove Trash Post
Run SQL Query: Click on the "SQL" tab in phpMyAdmin and run the following query to delete all trashed posts:

DELETE FROM wp_posts WHERE post_status = 'trash';

---------------------

2- Remove Trash Comment
Run SQL Query: Click on the "SQL" tab in phpMyAdmin and run the following query to delete all trashed comments:

DELETE FROM wp_comments WHERE comment_approved = 'trash';

---------------------

Replace wp_ with your table prefix if it’s different.

#database #trash #comment #post #trashed #optimize #table #data #query #sql #mysql #phpmyadmin #website #wordpress #wordpresstutorial #webtaskwithhassan #hassangilani