MySQL重複データの削除

MySQL重複データの削除

背景を求める

二SQL

背景を求める

           ,        。
     t_table,    id，     filed_name1, 
            ，               

二SQL

DELETE FROM t_table
WHERE filed_name1 = "      "
	AND id NOT in(
		SELECT
			temp.max_id FROM (
				SELECT
					max(id) AS max_id FROM t_table
				WHERE
					filed_name1 = "      "
				GROUP BY
					filed_name1) temp)