Hi,

I've got a problem with an update statement. It looks like this and I don't get the mistake:

UPDATE tbl1, tbl2
SET tbl1.x = tbl2.z
WHERE tbl1.id = tbl2.id

I already tried this one:

UPDATE tbl1
SET x = tbl2.z
FROM tbl1, tbl2
WHERE tbl1.id = tbl2.id

Any ideas?

THX

post the error message of first update query, syntax is correct, second is bad

You should use the replace syntax for the second query.
http://www.mysql.com/doc/en/REPLACE.html

The Error Message looks like this:

You have an error in your SQL syntax near ' tbl2 SET tbl1.x = tbl_2.z WHERE t' at line 1

It says already nothing ;-(

bumbe, are you on the appropriate version of mysql?

Oh, I've checked the version just now. It's 3.23 - That could be the problem ;-)

that, indeed, could be the source of all your trouble

multi-table updates aren't allowed!