mysql第一次作业

 create table  employees(id int not null primary key,

name varchar(50) not null ,

age int,

gender varchar(10) not null default 'unknown',

salary float);

create table orders(id int not null primary key ,

name varchar(100) not null,

price float,

category varchar(50));

create table invoices(number int not null primary key auto_increment,

order_id int,

foreign key (order_id) references invoices(number),列建立外关联

in_date date,

total_amouunt float);