表结构
dept(部门表)
deptno 部门编号
loc 部门位置
dname 部门名
emp(员工表)
empno 员工编号
ename 员工姓名
sal 员工奖金
comm 员工佣金
job 员工职务
mgr 员工上司编号
deptno 员工所属部门
创建表并插入信息
创建部门表
create table dept
(
deptno int(11) not null primary key,
loc varchar(300),
dname varchar(100)
)DEFAULT CHARSET=gb2312;
创建员工表
CREATE TABLE emp
(
empno INT NOT NULL PRIMARY KEY,
ename VARCHAR(30),
job VARCHAR(30),
mgr INT,
datet DATETIME,
sal FLOAT,
comm FLOAT,
deptno INT
)DEFAULT CHARSET=gb2312;
INSERT INTO dept VALUES(10,'ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES(20,'RESEARCH','DALLAS');
INSERT INTO dept VALUES(30,'SALES','CHICAGO');
INSERT INTO dept VALUES(40,'OPERATIONS','BOSTON');
INSERT INTO emp VALUES(7369,'SMITH','CLERK'/*职员*/,7902,'1980-12-17',1456.00,800.00,20);
INSERT INTO emp VALUES(7499,'ALLEN',