Delete Duplicate postmeta in woocommerce by sql command.

delete_duplicate_wp_postmeta.sql

create temporary table tmpTable (meta_id  bigint);

Insert into tmpTable (meta_id)

select  meta_id
from    wp_postmeta pt
where   exists
        (
        select  *
        from    wp_postmeta pt2
        where   pt2.post_id= pt.post_id
                and pt2.meta_key= pt.meta_key
                and pt2.meta_value= pt.meta_value
        );

DELETE FROM wp_postmeta USING wp_postmeta, tmpTable WHERE wp_postmeta.meta_id=tmpTable.meta_id


-- Method 2
create temporary table tmpTable (meta_id bigint);

Insert into tmpTable (meta_id)

SELECT meta_id
FROM wp_postmeta 
GROUP BY post_id,meta_key,meta_value
HAVING COUNT(*) > 1;


DELETE FROM wp_postmeta USING wp_postmeta , tmpTable WHERE wp_postmeta.meta_id=tmpTable.meta_id