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:
Geoffrey,
Thank you for that info. Working on getting it in.
Very helpful.
Best regards.
On Tue, Aug 15, 2023 at 1:34 PM Geoffrey Rommel wrote:
> So are you reading the records one at a time through DBI and looking for
> duplicates? There is probably a better way.
>
> I work with Teradata,
So are you reading the records one at a time through DBI and looking for
duplicates? There is probably a better way.
I work with Teradata, so I'll use Teradata syntax, but the syntax for other
databases will be similar.
To find the duplicates in your table, you can select all columns from the
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