MySQL: Transfer duplicate records to another table, during INSERT `tablename` SELECT * FROM `data source`

Question

I'm making a transition from MS Access into MySQL. With Access, I can copy and paste data between tables, any duplicates will be automatically placed in the table paste_errors. How can I accomplish this in MySQL?

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

You can try creating a Trigger. Check out this SO post which will outline two ways to do it.

edited May 23 '17 at 10:32

Community

1
1

answered Mar 27 '13 at 16:27

PRNDL Development Studios

3,270
2
35
50

MySQL: Transfer duplicate records to another table, during INSERT `tablename` SELECT * FROM `data source`

1 Answers1