Mysql:delete statement error can ' t specify target table ' student ' for update in FROM clause

Delete  from   studentwhere not in (Selectmin from Group  by name,stuid,subid,subname,score);

When executing this statement in MySQL, an error occurred: You can ' t specify target table ' student ' for update in FROM clause;

The reason is that the subquery uses the Student table to query, the outer layer of the DELETE statement is also the operation of student, so error.

Workaround:

Wrap the subquery once again:

Delete  from   studentwhere not in (Select* from (Selectminfromgroup  by Name,stuid,subid, Subname,score) a);

Note: This error only occurs in MySQL.

Reference: http://blog.csdn.net/priestmoon/article/details/8016121

Mysql:delete statement error can ' t specify target table ' student ' for update in FROM clause