lastday154 · November 22, 2017 08:30
diff --git a/duplicate.sql b/duplicate.sql
 // delete With temp table

 CREATE TABLE temp_users AS
 SELECT * FROM users GROUP BY user_name;

 DROP TABLE users;
 RENAME TABLE temp_users TO users;

 // delete and keep lower id
 DELETE u1 FROM users u1, users u2
 WHERE u1.user_name = u2.user_name
 AND u1.id > u2.id;
	// delete With temp table

	CREATE TABLE temp_users AS
	SELECT * FROM users GROUP BY user_name;

	DROP TABLE users;
	RENAME TABLE temp_users TO users;

	// delete and keep lower id
	DELETE u1 FROM users u1, users u2
	WHERE u1.user_name = u2.user_name
	AND u1.id > u2.id;
No results found