mysql示例数据库脚本

-- 创建数据库
CREATE DATABASE IF NOT EXISTS company;

-- 使用数据库
USE company;

-- 创建表
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(15),
    hire_date DATE NOT NULL,
    job_id INT,
    salary DECIMAL(10, 2),
    manager_id INT,
    department_id INT
);

-- 插入示例数据
INSERT INTO employees (first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id)
VALUES
('John', 'Doe', 'john.doe@example.com', '555-1234', '2020-01-15', 1, 50000.00, NULL, 1),
('Jane', 'Smith', 'jane.smith@example.com', '555-5678', '2019-05-20', 2, 60000.00, 1, 2),
('Mike', 'Johnson', 'mike.johnson@example.com', '555-9876', '2021-03-10', 3, 70000.00, 1, 1);