如何打数学函数代码

数学代码纯步骤之总体版

公司员工版数学代码，首先连接数据库：

-- 连接数据库
USE wzw_dg;

创建数据表，作为外键约束：

-- 创建一个数据表，外键约束
CREATE TABLE dept
(
	d_no INT PRIMARY KEY AUTO_INCREMENT,
	d_name VARCHAR(50),
	d_location VARCHAR(100)
)ENGINE=InnoDB;

查看数据库：

-- 查看数据
DESC dept;

再创建一个数据表，作为主键约束：

-- 创建数据表,主键约束
CREATE TABLE employee
(
	e_no INT(11) PRIMARY KEY,
	e_name VARCHAR(100) NOT NULL,
	e_gender CHAR(2),
	dept_no INT(11) NOT NULL,
	e_job VARCHAR(100) NOT NULL,
	e_salary SMALLINT NOT NULL,
	hireDate DATE,
	CONSTRAINT fk_dept_employee FOREIGN KEY(dept_no) REFERENCES dept(d_no)
)ENGINE=InnoDB;

再查看一下数据表：

DESC employee;

为dept插入数据

INSERT INTO dept VALUES(10,'ACCOUNTINT','SHANGHAI');
INSERT INTO dept VALUES(20,'RESEARCH','BeiJing');
INSERT INTO dept VALUES(30,'SALES','ShenZhen');
INSERT INTO dept VALUES(40,'OPERATIONS','FuJian');

查看插入的数据：

SELECT * FROM dept;

为 employee插入代码：

INSERT INTO employee VALUES(1001,'SMITH','m',20,'CLERK',800,'2005-11-12'),
(1002,'ALLEN','f',30,'SALESMAN',1600,'2003-05-12'),
(1003,'WARD','f',30,'SALESMAN',1250,'2003-05-12'),
(1004,'JONES','m',20,'MANAGER',2975,'1998-05-18'),
(1005,'MARTIN','m',30,'SALESMAN',1250,'2001-06-12'),
(1006,'BLAKE','f',30,'MANAGER',2450,'1997-02-15'),
(1007,'CLARK','m',10,'MANAGER',2850,'2002-09-12'),
(1008,'SCOTT','m',20,'ANALYST',3000,'2003-05-12'),
(1009,'KING','f',10,'PRESIDENT',5000,'1995-01-01'),
(1010,'TURNER','f',30,'SALESMAN',1500,'1997-11-12'),
(1011,'ADAMS','m',20,'CLERK',1100,'1999-10-05'),
(1012,'JAMES','m',30,'CLERK',950,'2008-06-15');

查看插入的数据

DESC employee;

接下来修改部门单位从英文变为中文

SELECT e_no AS'员工编号',e_name AS'员工姓名',e_gender AS'员工性别',dept_no AS'部门编号',
e_job AS'职位',e_salary AS'薪水',hireDate AS'入职日期' FROM employee;