{"id":5318,"date":"2024-03-14T02:41:45","date_gmt":"2024-03-14T02:41:45","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/"},"modified":"2025-08-01T13:30:14","modified_gmt":"2025-08-01T13:30:14","slug":"how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/","title":{"rendered":"Remove Duplicate MySQL Data: Keep One Record"},"content":{"rendered":"

To search for duplicate data and keep only one unique record, you can follow the steps below:<\/p>\n

    \n
  1. Use the GROUP BY clause and aggregate functions to identify duplicate data and only retain one record.<\/li>\n
  2. Filter out duplicate records using the HAVING clause.<\/li>\n
  3. Use subqueries or temporary tables to store duplicate records, and then delete these duplicate records using primary keys or unique indexes.<\/li>\n<\/ol>\n

    Here is an example SQL query to remove duplicate data and keep only one record:<\/p>\n

    SELECT<\/span> MIN<\/span>(id), column1, column2, column3\r\nFROM<\/span> your_table\r\nGROUP<\/span> BY<\/span> column1, column2, column3\r\nHAVING<\/span> COUNT<\/span>(*<\/span>) ><\/span> 1<\/span>;\r\n<\/code><\/pre>\n
    In the example above, assuming your_table is a table with duplicate data, where column1, column2, and column3 are the duplicate columns, this SQL statement will return the minimum id value for each group of duplicate data and keep one unique record.<\/p>\n
    You can also insert the query results into a temporary table, remove duplicate data from the original table, and then reinsert the data from the temporary table back into the original table. This can achieve the effect of deleting duplicate data and keeping only one record.<\/p>\n","protected":false},"excerpt":{"rendered":"
    To search for duplicate data and keep only one unique record, you can follow the steps below: Use the GROUP BY clause and aggregate functions to identify duplicate data and only retain one record. Filter out duplicate records using the HAVING clause. Use subqueries or temporary tables to store duplicate records, and then delete these […]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[775,494,870,298,1034],"class_list":["post-5318","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-data-cleaning","tag-database-optimization","tag-duplicate-data","tag-mysql","tag-sql-query"],"yoast_head":"\nRemove Duplicate MySQL Data: Keep One Record - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove Duplicate MySQL Data: Keep One Record\" \/>\n<meta property=\"og:description\" content=\"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T02:41:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-01T13:30:14+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Remove Duplicate MySQL Data: Keep One Record\",\"datePublished\":\"2024-03-14T02:41:45+00:00\",\"dateModified\":\"2025-08-01T13:30:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\"},\"wordCount\":173,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"data cleaning\",\"database optimization\",\"duplicate data\",\"MySQL\",\"SQL query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\",\"name\":\"Remove Duplicate MySQL Data: Keep One Record - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T02:41:45+00:00\",\"dateModified\":\"2025-08-01T13:30:14+00:00\",\"description\":\"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove Duplicate MySQL Data: Keep One Record\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Remove Duplicate MySQL Data: Keep One Record - Blog - Silicon Cloud","description":"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/","og_locale":"en_US","og_type":"article","og_title":"Remove Duplicate MySQL Data: Keep One Record","og_description":"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T02:41:45+00:00","article_modified_time":"2025-08-01T13:30:14+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Remove Duplicate MySQL Data: Keep One Record","datePublished":"2024-03-14T02:41:45+00:00","dateModified":"2025-08-01T13:30:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/"},"wordCount":173,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["data cleaning","database optimization","duplicate data","MySQL","SQL query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/","name":"Remove Duplicate MySQL Data: Keep One Record - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T02:41:45+00:00","dateModified":"2025-08-01T13:30:14+00:00","description":"Learn how to remove duplicate MySQL data while keeping one record using SQL queries. Step-by-step guide included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-implement-a-mysql-query-to-remove-duplicate-data-and-keep-only-one-record\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Remove Duplicate MySQL Data: Keep One Record"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/5318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=5318"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/5318\/revisions"}],"predecessor-version":[{"id":150061,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/5318\/revisions\/150061"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=5318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=5318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=5318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}