mySQL: delete 語句報錯 You can't specify target table 'student' for update in FROM clause

標籤：sele   style   core   col   rom   語句   from   code   where   

delete from  studentwhere id NOT in (select min(id) id from student group by name,stuid,subid,subname,score);

當在mysql中執行這條語句時，報錯：You can‘t specify target table ‘student‘ for update in FROM clause；

原因是子查詢中使用student表進行查詢，而外層的delete語句也是對student進行的操作，因此報錯。

解決辦法：

將子查詢再封裝一次：

delete from  studentwhere id NOT in (select * from (select min(id) id from student group by name,stuid,subid,subname,score)a);

注意：這種錯誤只出現在mySQL中。

參考：http://blog.csdn.net/priestmoon/article/details/8016121

mySQL: delete 語句報錯 You can't specify target table 'student' for update in FROM clause