mysql插入语句可以嵌套

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

CREATE TABLE user_profiles (
    user_id INT PRIMARY KEY,
    address VARCHAR(200),
    phone VARCHAR(20)
);

-- 插入数据
INSERT INTO users (username, email)
VALUES ('John Doe', 'john.doe@example.com');

INSERT INTO user_profiles (user_id, address, phone)
SELECT id, '123 Main St', '123-456-7890'
FROM users
WHERE username = 'John Doe';

-- 确保子查询返回的结果集与目标表的列数和数据类型匹配
INSERT INTO user_profiles (user_id, address, phone)
SELECT id, '123 Main St', '123-456-7890'
FROM users
WHERE username = 'John Doe';

-- 检查子查询中的SQL语句是否有语法错误
INSERT INTO user_profiles (user_id, address, phone)
SELECT id, '123 Main St', '123-456-7890'
FROM users
WHERE username = 'John Doe';

-- 检查目标表的约束条件
ALTER TABLE user_profiles
ADD CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES users(id);