To delete duplicate row from table execute this query.
Where autoId is auto increment id.
DELETE FROM MyTable WHERE AUTOID NOT IN
(SELECT MIN(AUTOID)
FROM MyTable GROUP BY col1,col2)
Where autoId is auto increment id.
No comments:
Post a Comment