Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql update set sum

UPDATE products p,( SELECT products_id, sum(attributes_stock)  as mysum
                   FROM products_attributes GROUP BY products_id) as s

   SET p.products_quantity = s.mysum
  WHERE p.products_id = s.products_id
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #mysql #update #set #sum
ADD COMMENT
Topic
Name
4+7 =