How do you know these possibly duplicate records are not already in the
table?
What is wrong with adding a unique index on (fld2,fld3) ?
Hu Qinan wrote:
>Dear all,
>
>I intend to write a large volume of records to a table tbl.
>
>tbl:
>fld1, int unsigned not null auto_increment primary key,
>fl
Hu Qinan wrote:
>Dear all,
>
>I intend to write a large volume of records to a table tbl.
>
>tbl:
>fld1, int unsigned not null auto_increment primary key,
>fld2, text
>fld3, text
>
>The combination of (fld2, fld3) should be be unique, so I need to check for
>duplicates every time when a record
