【SQL练习】创建表格，并添加记录

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);

运行结果：