Archive for the 'Mysql' Category

Jul 29 2008

How can find duplicate record in mysql?

Published by Root under Mysql

Yeah. It looks simple if there is some unique column, but if not!!! I search answer on web and i found something. [MYSQL] SELECT CONCAT( `firstname` , `lastname` ) as keyac , count( CONCAT( `firstname` , `lastname` ) ) AS numOfRecord FROM users GROUP BY CONCAT( `firstname` , `lastname` ) HAVING ( COUNT( CONCAT( `firstname` [...]

Tags: , ,

No responses yet