mysql值发到别的表中

-- source_table 结构
CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- destination_table 结构
CREATE TABLE destination_table (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

-- 将 source_table 中的数据插入到 destination_table 中
INSERT INTO destination_table (id, name)
SELECT id, name FROM source_table;

-- users 表结构
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- orders 表结构
CREATE TABLE orders (
    id INT PRIMARY KEY,
    user_id INT,
    amount DECIMAL(10, 2)
);

-- 更新 orders 表中的用户信息
UPDATE orders
JOIN users ON orders.user_id = users.id
SET orders.user_name = users.name;

-- orders 表结构
CREATE TABLE orders (
    id INT PRIMARY KEY,
    user_id INT,
    amount DECIMAL(10, 2)
);

-- order_summary 表结构
CREATE TABLE order_summary (
    user_id INT,
    total_amount DECIMAL(10, 2)
);

-- 创建触发器
DELIMITER $$
CREATE TRIGGER update_order_summary
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
    UPDATE order_summary
    SET total_amount = total_amount + NEW.amount
    WHERE user_id = NEW.user_id;
END$$
DELIMITER ;

START TRANSACTION;
-- 执行数据操作
COMMIT;