MySQL作业

一、实验要求

二、实验过程
1.创建数据库，使用

mysql>CREATE DATABASE mydb6_product;

mysql> USE mydb6_product;

如图：

2.创建employees表

mysql> CREATE TABLE employees (
    ->     id INT PRIMARY KEY,
    ->     name VARCHAR(50) NOT NULL,
    ->     age INT,
    ->     gender VARCHAR(10) NOT NULL DEFAULT 'unknown',
    ->     salary FLOAT
    -> );

3.创建orders表

mysql> CREATE TABLE orders (
    ->     id INT PRIMARY KEY,
    ->     name VARCHAR(100) NOT NULL,
    ->     price FLOAT,
    ->     quantity INT,
    ->     category VARCHAR(50)
    -> );

4.创建invoices表

mysql> CREATE TABLE invoices (
    -> number INT PRIMARY KEY AUTO_INCREMENT,
    ->  order_id INT,
    -> in_date DATE,
    -> total_amount FLOAT CHECK (total_amount >0),
    -> FOREIGN KEY (order_id) REFERENCES orders(id)
    -> );

5.验证实验是否成功