[Solved] MySQL Error: You can't specify target table for update in FROM clause

Last Reply 17 days ago By Mudassar

Posted 20 days ago

Hi!

I want delete duplicate rows in MySql, but its show error. 

delete from mdl_grade_grades WHERE 
itemid in (SELECT itemid FROM mdl_grade_grades 
GROUP by itemid HAVING COUNT(*) > 1) 
AND finalgrade = ''

Error Code: 1093. You can't specify target table 'mdl_grade_grades' for update in FROM clause 0,000 sec

You are viewing reply posted by: Mudassar 17 days ago.
Posted 17 days ago