创建表
CREATE TABLE `user` (
`name` varchar(10) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
`sex` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
删除重复数据
DELETE
FROM
`user`
WHERE
(`name`, `age`, `sex`) IN (
SELECT
a.`name`,
a.`age`,
a.`sex`
FROM
(
SELECT
`name`,
`age`,
`sex`
FROM
`user`
GROUP BY
`name`,
`age`,
`sex`
HAVING
count(1) > 1
) a
)
LIMIT 1;