update tbl X using data from table Y

[iam288]

Hi guys,

I've got a problem. Any suggestion??

update t1, t2
set t1.txt = t2.txt
where t1.id = t2.id;

I've tried this code in Access and it did work well but not for MySQL at
all.

 

[Broccoli2]

Nope - you can't do this in MySQL (yet). A workaround is to do a CREATE TABLE SELECT then replace your old table with the new one

-Rpb

 

[riffy]

u could also use update <tablename> set <whatever> where <whatever>

am i right?

 

[riffy]

never mind that, i didn't realize it was two different tables...rob's suggestion will do it

arif