mysql 搜索值插入

-- 创建示例表
CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

CREATE TABLE destination_table (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- 插入数据到source_table
INSERT INTO source_table (id, name, age) VALUES
(1, 'Alice', 30),
(2, 'Bob', 25),
(3, 'Charlie', 35);

-- 从source_table插入数据到destination_table
INSERT INTO destination_table (id, name, age)
SELECT id, name, age FROM source_table;

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

INSERT INTO destination_table (id, name, age)
SELECT id, CAST(name AS VARCHAR(100)), age FROM source_table;

START TRANSACTION;
INSERT INTO destination_table (id, name, age)
SELECT id, name, age FROM source_table WHERE id BETWEEN 1 AND 1000;
COMMIT;

START TRANSACTION;
INSERT INTO destination_table (id, name, age)
SELECT id, name, age FROM source_table WHERE id BETWEEN 1001 AND 2000;
COMMIT;