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