List:General Discussion« Previous MessageNext Message »
From:Jørn Dahl-Stamnes Date:April 25 2007 9:10pm
Subject:Update question
View as plain text  
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.

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

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
Thread
Update questionJørn Dahl-Stamnes25 Apr
  • Re: Update questionMogens Melander25 Apr
Re: Update questionJørn Dahl-Stamnes26 Apr