You can't specify target table 'marketing_setting' for update in FROM clause

MySql中不能在delete语句中使用select语句（同一张表），所以下面的sql会报错

DELETE FROM table_name WHERE id IN (SELECT_SQL)

解决办法：

CREATE TABLE tmp_table_name AS SELECT_SQL;--创建一张临时表

DELETE FROM tabla_name WHERE id IN (SELECT id FROM tmp_table_name );--删除数据

DROP TABLE tmp_table_name ;--删除临时表