Skip to content

Instantly share code, notes, and snippets.

@nczz

nczz/delete_wc_products_and_meta.sql

Created April 13, 2017 07:29
Show Gist options
  • Save nczz/2d0278eea2ad031bc3f4ed9f3a7c605d to your computer and use it in GitHub Desktop.
Save nczz/2d0278eea2ad031bc3f4ed9f3a7c605d to your computer and use it in GitHub Desktop.
Download ZIP
從資料庫批次刪除 WooCommerce 商品資訊
Raw
delete_wc_products_and_meta.sql
DELETE wp_posts,wp_postmeta
FROM wp_posts
INNER JOIN wp_postmeta ON wp_posts.ID=wp_postmeta.post_id
WHERE wp_posts.post_type LIKE 'product';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment