MYSQL 删除同一表中重复记录

MYSQL 删除同一表中重复记录
CREATE TABLE `user` (
  `db_id` varchar(255) NOT NULL,
  `name` varchar(45) default NULL,
  `age` int(10) unsigned NOT NULL,
  `address` varchar(45) default NULL,
  PRIMARY KEY  (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     
// 保留相同age中name比较最大的记录
delete users as a from users as a,
(
   select age,max(name) as mName from users group by age
) as b
 where a.age = b.age and a.name <> b.mName;
作为MYSQL 初学者，欢迎拍砖！
^_^