You can't specify target table 'downloads' for update ?
Posted: Thu Jul 29, 2010 11:06 am
in phpmyadmin when i ran this query
it throws this error
actualyy i m deleting duplicate rows based on one column for which i m checking duplicate..i group the results by duplicate column ..then id is the autoincrement key..after that i delete all rows in group except the one that has max id..so logic is correct i think but its not running..
Code: Select all
delete from downloads where id not in (select max(id) from downloads group by downloadlink)Code: Select all
#1093 - You can't specify target table 'downloads' for update in FROM clause