Re^2: perl DBI statement

Yes, I have tried that, the issue i run into is DBD::mysql::st execute failed: Duplicate entry '00000510011339735_1015422747869973' for key 'PRIMARY' at /home/rdscopy.pl line 104. DBD::mysql::st execute failed: Duplicate entry '00000510011339735_1015422747869973' for key 'PRIMARY' at /home/rdscopy.pl line 104.
Line 104 is: $sth_insert->execute(@insert) or die $sth_insert->errstr;

Comment on Re^2: perl DBI statement

Replies are listed 'Best First'.
Re^3: perl DBI statement by poj (Abbot) on Dec 04, 2016 at 13:32 UTC
You can't insert a record with the same primary key as an existing record. If the destination table is empty then it looks like the source table does not have the same primary key contraint as the destination table. poj	[reply]
Re^4: perl DBI statement by cbtshare (Monk) on Dec 04, 2016 at 13:44 UTC
yes, the destination table is truncated.So the issue is the source table? how would I solve this issue?	[reply]
Re^5: perl DBI statement by huck (Prior) on Dec 04, 2016 at 15:42 UTC
No, the issue is in the destination table. The issue is why does it already have a record with that same primary key? What is contained in $feed_table when the prepare select is run and then what is in $feed_table when the prepare insert is run? And what are the statements that assign values to $dbh2 and $dbh3. And what are the create table commands used to create each of those tables? And are you sure that the variable order returned from select * is the same order you specified in the prepare insert statement. And why do you feel that the destination table is truncated, why are you sure of that?	[reply]
Re^6: perl DBI statement by cbtshare (Monk) on Dec 04, 2016 at 19:18 UTC
Re^7: perl DBI statement by poj (Abbot) on Dec 04, 2016 at 20:12 UTC
Some notes below your chosen depth have not been shown here
Re^7: perl DBI statement by huck (Prior) on Dec 04, 2016 at 22:29 UTC


No such thing as a small change
	PerlMonks