Query-1:
UPDATE
wp_wc_product_meta_lookup
SET
min_price =(min_price - min_price * .13)
WHERE 1;
Query-2;
UPDATE
wp_wc_product_meta_lookup
SET
max_price =(max_price - max_price * .13)
WHERE 1;
-- Disable foreign key checks (important for InnoDB) SET FOREIGN_KEY_CHECKS = 0; -- Delete product meta DELETE pm FROM wp_p...
No comments:
Post a Comment