WordPress bulk delete all articles at once

WordPress Bulk Delete Articles

existWordPressHow to delete all articles in batches? There are several ways to delete all articles. One is to reinstall WordPress, which will completely delete all the articles.PluginsYou need to re-download and re-set, which is troublesome. Another way is toWordPress InstallationAfter the settings are completed, install an UpdraftPlus backup plug-in to back up the configured WordPress. When you need to restore it, you can restore it with one click.

However, many people who are new to WordPress do not have a backup plan.database, and I don't want to reinstall WordPress, so how can I delete previously published articles in batches? If the number is small, I can delete it manually in the background. If there are tens of thousands of them, how can I delete them all at once?

Here we will teach you how to use SQL statements for batch deletion.

First inphpmyadmin, open your wordpress database, click the SQL option, and run the SQL query.

The following is the SQL statement to delete all WordPress articles at once:

delete from wp_posts where ID >= 1;
delete from wp_postmeta where meta_id >= 1;

If you want to delete the categories and tags together, you also need to execute the following statement.

delete from wp_term_relationships where object_id >= 1;
delete from wp_term_taxonomy where term_id >= 1;
delete from wp_terms where term_id >= 1;
delete from wp_termmeta where meta_id >= 1;