MySQL版oracle下scott用户建表语句实例

概述:

Oracle scott用户下四张表,比较便于做实验，验证数据，现修改为MySQL版本

1.部门表 --dept

2.员工表 --emp

3.工资等级表 --salgrade

4.奖金表 --bonus

dept

-- Create tablecreate table DEPT( deptno INT(2) not null, dname VARCHAR(14), loc VARCHAR(13)) engine=InnoDB charset=utf8; -- Create/Recreate primary, unique and foreign key constraints alter table DEPT add constraint PK_DEPT primary key (DEPTNO);

-- Create tablecreate table EMP( empno INT(4) not null, ename VARCHAR(10), job  VARCHAR(9), mgr  INT(4), hiredate DATE, sal  decimal(7,2), comm  decimal(7,2), deptno INT(2)) engine=InnoDB charset=utf8;-- Create/Recreate primary, unique and foreign key constraints alter table EMP add constraint PK_EMP primary key (EMPNO);alter table EMP add constraint FK_DEPTNO foreign key (DEPTNO) references DEPT (DEPTNO);

create table SALGRADE( grade INT, losal INT, hisal INT) engine=InnoDB charset=utf8;

create table BONUS( ename VARCHAR(10), job VARCHAR(9), sal INT, comm INT) engine=InnoDB charset=utf8 ;

更多相关文章

随机推荐