要求:
实现源码:
1.建立数据库
mysql> create database mydb6_product;
Query OK, 1 row affected (0.01 sec)
2,使用数据库
mysql> use mydb6_product;
Database changed
3.建立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);
Query OK, 0 rows affected (0.02 sec)
4.建立orders表
mysql> create table orders(
-> id int primary key,
-> name varchar(100) not null,
-> price float,
-> quantity int,
-> category varchar(50)
-> );
Query OK, 0 rows affected (0.02 sec)
5.建立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));
Query OK, 0 rows affected (0.02 sec)