Remove duplicates

Posted on February 28, 2018, 12:49 pm, by admin, under mysql.
DELETE
FROM main_table USING main_table,
    main_table e1
WHERE main_table.id > e1.id
    AND main_table.entity_id = e1.entity_id;
Comment (RSS)  |  Trackback

Leave a Reply

«
»