[Solved] remove duplicate records – mysql

by


for remove duplicate records, use this query

DELETE
    n1
FROM
    news n1,
    news n2
WHERE
    n1.id < n2.id
AND n1.itemId = n2.itemId
AND n1.tag_id = n2.tag_id
AND n1.tag_id IS NOT NULL

solved remove duplicate records – mysql