mysql 结果输出到表

CREATE TABLE employee_salaries AS
SELECT name, salary
FROM employees;

CREATE TABLE employee_department_info (
    employee_id INT,
    employee_name VARCHAR(255),
    department_name VARCHAR(255)
);

INSERT INTO employee_department_info (employee_id, employee_name, department_name)
SELECT e.employee_id, e.name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

-- 删除目标表（如果存在）
DROP TABLE IF EXISTS employee_salaries;

-- 创建新表并插入数据
CREATE TABLE employee_salaries AS
SELECT name, salary
FROM employees;

CREATE TABLE employee_salaries (
    name VARCHAR(255),
    salary DECIMAL(10, 2)
);

INSERT INTO employee_salaries (name, salary)
SELECT name, salary
FROM employees;

GRANT CREATE, INSERT ON database_name.* TO 'username'@'localhost';