Mysql 删除重复数据，保留id最小的

DELETE
FROM
	jeepin_xsa_gzh_msg
WHERE
	id IN (
		SELECT
			a.id
		FROM
			(
				SELECT
					id
				FROM
					jeepin_xsa_gzh_msg
				WHERE
					member_id IN (
						SELECT
							member_id
						FROM
							jeepin_xsa_gzh_msg
						GROUP BY
							member_id
						HAVING
							COUNT(1) > 1
					)
				AND id NOT IN (
					SELECT
						MIN(id)
					FROM
						jeepin_xsa_gzh_msg
					GROUP BY
						member_id
					HAVING
						COUNT(1) > 1
				)
			) a
	)