Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to delete duplicate entries in a column in mysql

# Please write a DELETE statement and DO NOT write a SELECT statement.
# Write your MySQL query statement below
DELETE c1 FROM Person c1
INNER JOIN Person c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;

#delete duplicate emails from table Person
Source by www.mysqltutorial.org #
 
PREVIOUS NEXT
Tagged: #delete #duplicate #entries #column #mysql
ADD COMMENT
Topic
Name
7+2 =