Code: Select all
delete from downloads where link in (select link from down)downloads is original table and down the table that contain single copy of duplicates rows and link is the field that is duplicated..but once i execute this in phpmyadmin it keeps runnniing and dont stop..so actually its not working or may be the table has 150 thoousand records it may b taking time..after thsi all i will do is copy back dulicate rows from down to downloads...any idea why delete is not working