--創(chuàng)建公司數(shù)據(jù)庫(kù)

CREATE DATABASE company;

--創(chuàng)建部門表

CREATE TABLE dept(

? ? deptno INT primary key,

? ? dname varchar(9),

? ? loc varchar(10)

);

--創(chuàng)建員工表

CREATE TABLE employees(

? ? empno INT primary key,

? ? name char(10) not null,

? ? deptno INT,

? ? manager INT,

? ? hiredate date,

? ? salary numeric(7,2)

);

--創(chuàng)建經(jīng)理表

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,'李愛國(guó)',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,'劉國(guó)強(qiáng)','2010-4-12',5000.00);

--向部門表中插入記錄

INSERT INTO dept VALUES(1,'技術(shù)部','一樓a區(qū)');

INSERT INTO dept VALUES(2,'銷售部','二樓a區(qū)');

INSERT INTO dept VALUES(3,'行政部','一樓b區(qū)');

-- ?向經(jīng)理表中插入記錄

INSERT INTO managers VALUES(2,'技術(shù)部經(jīng)理');

INSERT INTO managers VALUES(4,'銷售部經(jīng)理');

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