Mysql:从team表中执行一个删除语句，当name 列上有相同时,只保留 ID 这列上值小的

DELETE
FROM team
WHERE id NOT IN
(SELECT a.id
FROM
(SELECT MIN(id) AS id
FROM team
GROUP BY name ) a)