MySQL Query – Delete all WooCommerce Bookings

If you need to delete all WooCommerce booking with the custom post type wc_booking you can use the MySQL query below:

DELETE FROM wpstg4_postmeta WHERE post_id IN ( SELECT ID FROM wpstg4_posts WHERE post_type = 'wc_booking' );
DELETE FROM wpstg4_posts WHERE post_type = 'wc_booking';