Breaking News: Grepper is joining You.com. Read the official announcement!

mysql delete older duplicates

Add Answer

Powerful Penguin answered on June 18, 2020 Popularity 8/10 Helpfulness 3/10

answer mysql delete older duplicates

related mysql remove duplicates

related mysql delete older duplicates

related delete all duplicate rows keep the latest except for one in mysql

related Remove duplicate old value in mysql

related mysql delete duplicate rows except one

related mysql remove duplicates

mysql delete older duplicates

Comment

 delete test
   from test
  inner join (
     select max(id) as lastId, email
       from test
      group by email
     having count(*) > 1) duplic on duplic.email = test.email
  where test.id < duplic.lastId;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Aug 17 2020

Powerful Penguin

0 Answers Avg Quality 2/10

Closely Related Answers

mysql remove duplicates

Comment

DELETE c1 FROM tablename c1
INNER JOIN tablename c2 
WHERE
    c1.id > c2.id AND 
    c1.unique_field = c2.unique_field;

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Jun 18 2020

Matteoweb

0 Answers Avg Quality 2/10

mysql remove duplicates

Comment

DELETE t1 FROM subscriptions t1
INNER JOIN subscriptions t2 
WHERE 
    t1.id < t2.id AND 
    t1.user_id = t2.user_id AND t1.name = t2.name

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Jun 18 2021

adeleyeayodeji

0 Answers Avg Quality 2/10

mysql delete older duplicates

Comment

DELETE FROM CONTACTS
WHERE ID NOT IN
      (SELECT *
       FROM (SELECT max(ID)		
             FROM CONTACTS
             GROUP BY EMAIL) t);
 -- ⇓ Test it ⇓ (Fiddle source link)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: sqlfiddle.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 13 2021

VasteMonde

0 Answers Avg Quality 2/10

delete all duplicate rows keep the latest except for one in mysql

Comment

DELETE 
FROM
  `tbl_job_title` 
WHERE id NOT IN 
  (SELECT 
    * 
  FROM
    (SELECT 
      MAX(id) 
    FROM
      `tbl_job_title` 
    GROUP BY NAME) tbl)

Popularity 9/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: except ex

Link to this answer
Share Copy Link

Contributed on Apr 26 2021

Hurt Hamster

0 Answers Avg Quality 2/10

Remove duplicate old value in mysql

Comment

DELETE `yellow_page_content`
   from `yellow_page_content`
  inner join (
     select max(`id`) as lastId, `code`
       from `yellow_page_content`
      group by `code`
     having count(*) > 1) duplic on duplic.code = yellow_page_content.code
  where yellow_page_content.id < duplic.lastId;

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Feb 01 2022

Blue-eyed Bison

0 Answers Avg Quality 2/10

mysql delete duplicate rows except one

Comment

-1

DELETE FROM NAMES
 WHERE id NOT IN (SELECT * 
                    FROM (SELECT MIN(n.id)
                            FROM NAMES n
                        GROUP BY n.name) x)

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: except ex

Link to this answer
Share Copy Link

Contributed on Jul 18 2020

masterDev

0 Answers Avg Quality 2/10

mysql remove duplicates

Comment

-1

DELETE t1 FROM contacts t1
INNER JOIN contacts t2 
WHERE 
    t1.id < t2.id AND 
    t1.email = t2.email;Code language: SQL (Structured Query Language) (sql)

Popularity 10/10 Helpfulness 1/10 Language sql

Source: www.mysqltutorial.org

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Feb 11 2021

Alberto Peripolli

0 Answers Avg Quality 2/10

mysql delete older duplicates

Contents

More Related Answers

mysql delete older duplicates

Closely Related Answers

mysql remove duplicates

mysql remove duplicates

mysql delete older duplicates

delete all duplicate rows keep the latest except for one in mysql

Remove duplicate old value in mysql

mysql delete duplicate rows except one

mysql remove duplicates

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.