如何使用各自的字段将值从一个表插入到另一个表中

-- 同一数据库内的表间插入
INSERT INTO destination_table (column1, column2, column3)
SELECT column1, column2, column3
FROM source_table;

-- 跨数据库的表间插入（假设两个数据库分别为db1和db2）
INSERT INTO db2.destination_table (column1, column2, column3)
SELECT column1, column2, column3
FROM db1.source_table;

INSERT INTO destination_table (col1, col2)
SELECT col1, col2 FROM source_table;

-- 使用INSERT IGNORE忽略冲突
INSERT IGNORE INTO destination_table (id, column1, column2)
SELECT id, column1, column2 FROM source_table;

-- 使用ON DUPLICATE KEY UPDATE更新现有记录
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 (column1, column2, column3)
SELECT column1, column2, column3
FROM source_table
WHERE id BETWEEN 1 AND 1000;

INSERT INTO destination_table (column1, column2, column3)
SELECT column1, column2, column3
FROM source_table
WHERE id BETWEEN 1001 AND 2000;
-- 以此类推