SQL create columns with sum另一列按唯一项

CREATE TABLE myTable (
   id INT,
   value INT,
   sum_value INT
);

INSERT INTO myTable (id, value) VALUES (1, 10);
INSERT INTO myTable (id, value) VALUES (2, 20);
INSERT INTO myTable (id, value) VALUES (3, 30);
INSERT INTO myTable (id, value) VALUES (4, 40);
INSERT INTO myTable (id, value) VALUES (5, 50);

UPDATE myTable
SET sum_value = (
   SELECT SUM(value)
   FROM myTable
   GROUP BY value
)

SELECT id, value, sum_value
FROM myTable;