DELETE
FROM
test_product_attribute
WHERE
1 = 1
AND product_uid = '95edeae295424008bbc26f95e5d82e9e'
AND id NOT IN (
SELECT
min( id ) AS id
FROM
test_product_attribute
WHERE
product_uid = '95edeae295424008bbc26f95e5d82e9e'
GROUP BY
column_name
)
mysql删除出现次数大于1的数据
于 2022-09-21 16:23:36 首次发布