'Getting error for insert statement for MySQL [duplicate]

INSERT INTO `Employees` 
        (employeeFirstName, employeeLastName, managerID, employeeRole) 
VALUES ("Kim", "Brooks", NULL, "Manager");

INSERT INTO `Employees` 
        (employeeFirstName, employeeLastName, managerID, employeeRole) 
VALUES ("Alice", "Brown", 
        (SELECT employeeID 
        FROM Employees 
        WHERE employeeFirstName = "Kim" 
        and employeeLastName = "Brooks"
        ), "Instructor"
    );

I have the above code. However, for my second insert statement, it gives me an error stating "Table 'Employees' is specified twice, both as a target for 'INSERT' and as a separate source of data.

mysqlsqlsql-insert


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions