Answers for "delete duplicates from mysql in which multiple records are same"

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

Code answers related to "delete duplicates from mysql in which multiple records are same"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "delete duplicates from mysql in which multiple records are same"

Code answers related to "delete duplicates from mysql in which multiple records are same"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "delete duplicates from mysql in which multiple records are same"

Code answers related to "delete duplicates from mysql in which multiple records are same"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us