MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE sma_sale_items(id INT, product_id INT, quantity FLOAT, acumulado FLOAT);
INSERT INTO sma_sale_items(id,product_id,quantity)
 SELECT 170, 195, 1     UNION ALL
 SELECT 171, 190, 25.60 UNION ALL
 SELECT 168, 190, 1     UNION ALL
 SELECT 169, 190, 3     UNION ALL
 SELECT 172, 190, 1;
UPDATE sma_sale_items s1
 JOIN (
      SELECT id, product_id, SUM(quantity) OVER (ORDER BY id) AS acumulado
        FROM sma_sale_items
       ORDER BY id
      ) s2 ON s1.ID=s2.ID
  SET s1.acumulado = s2.acumulado;
  
SELECT * 
  FROM sma_sale_items
 ORDER BY id;
 


id
product_id
quantity
acumulado


168
190
1
1

169
190
3
4

170
195
1
5

171
190
25.6
30.6

172
190
1
31.6