mysql复制表中列数据

-- 创建目标表
CREATE TABLE destination_table (
    id INT PRIMARY KEY,
    column1 VARCHAR(255),
    column2 INT
);

-- 复制数据
INSERT INTO destination_table (id, column1, column2)
SELECT id, column1, column2 FROM source_table;

ALTER TABLE destination_table MODIFY column1 VARCHAR(255);
ALTER TABLE destination_table MODIFY column2 INT;

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

INSERT INTO destination_table (id, column1, column2)
SELECT id, column1, column2 FROM source_table
WHERE id BETWEEN 1 AND 1000;

-- 重复上述语句，逐步增加范围