mysql keep newest duplicate code example

Example 1: mysql remove duplicates

DELETE FROM table_name WHERE id 
       NOT IN ( SELECT id FROM table_name 
                   GROUP BY field_1, field_2)

Example 2: mysql delete older duplicates

delete test
   from test
  inner join (
     select max(id) as lastId, email
       from test
      group by email
     having count(*) > 1) duplic on duplic.email = test.email
  where test.id < duplic.lastId;

Tags:

Sql Example

Related