mysql同表复制数据

-- 使用INSERT IGNORE忽略主键冲突
INSERT IGNORE INTO table_name (column1, column2, ...)
SELECT column1, column2, ...
FROM table_name
WHERE condition;

-- 使用REPLACE INTO替换主键冲突的数据
REPLACE INTO table_name (column1, column2, ...)
SELECT column1, column2, ...
FROM table_name
WHERE condition;

-- 使用事务批量插入数据
START TRANSACTION;
INSERT INTO table_name (column1, column2, ...)
SELECT column1, column2, ...
FROM table_name
WHERE condition;
COMMIT;

-- 使用LOAD DATA INFILE批量导入数据
LOAD DATA INFILE 'file_path'
INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    email VARCHAR(255)
);

INSERT INTO users (name, email)
SELECT name, email
FROM users;

INSERT INTO users (name, email)
SELECT name, email
FROM users
WHERE id > 10;