在SQL中复制一行？

INSERT INTO 目标表 (列1, 列2, 列3, ...)
SELECT 列1, 列2, 列3, ...
FROM 源表
WHERE 条件;

INSERT INTO employees (id, name, age, department)
SELECT id, name, age, department
FROM employees
WHERE id = 1;

SELECT 列1, 列2, 列3, ...
INTO 新表
FROM 源表
WHERE 条件;

SELECT id, name, age, department
INTO new_employees
FROM employees
WHERE id = 1;