mysql 复制表部分字段

-- 创建目标表（如果不存在）
CREATE TABLE IF NOT EXISTS target_table (
    id INT PRIMARY KEY,
    field1 VARCHAR(255),
    field2 INT
);

-- 插入数据
INSERT INTO target_table (id, field1, field2)
SELECT id, field1, field2 FROM source_table;

-- 创建触发器
DELIMITER $$
CREATE TRIGGER copy_fields_trigger
AFTER INSERT ON source_table
FOR EACH ROW
BEGIN
    INSERT INTO target_table (id, field1, field2) VALUES (NEW.id, NEW.field1, NEW.field2);
END$$
DELIMITER ;

-- 创建存储过程
DELIMITER $$
CREATE PROCEDURE copy_fields()
BEGIN
    INSERT INTO target_table (id, field1, field2)
    SELECT id, field1, field2 FROM source_table;
END$$
DELIMITER ;

-- 调用存储过程
CALL copy_fields();