create database mydb6_product;\\建立产品库
use mydb6_product;\\使用库
create table employee(id int primary key ,
name varchar(50) not null ,
age int,
gender char(10) not null default'unknow',
salary float);\\建立employee表,分行写代码
desc employee;\\ 查看employee表
gender的类型设置错误,,进行更改
alter table employee modify gender varchar(10);\\对gender的类型进行更改
create table orders(id int primary key,
name varchar(100) not null,
price float,
quantity int,
category varchar(50));\\建立新的orders表,分行写代码,美观简洁
desc orders;\\查看orders表
create table invoices(number int primary key,\\建立新的invoices表
order_id int,
in_date date,
total_amount float check(total_amount>0),
foreign key(order_id) references orders(id));\\让order_id与orders的id列建立外关联
alter table invoices modify number int auto_increment;\\设置number的主键自增长
desc invoices;\\查看invoices表