一、建库
登录MySQL后建立数据库mydb6_product并使用它
mysql> create database mydb6_product;
Query OK, 1 row affected (0.01 sec)
mysql> use mydb6_product;
Database changed
二、建表
(1)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.03 sec)
mysql> desc employees; #查看表结构
结果
(2)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.03 sec)
mysql> desc orders;
结果
(3)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.04 sec) #auto_increment设置主键自增长,foreign key(order_id) references orders(id)表示外键关联到orders表的id列
mysql> desc invoices;
结果
要求完成,结束