原来SQL:
DELETE FROM table WHERE id not in(
SELECT id from table GROUP BY size
)
修改后SQL:
DELETE FROM table WHERE id not in(
SELECT resultset.id FROM
(SELECT id from table GROUP BY size) resultset
)
原因分析:
MySQL 修改或者删除数据时候不能以当前表作为 from 条件。