从零开始38分钟学会SQL语言

--创建公司数据库

CREATE DATABASE company;

--创建部门表

CREATE TABLE dept(

    deptno INT primary key,

    dname varchar(9),

    loc varchar(10)

);

--创建员工表

CREATE TABLE employees(

    empno INT primary key,

    name char(10) not null,

    deptno INT,

    manager INT,

    hiredate date,

    salary numeric(7,2)

);

--创建经理表

CREATE TABLE managers(

    empno INT primary key,

    title varchar(16)

);

--向员工表中插入记录,包括所有字段的值

INSERT INTO employees VALUES(1,'张三',1,2,'2011-03-03',4400.00);

INSERT INTO employees VALUES(2,'王五',1,2,'2013-01-03',4100.00);

INSERT INTO employees VALUES(3,'李四',2,4,'2021-02-10',3900.00);

INSERT INTO employees VALUES(5,'李明',3,5,'2004-09-11',5200.00);

INSERT INTO employees VALUES(6,'孙军',3,5,'2016-05-22',4700.00);

INSERT INTO employees VALUES(7,'钱杰',3,5,'2013-07-22',4900.00);

INSERT INTO employees VALUES(8,'李爱国',3,5,'2013-07-25',4900.00);

--向员工表中插入记录,只包括部分字段的值

INSERT INTO employees(empno,name,salary) VALUES(4,'赵六',5000.00);

INSERT INTO employees(empno,name,hiredate,salary) VALUES(9,'刘国强','2010-4-12',5000.00);

--向部门表中插入记录

INSERT INTO dept VALUES(1,'技术部','一楼a区');

INSERT INTO dept VALUES(2,'销售部','二楼a区');

INSERT INTO dept VALUES(3,'行政部','一楼b区');

--  向经理表中插入记录

INSERT INTO managers VALUES(2,'技术部经理');

INSERT INTO managers VALUES(4,'销售部经理');

INSERT INTO managers VALUES(99,'总裁')