首先在phpmyadmin中,打开你wordpress的数据库,点击SQL选项,运行SQL查询。

下面是一次性删除wordpress所有文章的SQL语句:

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

如果想连同分类和标签一同删除,还需要执行下面的语句。

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;

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注