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?

In reply to Re: perl DBI statement by Marshall
in thread perl DBI statement by cbtshare

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.