in reply to perl DBI statement
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 |