mysql查询结果插入

CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE TABLE target_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

INSERT INTO target_table (id, name, age)
SELECT id, name, age FROM source_table;

-- 确保目标表的列数和数据类型与查询结果一致
ALTER TABLE target_table MODIFY COLUMN age INT;

-- 使用 INSERT IGNORE 忽略重复值
INSERT IGNORE INTO target_table (id, name, age)
SELECT id, name, age FROM source_table;

-- 使用 REPLACE INTO 替换重复值
REPLACE INTO target_table (id, name, age)
SELECT id, name, age FROM source_table;

-- 分批次插入数据
SET @batch_size = 1000;
SET @offset = 0;

INSERT INTO target_table (id, name, age)
SELECT id, name, age
FROM source_table
WHERE id >= @offset AND id < (@offset + @batch_size);

SET @offset = @offset + @batch_size;