删除表中多余的重复记录，重复记录是根据单个字段（Id）来判断，只留有id最小的记录

DELETE
FROM
	景点
WHERE
	id IN (
		SELECT
			id
		FROM
			`景点`
		GROUP BY
			`景点名称`
		HAVING
			count(景点名称) > 1
	)
AND id NOT IN (
	SELECT
		min(id)
	FROM
		`景点`
	GROUP BY
		景点名称
	HAVING
		count(景点名称) > 1
)