Code: Select all
UPDATE products SET products.cat = cat2.cat_desc WHERE cat2.id = products.catModerator: General Moderators
Code: Select all
UPDATE products SET products.cat = cat2.cat_desc WHERE cat2.id = products.catCode: Select all
UPDATE products,cat2 SET products.cat = cat2.cat_desc WHERE cat2.id = products.catStarting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables:The example shows an inner join using the comma operator, but multiple-table UPDATE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.Code: Select all
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;