MySQL can’t specify target table for update in FROM clause

 翻译：MySQL不能指定更新的目标表在FROM子句

源SQL语句：

delete from t_official_sys_user
where USER_NAME IN(SELECT USER_NAME FROM t_official_sys_user b group by b.`USER_NAME` having  count(1) > 1)delet