MySQL #1093-you can't specify target table 'sale _ admin' for update in FR

Currently writingProgramWhen dealing with MySQL, the problem is as follows:

 
UpdateDealer_adminSetIs_super_admin=1 WhereIDIn(SelectIDFromDealer_adminGroup ByDealer_id );
 

In this case, the following message is reported: #1093-you can't specify target table 'sale _ admin' for update in from clause.

I found a temporary solution on the Internet.

 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 );