Update problem with replace into

[Baukep]

Hello,

I'm using this query:
LOAD DATA INFILE 'D:/Effectenbeheer/Koersen/Koersen_update.vsn'
REPLACE INTO TABLE allekoersen_2006el
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
(tickerVL,valuta,datum,open,hoog,laag,slot,volume);

to update the table allekoersen_2006el

Runs perfectly but now I see that are there double records with only the id (autoincrement) different and that is not what I want. The older record should be updated and that is what I think 'replace into' should do.

I must be making a mistake but I cannot find it.

Any ideas?

Thanks in advance!

Bauke

 

[elsenorjose]

Does your table have a primary key or unique index?

"Note that unless the table has a PRIMARY KEY or UNIQUE index, using a REPLACE statement makes no sense. It becomes equivalent to INSERT, because there is no index to be used to determine whether a new row duplicates another."

http://dev.mysql.com/doc/refman/5.0/en/replace.html

Other than that, I can't think of why you'd be having this problem.