A blog about LAMP(LINUX,APACHE, MYSQL,PHP),Performance and general web application development.
Monday, January 7, 2013
MySql Delete duplicate entry by single SQL
The Following Sql helps to remove duplicate entry from mysql table.
FROM TABLE T1
JOIN TABLE T2 ON (T2.value = T1.value ) AND
T2.TABLE_ID > T1.TABLE_ID);
Nikhil S Punalur
Share to Twitter
Share to Facebook
Share to Pinterest
Post Comments (Atom)