Re: Load duplicates

[email protected] (Mark Lawrence via dbi-users) Mon, 4 Sep 2023 09:28:30 +0000
Newsgroups perl.dbi.users
Message-ID <[email protected]>
>Using perl 5.28 and mysql on windows.
>
>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?

It might be preferable to do this directly in SQL, using triggers. See 
here for a similar question: 

     https://stackoverflow.com/questions/18620389/before-insert-trigger-for-insert-duplicate-rows-into-another-table

-- 
Mark Lawrence