Load duplicates

--0000000000002d15c10602f82276
Content-Type: text/plain; charset="UTF-8"

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

--0000000000002d15c10602f82276
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi group,<div><br></div><div>My perl skills are basic and =
my SQL skills almost match that.</div><div>Using perl 5.28 and mysql on win=
dows.</div><div><br></div><div>I have a couple million records that needs p=
rocessing to go to their final destination.</div><div>Currently I&#39;m cat=
chin duplicates with error 1062 in perl and using that to write the duplica=
te records to a separate=C2=A0table for later processing.<br></div><div><br=
></div><div>Question: Can DBI give me a field from the record on the main t=
able causing the duplicate so I can add=C2=A0that to the record going to th=
e=C2=A0duplicate table?</div><div><br></div><div>Example:</div><div>MAIN ta=
ble fields =3D &quot;auto_increment&quot;, acct, comp,accr,desc,etc....=C2=
=A0 :</div><div>=C2=A0(auto_increment created when records are added, rest =
is the source record)</div><div>Duplicate table fields =3D &quot;auto_incre=
ment from MAIN table&quot;, acct,comp,accr,desc,etc.....</div><div><br></di=
v><div>Thanks</div><div>Ian</div><div><br></div><div><br></div></div>

--0000000000002d15c10602f82276--