Advertisement
Fany_VanDaal

Vymazání informací o datech obrázků z DB

Jun 1st, 2019
174
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None
  1. # vymazání dat obrázků z db
  2. DELETE FROM `wp_posts` WHERE `post_type` = "attachment";
  3. DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attached_file";
  4. DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attachment_metadata";
  5.  
  6. # vymázání dat obrázků z woocommerce
  7. DELETE FROM `wp_postmeta` WHERE `meta_key` = "_thumbnail_id";
  8. UPDATE `wp_postmeta` SET `meta_value` = NULL WHERE `meta_key` = "_product_image_gallery";
Advertisement
RAW Paste Data Copied
Advertisement