mysql 复制单条数据

-- 假设有两个表 table1 和 table2，结构相同
INSERT INTO table2 (column1, column2, column3)
SELECT column1, column2, column3
FROM table1
WHERE id = 1; -- 假设我们要复制id为1的数据

-- 导出数据到文件
SELECT column1, column2, column3
INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table1
WHERE id = 1;

-- 从文件导入数据到另一个表
LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE table2
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

DELIMITER $$

CREATE TRIGGER copy_data_after_insert
AFTER INSERT ON table1
FOR EACH ROW
BEGIN
    IF NEW.id = 1 THEN
        INSERT INTO table2 (column1, column2, column3)
        VALUES (NEW.column1, NEW.column2, NEW.column3);
    END IF;
END$$

DELIMITER ;