On Wed, April 25, 2007 23:10, Jørn Dahl-Stamnes wrote:
> Please, I nedd help!!
>
> I have two tabels:
>
> table1:
> id
> value
>
> table2:
> id
> value
>
> Both tables has a lot of records with identical IDs. I need to update the
> table1.value with the table2.value where the id are identical.
update table1 t1, table2 t2 set t1.value=t2.value where t1.id=t2.id;
>
> But I cannot find any UPDATE query that can do this in a single operation.
> Anyone that can give me a suggestion?
>
> I'm using MySQL 4.1.8
>
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
