Mutiple Record Updates

zzz

Let's say I have table_1 with records 1-5000.

I also have table_2 that has 3000 records. These records are also in table_1 (records 1000-4000) .

Say, I have updated some of my data in table_2 and now I need to update corresponding records in table_1. How do I do it without affecting records that do not need an update. I guess my problem is that I know how to update 1 record, because I can target it individually WHERE id = '$id' , but I'm not sure how to do large updates...

mrhappiness

if there is a usable relationship between the tables and your mysql version is 4.0.4 or better, you can update mutiple tables at once

another way would be to do

UPDATE table1
  SET column2 = <new_value>
WHERE id IN (1,2,3,5,9,15,7894)

UPDATE table1
  SET column2 = <new_value>
WHERE id BETWEEN 1 AND 3000

how are the tables related to each other?

zzz

No I need to update just one table. Say I have a master table and a working table. I will be updating working one and once it's ready i would like to push data into master one.

i only want to update the records in the master that have been changed in the working table.

I can not just duplicate the working table into the master one, because I have other records in master one that do not come from working.