Advanced Search

Return to Snippet

Revision: 30973
at September 4, 2010 15:25 by lixonic
Updated Code 
CREATE TABLE new_table as
SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];


DROP TABLE old_table;



RENAME TABLE new_table TO old_table;

Revision: 30972
at August 26, 2010 17:07 by lixonic
Initial Code 
SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];


DROP TABLE old_table;



RENAME TABLE new_table TO old_table;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This is the quick method and painless way to Remove duplicate entries from MySQL

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Remove duplicate entries / rows from mySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL