mysql insert两个表插入一个表

-- 创建users表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 创建logs表
CREATE TABLE logs (
    log_id INT AUTO_INCREMENT PRIMARY KEY,
    user_info VARCHAR(255)
);

-- 向users表插入数据
INSERT INTO users (name, email) VALUES
('Alice', 'alice@example.com'),
('Bob', 'bob@example.com');

-- 将users表中的数据插入到logs表中
INSERT INTO logs (user_info)
SELECT CONCAT('Name: ', name, ', Email: ', email) AS user_info FROM users;

-- 使用INSERT IGNORE忽略主键冲突
INSERT IGNORE INTO logs (user_info)
SELECT CONCAT('Name: ', name, ', Email: ', email) AS user_info FROM users;

-- 使用REPLACE替换主键冲突的记录
REPLACE INTO logs (user_info)
SELECT CONCAT('Name: ', name, ', Email: ', email) AS user_info FROM users;

-- 确保插入的数据类型匹配
INSERT INTO logs (user_info)
SELECT CONCAT('Name: ', name, ', Email: ', email) AS user_info FROM users;