Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Set each product's price to the average price of its category UPDATE products p SET p.price = ( SELECT AVG(p2.price) FROM (SELECT * FROM products) AS p2 WHERE p2.category_id = p.category_id ) WHERE p.is_active = 1;
Result
Open