CREATE TABLE sum_table ( id INT AUTO_INCREMENT PRIMARY KEY, num1 INT NOT NULL, num2 INT NOT NULL, num3 INT NOT NULL, total INT );
INSERT INTO sum_table (num1, num2, num3, total) VALUES (10, 20, 30, 0); INSERT INTO sum_table (num1, num2, num3, total) VALUES (20, 30, 40, 0); INSERT INTO sum_table (num1, num2, num3, total) VALUES (30, 40, 50, 0);
UPDATE sum_table SET total = num1 + num2 + num3;
SELECT * FROM sum_table;
-- 结果如下:
-- | id | num1 | num2 | num3 | total |
---|---|---|---|---|---|
-- | 1 | 10 | 20 | 30 | 60 |
-- | 2 | 20 | 30 | 40 | 90 |
-- | 3 | 30 | 40 | 50 | 120 |