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:

• You can’t specify target table ‘car’ for update in from clause
• Errors in IntelliJ ieeasql statements and table names in @ table
• DB2 encountered the problem of sqlcode = 911 lock table when updating record update
• Insert into / delete / update / select of SQL Server database table
• Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
• Error 1146 (42s02): table ‘database name. Table name’ doesn’t exist ‘
• (element UI component table) how to add a style to a table
• An error occurred when opensips started the service“ ERROR:core :db_ check_ table_ Version: invalid version 7 for Table dialog found “
• Mysql error when deleting the table structure: Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails
• MySQL partitions the existing tables of the data table
• DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
• About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
• New fields in hive table and modification of field comments
• Error 1051 (42s02): unknown table ‘…’
• In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
• Oracle quick replacement undo table space method
• 1072 – Key column ‘xxx_id’ doesn’t exist in table
• DB2 table annotation pull
• Django. DB. Utils. Programmingerror: (1146, “table * doesn’t exist”) causes and Solutions
• Lua — using remove to delete table data