How about LOAD DATA INFILE '...' REPLACE INTO TABLE '...'?

I also have a question about your schema... you already have a primary key (the auto_increment column.) Do you need a unique constraint on the other column set? If so, is REPLACE the correct action to take when you come across another row with the same key? Is keeping only the 'last' row for each key what you really want to do?

Tell us more about your schema. You may not need the unique constraint (or dropping it might make your data more useful as you'll be keeping a history of all the records you've uploaded.)

In reply to Re: DBI Question: bulk insertion with Unique-key constraint by pc88mxer
in thread DBI Question: bulk insertion with Unique-key constraint by lihao

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.