用SubQuery在SQL中插入多行

SELECT 1 AS employee_id, 'John' AS first_name, 'Doe' AS last_name
UNION ALL
SELECT 2 AS employee_id, 'Jane' AS first_name, 'Smith' AS last_name
UNION ALL
SELECT 3 AS employee_id, 'Mike' AS first_name, 'Johnson' AS last_name;

INSERT INTO employees (employee_id, first_name, last_name)
SELECT employee_id, first_name, last_name
FROM (
    SELECT 1 AS employee_id, 'John' AS first_name, 'Doe' AS last_name
    UNION ALL
    SELECT 2 AS employee_id, 'Jane' AS first_name, 'Smith' AS last_name
    UNION ALL
    SELECT 3 AS employee_id, 'Mike' AS first_name, 'Johnson' AS last_name
) AS subquery;