#1093 - You can't specify target table 'tablename' for update in FROM clause 解决办法

           #1093 - You can't specify target table 'tablename' for update in FROM clause

          因为在MYSQL里，不能先select一个表的记录，在按此条件进行更新和删除同一个表的记录，解决办法是，将select得到的结果，再通过中间表select一遍。

         原来想执行的语句为：DELETE FROM tablename WHERE id not in (select MAX(id) from tablename group by username having count(*)>1)；在mysql下报错。

         修改后的语句为：DELETE FROM tablename WHERE id NOT IN (SELECT id FROM (select MAX(id) as id from tablename group by username having count(*)>1) temp1); 在mysql下执行成功。