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

不行

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

可以 套一层

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