Mysql删除重复数据一直不成功

Mysql重复数据删除不成功。简介:sql语句:Mysql >:delete from log in table where username in(select *，count(username)as a from log in table