嵌套选择查询在PostgreSQL中工作，但不使用MySQL

Question

下面嵌套的SELECT查询在PostgreSQL中工作，但不使用MySQL，我不知道为什么：

INSERT INTO
    employees(
        id,
        first_name,
        last_name,
        job_title,
        base_salary,
        commission_pct
    )
VALUES
    (
        400,
        'Elise',
        'Ryan',
        'Auditing Clerk',
        (
            SELECT
                MAX(base_salary)
            FROM
                employees
            WHERE
                job_title = 'Auditing Clerk'
        ),
        (
            SELECT
                AVG(commission_pct)
            FROM
                employees
            WHERE
                job_title = 'Auditing Clerk'
        )
    )

下面是MySQL给我的错误消息

错误代码: 1093。不能在FROM子句**

中为更新指定目标表“employees”

Answer 1

这在以下两方面都应起作用：

INSERT INTO
    employees(
        id,
        first_name,
        last_name,
        job_title,
        base_salary,
        commission_pct
    )
SELECT
    400,
    'Elise',
    'Ryan',
    'Auditing Clerk',
    MAX(base_salary),
    AVG(commission_pct)
FROM
    employees
WHERE
    job_title = 'Auditing Clerk'