1、第一步查询重复的数据
SELECT
SHIP_ID,
COUNT( SHIP_ID )
FROM
‘表名’
GROUP BY
SHIP_ID
HAVING
COUNT( SHIP_ID ) > 1;
2、删除重复数据
DELETE t1
FROM
‘表名’t1
INNER JOIN ‘表名’ t2
WHERE
t1.id < t2.id
AND t1.SHIP_ID = t2.SHIP_ID;