SQL
Public
Update Rows with Join
Update rows in one table using values from another table.
#sql
#update
#join
#mysql
SQL
UPDATE products p
INNER JOIN categories c
ON c.id = p.category_id
SET p.category_name_cache = c.name
WHERE p.category_id IS NOT NULL;Notes
Always test UPDATE queries with a SELECT first, especially on production data.
