update mysql database

[Anon]

Have anyone known how to update column C1 in talbe1 by column C3 in table2?

It seemed that mysql only allow to update column in one table, not between two tables?

Have anyone had any good tips?

[sarahk]

If this doesn't work

update table1 set val1 = (select val1 from table2 where table1.id = table2.id)

then you may have to pull the values out of the database into a script and then send back down to the database again.

This should just be a maintenance issue or a summary task so shouldn't too much matter if it's not optimised.