mysql9001_mysql学习笔记11_12（查询）

1、建表和插入值

创建company数据库

创建 department表

create table department(d_id int(10) primary key not null unique,d_name varchar(20) not null,function varchar(20),address varchar(30));

insert into department values(1001,'人事部','人事管理','北京');

insert into department values(1004,'销售部','产品销售','上海');

insert into department values(1003,'生产部','产品生产','天津');

insert into department values(1002,'科研部','研发产品','北京');

创建empoyee表

create table employee(id int(10) primary key not null unique,name varchar(20) not null,sex varchar(4),age int(5),d_id varchar(20),salary float,address varchar(50));

insert into employee values(9001,'Aric','男',25,'1002',4000,'北京市海淀区');

insert into employee values(9002,'Jim','男',26,'1001',2500,'北京市昌平区');

insert into employee values(9003,'Tom','男',20,'1003',1500,'湖南省永州市');

insert into employee values(9004,'Eric','男',30,'1001',3500,'北京市顺义区');

insert into employee values(9005,'Lily','女',21,'1002',3000,'北京市昌平区');