Advanced Search

Return to Snippet

Revision: 47028
at May 30, 2011 19:30 by beat
Initial Code 
SELECT p1.id,p1.cod , p2.id,p2.cod #here we find the duplicate data from cod column, but i need the ID to show ...
FROM `st_produse` p1 #the table, first time 
LEFT JOIN st_produse p2 ON p1.cod = p2.cod #the table second time
WHERE p1.id <> p2.id #here put the key or a unique column
GROUP BY p1.cod #the column in case, first time
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Look for duplicate rows, in the same table, by a different column (not primary or unique).

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Mysql Duplicate rows - same table - not primary col

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL