按日期在MySQL中从另一行中减去行

-- 创建示例表table1
CREATE TABLE table1 (
  date_column DATE,
  value_column INT
);

-- 创建示例表table2
CREATE TABLE table2 (
  date_column DATE,
  value_column INT
);

-- 向table1插入示例数据
INSERT INTO table1 (date_column, value_column)
VALUES ('2022-01-01', 10), ('2022-01-02', 20), ('2022-01-03', 30);

-- 向table2插入示例数据
INSERT INTO table2 (date_column, value_column)
VALUES ('2022-01-01', 5), ('2022-01-02', 15), ('2022-01-03', 25);

-- 从table2中减去table1的值，并将结果存储到新表result_table中
CREATE TABLE result_table AS
SELECT table2.date_column, table2.value_column - table1.value_column AS result
FROM table2
JOIN table1 ON table2.date_column = table1.date_column;

-- 查询结果
SELECT * FROM result_table;