From: Mogens Melander
Date: April 25 2007 9:18pm
Subject: Re: Update question
List-Archive: http://lists.mysql.com/mysql/206359
Message-Id: <2206.90.184.17.152.1177535899.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


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.