1.创建表格结构
2.添加记录
代码:
1.创建表格:
drop table work;
drop table employee;
drop table department;
create table employee(
empid varchar(4) primary key,
empname varchar(20) not null,
age int,
address varchar(50),
sal int
);
create table department(
deptno varchar(4) primary key,
dname varchar(20) not null,
mgr varchar(4)
);
create table work(
empid varchar(4),
deptno varchar(4),
worktime int,
constraint fk_work_deptno foreign key(deptno) REFERENCES department(deptno)
);
2.添加数据
insert into employee
values('E01','tom',35,'海淀',8000),
('E02','dennis',24,'朝阳',5000),
('E03','john',20,'海淀',4000),
('E04','rick',41,'朝阳',7000),
('E05','bill',45,'西域',7500),
('E06','frank',24,'海淀',6000),
('E07','jank',25,'东域',3000),
('E08','mike',23,'东域',3500);
insert into department
values
('D01','人事','E04'),
('D02','信息','E01'),
('D03','销售','E05'),
('D04','财务','E06');
insert into work
values
('E01','D02',6),
('E01','D03',1),
('E01','D04',2),
('E02','D01',2),
('E02','D04',0),
('E03','D02',0),
('E04','D01',4),
('E04','D02',1),
('E05','D03',2),
('E06','D04',4),
('E07','D04',1),
('E08','D03',2);
运行结果: