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,
fld2,
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 is added.
--Question1: How
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 is added.