IdrisDose · August 3, 2018 08:28
diff --git a/MySQL-Duplicated-Column-QUICKFIX b/MySQL-Duplicated-Column-QUICKFIX
 -- step 1
 CREATE TABLE source_temp 
 LIKE source;
 
 -- step 2
 INSERT INTO source_temp
 SELECT * 
 FROM source 
 GROUP BY <COLUMN>;
 
 
 -- step 3
 DROP TABLE source;
 ALTER TABLE source_temp 
 RENAME TO source;
	-- step 1
	CREATE TABLE source_temp
	LIKE source;

	-- step 2
	INSERT INTO source_temp
	SELECT *
	FROM source
	GROUP BY <COLUMN>;


	-- step 3
	DROP TABLE source;
	ALTER TABLE source_temp
	RENAME TO source;