UPDATE multiple mySQL tables

gruessle · 02-03-2004, 03:12 AM

I know this is easy for most of you but I been googling all over the place for help on this.

I have two tables and a text file
In the text file I have

products_model, products_description

The Tables look like this:
Table_1: products_id, products_model, etc. etc.
Table_2: products_id, products_description, etc. etc.

How can I UPDATE products_description in Table_2 WHERE products_model in Table_1 matches to the text file products_model.

Strike · 02-03-2004, 07:41 AM

Er, I'm assuming these are linked by products_id, so:

Code:

UPDATE Table_2
SET products_description = <whatever>
WHERE Table_2.products_id = Table_1.products_id
      AND Table_1.products_module = "<value you get from text file>"