1093 – You can’t specify target table ‘table’ for update in FROM clause

The general meaning is that you can’t select some values in the table first, and then update the table (in the same statement)

 
A temporary table can be introduced for operation

delete from push_ plans WHERE id in  
(
     select id from  
     (
         select id from push_ plans WHERE   area_ id = 0
         
     ) as t
)  
 


Read More: