You can delete all post via $wpdb
DELETE FROM wp_posts WHERE post_type="post_type";
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);
DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts)
or use this query replace it with {{your CPT}} with your Custom Post Type
DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b
ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c
ON (a.ID = c.post_id)
WHERE a.post_type="{{your CPT}}";
Related Posts:
- Most efficient way of deleting post
- WordPress Admin Page Slow. Customer Post Type is the slowest
- Should I use custom post types or a custom database tables for plugin development?
- Custom Post Types, or completely custom?
- WordPress Custom Post Type Admin Page really slow
- Custom Post Type with Input fields to seperate table on database.
- Right way of storing large number of custom post fields
- How to use custom database tables for custom post types?
- How often do you need to register_post_type?
- Custom Post Type or Custom Tables
- Create Pages from Database
- Use Custom Database with Custom Post Type
- Custom Search | Wrong output & question
- How do I write this SQL statement for Posts written in last 24 hours?
- Save or update data when custom post published
- Custom post type Vs. data in own table
- Save custom post type in different table
- Is there any performance consideration when using Custom Post Types?
- How to use custom post type APIs, but use a different db table
- Developing WordPress on Kubernetes
- Recommended custom post type structure for TV Schedule site?
- Filtering by Post Meta Custom Fields – Performance
- WordPress post count not showing for custom post type author
- Where to store custom tagging data associated with a custom post type
- wpdb custom post_type problem
- Adding custom tables to WordPress
- WP All Import – Using Xpath to set a select value
- Getting a PHP Notice when using Pods with WPML [closed]
- Custom Post Types. Are there any disadvantages/advantages in using a plugin to develop them?
- How to use custom taxonomies to reference complex relationships?
- Create a clone from one WordPress site to another in a few minutes
- Database to page routing API?
- Are pages consuming more server resources than posts?
- Side effects of Script and Iframe in post
- Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
- Add update or delete database records using custom post type
- Terms showing up in object cache on unrelated pages
- WP_Query orderby and tax_query
- Importing Data from a Non-WordPress database, into WP
- How to organise this data within WordPress
- Organize WordPress site, so it can maintain with huge database
- Save custom post type to external database
- Show data from one Custom Post Type in another Custom Post Type
- Specifying meta field’s column type in Database using add_post_meta
- Replace dynamically content in a custom database table when a custom post is created
- Running a song lyrics site on WordPress
- Save and user submitted data from a form and display them in the wp backend
- Should I use custom taxonomies or not?
- Designing a custom post type with a minimum number of meta fields
- Allow front end users to add data to a custom post type
- WordPress hook which triggers on post import
- Update all published posts at once
- Entity to store contact form entries?
- Ideas to connect external database table to wordpress posts as custom field source
- Database alteration: users who voted
- WordPress as a frontend website for iOS app [closed]
- delete duplicate meta_value with same post_id
- custom post type: own database table structure and custom “new-post” interface
- Import External XML
- Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
- How do you make relational post types in WordPress? [duplicate]
- Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
- Does this archive template part look like its making too many calls to the db?
- Right way to store a large set of similar information on website? [duplicate]
- custom post types, custom fields and normalization
- Custom post type and custom taxonomy key lenght & query performance
- How select query is generated in a Custom Post Type?
- Simple way to hide\show an announcement (just a div) on homepage?
- dynamic vue widget inside custom post
- Why is this function so slow?
- Create 3 Levels of relations with WordPress
- Exporting Post type from one theme and importing it to another theme
- Cache the registration of a custom post type?
- custom data model – link and populate from admin backend
- How to store additional data that is related to core data
- is using “require_once” in wordpress theme affect the speed ???
- Event Manager: Events Deleted are still in DB as published but hidden in admin
- Changing an item in drop down after 5 latest posts per taxonomy
- Populate custom post type/custom fields from an external database
- Limit Number of Custom Post Type Dashboard
- Automatically convert standard posts with custom fields to custom post types
- In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
- How to enable the user to add value through the admin panel?
- Shared Custom post type between WP network sites
- Custom Post Types and Posts are mixed
- Pulling Content from Existing Database
- Custom Post Type vs Shortcode: Which one is more performant?
- Displaying database table in backend of wordpress
- custom post type for custom talbe
- Check in function on custom page
- Problem with menu categories doubling up when updating database?
- Inserting into WP DB
- Save number of Facebook likes to database
- WordPress and Unity high scores table
- Switched server & domain name, now custom post types won’t save
- custom post types containing a collection of items
- Why WordPress does not Use Separate Table for Post Types (When Registring)?
- Remote database access on another wordpress site’s custom post type
- What would be the optimal CPT / Taxonomy design for the following entities structure
- Should I save user cookie consent in a custom post type or make a custom database table?