empty orders woo.sql

DELETE FROM wp_6_woocommerce_order_itemmeta;
DELETE FROM wp_6_woocommerce_order_items;
DELETE FROM wp_6_comments WHERE comment_type = 'order_note';
DELETE FROM wp_6_postmeta WHERE post_id IN ( SELECT ID FROM wp_6_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_6_posts WHERE post_type = 'shop_order';

DELETE FROM wp_7_woocommerce_order_itemmeta;
DELETE FROM wp_7_woocommerce_order_items;
DELETE FROM wp_7_comments WHERE comment_type = 'order_note';
DELETE FROM wp_7_postmeta WHERE post_id IN ( SELECT ID FROM wp_7_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_7_posts WHERE post_type = 'shop_order';

DELETE FROM wp_8_woocommerce_order_itemmeta
DELETE FROM wp_8_woocommerce_order_items
DELETE FROM wp_8_comments WHERE comment_type = 'order_note'
DELETE FROM wp_8_postmeta WHERE post_id IN ( SELECT ID FROM wp_8_posts WHERE post_type = 'shop_order' )
DELETE FROM wp_8_posts WHERE post_type = 'shop_order'