mysql查询插入

INSERT INTO table2 (column1, column2)
SELECT column1, column2
FROM table1
WHERE condition;

INSERT INTO table (id, name, age)
VALUES (1, 'Alice', 30)
ON DUPLICATE KEY UPDATE
name = VALUES(name),
age = VALUES(age);

INSERT IGNORE INTO table (id, name)
VALUES (1, 'Bob');

-- 使用INSERT IGNORE
INSERT IGNORE INTO table (id, name)
VALUES (1, 'Bob');

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO table (id, name)
VALUES (1, 'Bob')
ON DUPLICATE KEY UPDATE
name = VALUES(name);

-- 批量插入
INSERT INTO table (id, name)
VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie');

-- 使用事务
START TRANSACTION;
INSERT INTO table (id, name) VALUES (1, 'Alice');
INSERT INTO table (id, name) VALUES (2, 'Bob');
INSERT INTO table (id, name) VALUES (3, 'Charlie');
COMMIT;