MySql数据的创建，表单的创建添加---员工信息管理

最新推荐文章于 2024-07-18 20:04:15 发布

MaGgIeOo0

最新推荐文章于 2024-07-18 20:04:15 发布

阅读量520

点赞数 1

分类专栏： SQL 文章标签： mysql oracle 数据库

本文链接：https://blog.csdn.net/weixin_62971115/article/details/132383703

版权

SQL 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

-- 创建数据库
CREATE employeeManagement;

-- 使用数据库
USE employeeManagement;

-- 创建部门表
CREATE TABLE dept(
	deptno int PRIMARY KEY,
	deptName VARCHAR(13),
	loc VARCHAR(16)
);

-- 创建员工表
CREATE TABLE emp(
	emno int PRIMARY KEY,
	ename VARCHAR(13),
	job VARCHAR(16),
	mgr int,
	hiredate date,
	sal DOUBLE,
	comn DOUBLE,
	deptno int,
	FOREIGN KEY(deptno) REFERENCES dept(deptno)
);

-- 创建薪资等级表
CREATE TABLE salgrade(
	grade int PRIMARY KEY,
	losal VARCHAR(17),
	hisal VARCHAR(17)
);

-- 添加部门表信息
INSERT INTO dept VALUES
	(10, 'ACCOUNTING', 'NEW YORK'),
  (20, 'RESEARCH', 'DALLAS'),
  (30, 'SALES', 'CHICAGO'),
  (40, 'OPERATIONS', 'BOSTON');
	
-- 添加员工表信息
INSERT INTO emp VALUES 
	(7369, 'SMITH', 'CLERK', 7902,  '1980-12-17', 800, NULL, 20), 
  (7499, 'ALLEN', 'SALESMAN', 7698,  '1981-02-20', 1600, 300, 30),
	(7521, 'WARD', 'SALESMAN', 7698,  '1981-02-22', 1250, 500, 30),
	(7566, 'JONES', 'MANAGER', 7839,  '1981-04-02', 2975, NULL, 20),
	(7654, 'MARTIN', 'SALESMAN', 7698,  '1981-09-28', 1250, 1400, 30), 
	(7698, 'BLAKE', 'MANAGER', 7839,  '1981-05-01', 2850, NULL, 30),
	(7782, 'CLARK', 'MANAGER', 7839,  '1981-06-09'	, 2450, NULL, 10),
	(7788, 'SCOTT', 'ANALYST', 7566,  '1987-04-19', 3000, NULL, 20),
	(7839, 'KING', 'PRESIDENT', NULL,  '1981-11-17', 5000, NULL, 10),
	(7844, 'TURNER', 'SALESMAN', 7698,  '1981-09-08', 1500, NULL, 30),
	(7876, 'ADAMS', 'CLERK', 7788,  '1987-05-23', 1100, NULL, 20),
	(7900, 'JAMES', 'CLERK', 7698,  '1981-12-03', 950, NULL, 30),
	(7902, 'FORD', 'ANALYST', 7566,  '1981-12-03', 3000, NULL, 20),
	(7934, 'MILLER', 'CLERK', 7782,  '1982-01-23', 1300, NULL, 10);
 
-- 添加薪资等级表信息
INSERT INTO salgrade VALUES
	( 1, 700, 1200),
	( 2, 1201, 1400), 
	( 3, 1401, 2000), 
	( 4, 2001, 3000), 
	( 5, 3001, 9999);