Answers for "mysql delete duplicate rows leave"

SQL
2

how to delete all duplicate items in mysql

DELETE FROM FriendsData WHERE fID 
       NOT IN ( SELECT fID FROM FriendsData 
                   GROUP BY UserID, FriendsUserID, IsSpecial, CreatedBy)
Posted by: Guest on April-17-2020
0

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;
Posted by: Guest on August-17-2020

Code answers related to "mysql delete duplicate rows leave"

Code answers related to "SQL"

Browse Popular Code Answers by Language