MYSQL #1093 – You can’t specify target table ‘dealer_admin’ for update in FR

目前在寫程式時，在處理MYSQL時遇到一個問題，問題如下

update dealer_admin set is_super_admin=1 where id in (select id from dealer_admin group by dealer_id );

此時會報：#1093 - You can't specify target table 'dealer_admin' for update in FROM clause

在網上找了一個暫時可以解決的方法

create temporary table tmp (id int);
insert into tmp (id) select id from dealer_admin group by dealer_id;
update dealer_admin set is_super_admin=1 where id in (select id from tmp);