oracle如何用脚本文件创建表空间(MySQL版oracle下scott用户建表语句实例)
类别:数据库 浏览量:264
时间:2021-10-28 10:59:56 oracle如何用脚本文件创建表空间
MySQL版oracle下scott用户建表语句实例概述:
Oracle scott用户下四张表,比较便于做实验,验证数据,现修改为MySQL版本
1.部门表 --dept
2.员工表 --emp
3.工资等级表 --salgrade
4.奖金表 --bonus
dept
|
-- Create table create 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) ; |
|
insert into DEPT(DEPTNO, DNAME, LOC) values ( '10' , 'ACCOUNTING' , 'NEW YORK' ); insert into DEPT(DEPTNO, DNAME, LOC) values ( '20' , 'RESEARCH' , 'DALLAS' ); insert into DEPT(DEPTNO, DNAME, LOC) values ( '30' , 'SALES' , 'CHICAGO' ); insert into DEPT(DEPTNO, DNAME, LOC) values ( '40' , 'OPERATIONS' , 'BOSTON' ); |
emp
|
-- Create table create 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); |
|
insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7369' , 'SMITH' , 'CLERK' , '7902' , '1980-12-17' , '800' , null , '20' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7499' , 'ALLEN' , 'SALESMAN' , '7698' , '1981-02-20' , '1600' , '300' , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7521' , 'WARD' , 'SALESMAN' , '7698' , '1981-02-22' , '1250' , '500' , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7566' , 'JONES' , 'MANAGER' , '7839' , '1981-04-02' , '2975' , null , '20' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7654' , 'MARTIN' , 'SALESMAN' , '7698' , '1981-09-28' , '1250' , '1400' , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7698' , 'BLAKE' , 'MANAGER' , '7839' , '1981-05-01' , '2850' , null , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7782' , 'CLARK' , 'MANAGER' , '7839' , '1981-06-09' , '2450' , null , '10' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7788' , 'SCOTT' , 'ANALYST' , '7566' , '1987-06-13' , '3000' , null , '20' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7839' , 'KING' , 'PRESIDENT' , null , '1981-11-17' , '5000' , null , '10' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7844' , 'TURNER' , 'SALESMAN' , '7698' , '1981-09-08' , '1500' , '0' , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7876' , 'ADAMS' , 'CLERK' , '7788' , '1987-06-13' , '1100' , null , '20' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7900' , 'JAMES' , 'CLERK' , '7698' , '1981-12-03' , '950' , null , '30' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7902' , 'FORD' , 'ANALYST' , '7566' , '1981-12-03' , '3000' , null , '20' ); insert into EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values ( '7934' , 'MILLER' , 'CLERK' , '7782' , '1982-01-23' , '1300' , null , '10' ); |
salgrade
|
create table SALGRADE ( grade INT , losal INT , hisal INT ) engine=InnoDB charset=utf8; |
|
insert into SALGRADE(GRADE, LOSAL, HISAL) values ( '1' , '700' , '1200' ); insert into SALGRADE(GRADE, LOSAL, HISAL) values ( '2' , '1201' , '1400' ); insert into SALGRADE(GRADE, LOSAL, HISAL) values ( '3' , '1401' , '2000' ); insert into SALGRADE(GRADE, LOSAL, HISAL) values ( '4' , '2001' , '3000' ); insert into SALGRADE(GRADE, LOSAL, HISAL) values ( '5' , '3001' , '9999' ); |
bonus
|
create table BONUS ( ename VARCHAR (10), job VARCHAR (9), sal INT , comm INT ) engine=InnoDB charset=utf8 ; |
总结
到此这篇关于MySQL版oracle下scott用户建表语句的文章就介绍到这了,更多相关MySQL版oracle scott用户建表内容请搜索开心学习网以前的文章或继续浏览下面的相关文章希望大家以后多多支持开心学习网!
原文链接:https://www.jianshu.com/p/532fe68924cb
您可能感兴趣
- mysql数据库基本增删改查基本语句(MySQL表的增删改查基础教程)
- 2021-10-04 01:06:07
- mysql8.0.20安装教程图解(mysql 8.0.24 安装配置方法图文教程)
- mysql的存储方法(MySQL中的binary类型使用操作)
- 如何打开mysql8.0客户端服务(MySQL mysqladmin客户端的使用简介)
- mysql分组函数入门(详解MySQL 数据分组)
- mysql索引面试总结(Mysql数据库索引面试题程序员基础技能)
- mysql的视图和临时表区别(MySQL 内存表和临时表的用法详解)
- centosdocker镜像安装mysql(linux下利用Docker安装mysql的步骤)
- mysql中修改表的字段名(MySQL 使用SQL语句修改表名的实现)
- mysql8修改默认端口(MySQL 8.0新特性 — 管理端口的使用简介)
- 在php中与数据库连接的技术(PHP7.0连接DB操作实例分析基于mysqli)
- mysql的binlog日志详解(MySQL 有关MHA搭建与切换的几个错误log汇总)
- php7用什么替代mysql(mysqli扩展无法在PHP7下升级问题的解决)
- mysql存储过程定义表(MySQL存储过程的创建、调用与管理详解)
- MySQL中使用mysqldump命令备份
- 吴启华与曾舜晞两代张无忌同框,戏里经典的他却没活出原著的潇洒(吴启华与曾舜晞两代张无忌同框)
- 经常发这三种 朋友圈 的人,要迅速屏蔽(经常发这三种朋友圈)
- 有种尴尬叫朋友圈忘屏蔽,大学生上演社死现场,父母亲自下场吐槽(有种尴尬叫朋友圈忘屏蔽)
- 朋友圈屏蔽你的人,可以直接看淡了(朋友圈屏蔽你的人)
- 金球奖只青睐那些会戴珠宝的女人(金球奖只青睐那些会戴珠宝的女人)
- 浙江省一个县,人口超40万,建县历史超1100年(浙江省一个县人口超40万)
热门推荐
- dedecms文章怎么发(批量替换织梦DedeCMS所有文章来源和作者的方法)
- python3的循环怎么用(对Python3 goto 语句的使用方法详解)
- C#中ArrayList与Array的区别
- js回调函数原理(关于JavaScript回调函数的深入理解)
- centos搭建sftp服务器(Linux云服务器搭建SFTP服务器图片服务器的操作)
- 带农历的js日期控件
- docker配置和启动(Docker的安装与配置命令代码实例)
- 小鸟云怎么登录服务器(小鸟云服务器登陆图文教程)
- 动画用css3还是js(前端制作动画的几种方式css3,js)
- dedecms如何更改主页模板(织梦dedecms sitemap路径修改方法)
排行榜
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9