in reply to perl DBI statement

In this and in the previous thread on this subject, you have been asked to show the table structure of both tables (the CREATE statement). You can ask MySQL for that information.

From the MySQL command line, the SHOW CREATE TABLE function will display the CREATE TABLE function that is required to make a duplicate of this particular table. Do that for both of your tables.

It appears that something is wrong with your Destination table in regards to the primary key.

Ok, you see: Duplicate entry '1638749309730588_1796064657332385' for key 'PRIMARY' Could it be that a previous INSERT actually worked? And the reason that this INSERT does not work is that there is already a row with that same PRIMARY KEY?

Replies are listed 'Best First'.
Re^2: perl DBI statement
by cbtshare (Monk) on Dec 04, 2016 at 23:30 UTC
    thank you for your response, it was my oversight which turned this into a bigger issue that it was.I was connecting to the same host twice.