Answers for "mysql remove dupicates from table"

SQL
1

mysql delete duplicate rows but keep one

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;
Posted by: Guest on February-04-2021
0

mysql delete duplicate rows

DELETE FROM table_name 
WHERE 
	id IN (
	SELECT 
		id 
	FROM (
		SELECT 
			id,
			ROW_NUMBER() OVER (
				PARTITION BY field_1
				ORDER BY field_1) AS row_num
		FROM 
			table_name
		
	) t
    WHERE row_num > 1
);
Posted by: Guest on August-02-2020

Code answers related to "mysql remove dupicates from table"

Code answers related to "SQL"

Browse Popular Code Answers by Language