mysql将一张表的数据复制到另一张表

INSERT INTO target_table (column1, column2, ...)
SELECT column1, column2, ...
FROM source_table;

DELIMITER $$

CREATE TRIGGER after_insert_trigger
AFTER INSERT ON source_table
FOR EACH ROW
BEGIN
    INSERT INTO target_table (column1, column2, ...)
    VALUES (NEW.column1, NEW.column2, ...);
END$$

DELIMITER ;

INSERT INTO target_table (column1, column2, ...)
SELECT CAST(column1 AS target_column_type), column2, ...
FROM source_table;

INSERT INTO target_table (column1, column2, ...)
SELECT column1, column2, ...
FROM source_table
ON DUPLICATE KEY UPDATE column1 = VALUES(column1), column2 = VALUES(column2);

SET @batch_size = 1000;
SET @offset = 0;

WHILE @offset < (SELECT COUNT(*) FROM source_table) DO
    INSERT INTO target_table (column1, column2, ...)
    SELECT column1, column2, ...
    FROM source_table
    LIMIT @batch_size OFFSET @offset;
    SET @offset = @offset + @batch_size;
END WHILE;