Mysql删除重复数据只保留一条

Question

Mysql删除重复数据只保留一条，我的sql这样的
DELETE from t_patient WHERE pa_iid IN (select pa_iid from t_patient group by pa_vname having count(pa_vname)>1)
但是报错了：
[Err] 1093 - You can't specify target table 't_patient' for update in FROM clause
求大神，怎么解决

Answer 1

参考下这个：http://blog.csdn.net/softwave/article/details/3890576