Hi group, My perl skills are basic and my SQL skills almost match that. Using perl 5.28 and mysql on windows.
I have a couple million records that needs processing to go to their final destination. Currently I'm catchin duplicates with error 1062 in perl and using that to write the duplicate records to a separate table for later processing. Question: Can DBI give me a field from the record on the main table causing the duplicate so I can add that to the record going to the duplicate table? Example: MAIN table fields = "auto_increment", acct, comp,accr,desc,etc.... : (auto_increment created when records are added, rest is the source record) Duplicate table fields = "auto_increment from MAIN table", acct,comp,accr,desc,etc..... Thanks Ian
