Mysql第一次作业

创建数据库

create database mydb6_product;

使用数据库

mysql>use mydb6_product;

创建表：

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.04 sec)

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> create table invoices(number int, 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.03 sec)

设置主键自增长：

mysql> alter table invoices modify number int primary key;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table invoices modify number int auto_increment;
Query OK, 0 rows affected (0.10 sec)
Records: 0  Duplicates: 0  Warnings: 0