/*
创建表
dept (部门表)
DEPTNO (部门编号) int
NAME(部门名称) varchar
LOC(部门的地址) varchar
emp(员工表)
EMPNO(员工编号) int
ENAME(员工的名称) varchar
JOB(工作岗位) varchar
MGR(直接上级领导编号) int
HIREDATE(入职日期) date
SAL(薪资,工资)double
COMM(补助) double
DEPTNO(部门编号) int
salgrade(薪资等级)
GRADE(薪资编号) int
LOSAL(最低薪资) int
HISAL(最高薪资) int
基本的查询操作
向员工表添加10条数据
(1)查询员工的姓名
(2)查询员工的薪水以及姓名
(3)查询员工表所有的数据
(4)查询每一个员工的年薪
*/
CREATE TABLE dept(
DEPTNO INT,
`NAME` VARCHAR(20),
LOC VARCHAR(20)
);
CREATE TABLE emp(
EMPNO INT PRIMARY KEY AUTO_INCREMENT,
ENAME VARCHAR(20),
JOB VARCHAR(20),
MGR INT,
HIREDATE DATE,
SAL DOUBLE,
COMM DOUBLE,
DEPTNO INT
);
CREATE TABLE salgrade(
GRADE INT,
LOSAL INT,
HISAL INT
);
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(1,'赵云','野区',002,'2007-08-08',12345.67,3567.89,102) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'貂蝉','中路',003,'2008-08-08',10045.67,3167.89,103) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'娜可露露','野区',002,'2009-08-08',12125.67,3067.89,102) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'吕布','对抗路',001,'2010-08-08',12785.67,2967.89,101) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'狄仁杰','发育路',004,'2011-08-08',14545.67,2767.89,104) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'鲁班大师','游走',005,'2012-08-08',19745.67,2567.89,105) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'马可波罗','发育路',004,'2008-08-08',13245.67,2367.89,104) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'张飞','游走',005,'2007-08-08',14345.67,2167.89,105) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'上官婉儿','中路',003,'2009-08-08',13345.67,2967.89,103) ;
INSERT INTO emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(NULL,'芈月','对抗路',001,'2008-08-08',11345.67,2567.89,101) ;
TRUNCATE TABLE emp;
SELECT ename FROM emp ;
SELECT SAL,ename FROM emp;
SELECT *FROM emp;
SELECT ename,SAL*12 FROM emp;