MySQL delete duplicate data SQL declaration

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 have COUNT (*) > 1) and ID not in (SELECT MIN (ID) from Get_review_url GR OUP by No,title,name,content have COUNT (*) >1);D elete from Get_review_url WHERE ID in (SELECT ID from tmp);D ROP TABLE tmp

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

MySQL delete duplicate data SQL declaration