MySQL -从一个表插入到另一个表错误代码: 1242.子查询返回多行

CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

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

INSERT INTO destination_table (id, name)
SELECT id, name FROM source_table WHERE id = 1;

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

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

-- 插入示例数据
INSERT INTO source_table (id, name) VALUES (1, 'Alice'), (1, 'Bob'), (2, 'Charlie');

-- 错误的插入语句
-- INSERT INTO destination_table (id, name)
-- SELECT id, name FROM source_table WHERE id = 1;

-- 正确的插入语句
INSERT INTO destination_table (id, name)
SELECT id, name FROM source_table WHERE id = 1 LIMIT 1;