mysql创建表的语句

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone_number VARCHAR(20),
    hire_date DATE NOT NULL,
    job_id INT,
    salary DECIMAL(8, 2) NOT NULL,
    manager_id INT,
    department_id INT,
    CONSTRAINT fk_job FOREIGN KEY (job_id) REFERENCES jobs(job_id),
    CONSTRAINT fk_department FOREIGN KEY (department_id) REFERENCES departments(department_id)
);

-- 检查磁盘空间
SHOW VARIABLES LIKE 'datadir';

-- 检查权限
SHOW GRANTS FOR 'username'@'localhost';

-- 修改表名（如果包含特殊字符）
ALTER TABLE `old_table_name` RENAME TO `new_table_name`;