UPDATE more than one table at a time.

[edawg]

Is it possilbe to update more than one table at a time using the same UPDATE command???, or do I have to use 2 seperate UPDATE queries?.

[fenway]

Indeed, with v4.0+ -- check the refman for the syntax.

[gluck]

UPDATE [LOW_PRIORITY] [iGNORE] table_references

    SET col_name1=expr1 [, col_name2=expr2 ...]

    [WHERE where_condition]

 

 

[fenway]

This is more clear (from the refman as well):

 

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;

The preceding example shows an inner join that uses the comma operator, but multiple-table UPDATE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.