REPLACE quirie

[yigalm]

Hi,

I cannot get a replace querie to replace data in one table with fields from another. Instead, it appends new rows.
In both tables I made one field a UNIQUE KEY. This field is the common denominator in the two tables. But when I say:
replace tbl1 (fld1, fld2)
select fld1, fld2
from tbl2;

when tbl1.fld3 and tbl2.fld3 are UNIQUE KEYs and they are supposed to be the same in both tables (tbl1 has more entries than tbl2), the querie appends new rows.

What am I doing wrong, that the REPLACE appends instead of updating?

Thank you

 

[Tim1]

Hiya,

You need to use the update query to do this:

UPDATE tbl1
SET fld1 = tbl2.fld1,
fld2 = tbl2.fld2
FROM tbl2;

HTH

Tim

 

[yigalm]

I believe that UPDATE will not update from another table in MySQL, and REPLACE should be used in it's place.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE

I tried to UPDATE in Access and it worked, but in MySQL it gives errors when you try to update from another table.