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主从复制实现原理及配置)
- mysql数据类型
- mysql如何给一个表批量添加字段(mysql从一张表查询批量数据并插入到另一表中的完整实例)
- mysql集群是用什么搭建的(MySQL5.7 集群配置的步骤)
- mysql把重复数据删掉(mysql查找删除重复数据并只保留一条实例详解)
- mysql改root密码命令(MySQL root密码的重置方法)
- mysql简单查询基本语句(详解MySQL 查询语句的执行过程)
- mysql重复插入数据教程(Mysql避免重复插入数据的4种方式)
- docker进入mysql查看路径(Docker 环境运行 Mysql 和开启 Binlog 配置主从同步的设置方法)
- windows 安装解压版 mysql5.7.28 winx64的详细教程(windows 安装解压版 mysql5.7.28 winx64的详细教程)
- mysql架构图(深入了解Mysql逻辑架构)
- mysql和utf8哪个好(为什么在MySQL中不建议使用UTF-8)
- mysql创建表的基本步骤(mysql中操作表常用的sql总结)
- mysql 时间戳获取(MySQL时间盲注的五种延时方法实现)
- centos安装mysql8.0教程(Centos7 安装 Mysql8教程)
- mysql单个表可以储存多少内容(浅谈mysql一张表到底能存多少数据)
- 2021款起亚霸锐到店了 更换车标,竞争宝马X5有戏吗(2021款起亚霸锐到店了)
- 新款起亚霸锐实拍,比普拉多气派,配3.0T V6,引入国内或许能大卖(新款起亚霸锐实拍)
- ()
- 张勇 阿里新任掌门人(阿里新任掌门人)
- 毛戈平全国第一柜花落银泰 高端国货迎来 高光 时刻(毛戈平全国第一柜花落银泰)
- 14岁丧父 20岁丧母,从苦难走向辉煌的银泰创始人沈国军(14岁丧父20岁丧母从苦难走向辉煌的银泰创始人沈国军)
热门推荐
- vue过滤器使用思路(vue 过滤器和自定义指令的使用)
- IT技术类在团队管理上的几个建议
- JavaScript中实现AES加密解密
- JavaScript css3实现简单视频弹幕功能(JavaScript css3实现简单视频弹幕功能)
- mysql怎么使用null(MySQL null与not null和null与空值''''的区别详解)
- pythonselenium怎么设置元素(Python2 Selenium元素定位的实现8种)
- 开发中常用工具推荐
- Css Reset的作用
- python爬虫并保存excel实例(Python实现爬取亚马逊数据并打印出Excel文件操作示例)
- web服务器架设步骤及流程(web服务器怎么配置?web服务器配置图文教程)
排行榜
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9