mysql 重複資料刪除資料sql聲明

標籤：

CREATE TABLE tmp AS SELECT id FROM get_review_url  WHERE (no,title,name,content) IN (SELECT no,title,name,content FROM get_review_url GROUP BY no,title,name,content HAVING COUNT(*) > 1) AND id NOT IN (SELECT MIN(id) FROM get_review_url GROUP BY no,title,name,content HAVING COUNT(*)>1);DELETE FROM get_review_url WHERE id IN (SELECT id FROM tmp);DROP TABLE tmp;

著作權聲明：本文部落格原創文章。部落格，未經同意，不得轉載。

mysql 重複資料刪除資料sql聲明