You can’t specify target table ‘caiji_data_meiwen’

mysql 中不能自己 引用本身 要再加一层

不行

DELETE from `caiji_data_meiwen` where id not in (select id FROM `caiji_data_meiwen` a where 域名 like ‘%美文%’ )

可以 套一层

DELETE from `caiji_data_meiwen` where id not in ( select id from ((select id FROM `caiji_data_meiwen` a where 域名 like ‘%美文%’ )) b)