delete not working
Posted: Tue Aug 03, 2010 1:40 am
what i have done is that i copied the duplicate rows(each row only once) from original table to new table and executed this after previous action
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
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