How to find duplicate rows in different table

Question

My Problem: I have got two MySQL tables. One table is called txns and another table is called archived_txns. Both of the tables has same columns. I use archived_txns to move data from txns using a PHP script.

I want to know how can I find out and delete the duplicate rows within these two tables. I am adding the Table structure for better reference.

This is the archived_txns table

This is the txns table

As stated in this example, I want to find out and delete the row with ID 3 from the txns table.

Please define "duplicate rows". Which column values must be equal? — Paul Spiegel, Aug 31 '19 at 17:20
https://stackoverflow.com/questions/1590799/delete-all-rows-in-a-table-based-on-another-table — Paul Spiegel, Aug 31 '19 at 17:30
@PaulSpiegel The Column Values for "id" must be equal in this case. — Souvik, Aug 31 '19 at 19:00

score 1 · Accepted Answer · answered Aug 31 '19 at 17:08

1

You can delete it using JOIN

DELETE t 
FROM txns t
JOIN archived_txns a ON t.id = a.id

answered Aug 31 '19 at 17:08

Samir Selia

7,007
2
11
30

How to find duplicate rows in different table

1 Answers1