可以找出所有重复记录方便修改

SELECT *
FROM station
WHERE (id IN
          (SELECT station.id
         FROM station,
                   (SELECT MIN(id) AS minid, station_name
                  FROM station
                  GROUP BY station_name) AS table2
         WHERE (station.station_name = table2.station_name) AND
               station.id <> table2.minid))