0-创建scott数据
数据 创建
2023-09-27 14:26:43 时间
CREATE
TABLE
dept
(
deptno
INT
PRIMARY
KEY
,
dname
VARCHAR
(14),
loc
VARCHAR
(13)
);
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'
);
CREATE
TABLE
emp
(
EMPNO
INT
(4)
PRIMARY
KEY
,
ENAME
VARCHAR
(10),
JOB
VARCHAR
(9),
MGR
INT
(4),
HIREDATE
DATE
,
SAL
DOUBLE
,
COMM
DOUBLE
,
deptno
INT
,
FOREIGN
KEY
(deptno)
REFERENCES
dept(deptno));
INSERT INTO emp VALUES
(7369,'SMITH','CLERK',7902,DATE('1980-12-17'),800,NULL,20);
INSERT INTO emp VALUES
(7499,'ALLEN','SALESMAN',7698,DATE('1981-2-20'),1600,300,30);
INSERT INTO emp VALUES
(7521,'WARD','SALESMAN',7698,DATE('1981-2-22'),1250,500,30);
INSERT INTO emp VALUES
(7566,'JONES','MANAGER',7839,DATE('1981-4-2'),2975,NULL,20);
INSERT INTO emp VALUES
(7654,'MARTIN','SALESMAN',7698,DATE('1981-9-28'),1250,1400,30);
INSERT INTO emp VALUES
(7698,'BLAKE','MANAGER',7839,DATE('1981-5-1'),2850,NULL,30);
INSERT INTO emp VALUES
(7782,'CLARK','MANAGER',7839,DATE('1981-6-9'),2450,NULL,10);
INSERT INTO emp VALUES
(7788,'SCOTT','ANALYST',7566,DATE('1987-4-19'),3000,NULL,20);
INSERT INTO emp VALUES
(7839,'KING','PRESIDENT',NULL,DATE('1981-11-17'),5000,NULL,10);
INSERT INTO emp VALUES
(7844,'TURNER','SALESMAN',7698,DATE('1981-9-8'),1500,0,30);
INSERT INTO emp VALUES
(7876,'ADAMS','CLERK',7788,DATE('1987-5-23'),1100,NULL,20);
INSERT INTO emp VALUES
(7900,'JAMES','CLERK',7698,DATE('1981-12-3'),950,NULL,30);
INSERT INTO emp VALUES
(7902,'FORD','ANALYST',7566,DATE('1981-12-3'),3000,NULL,20);
INSERT INTO emp VALUES
(7934,'MILLER','CLERK',7782,DATE('1982-1-23'),1300,NULL,10);
(7369,'SMITH','CLERK',7902,DATE('1980-12-17'),800,NULL,20);
INSERT INTO emp VALUES
(7499,'ALLEN','SALESMAN',7698,DATE('1981-2-20'),1600,300,30);
INSERT INTO emp VALUES
(7521,'WARD','SALESMAN',7698,DATE('1981-2-22'),1250,500,30);
INSERT INTO emp VALUES
(7566,'JONES','MANAGER',7839,DATE('1981-4-2'),2975,NULL,20);
INSERT INTO emp VALUES
(7654,'MARTIN','SALESMAN',7698,DATE('1981-9-28'),1250,1400,30);
INSERT INTO emp VALUES
(7698,'BLAKE','MANAGER',7839,DATE('1981-5-1'),2850,NULL,30);
INSERT INTO emp VALUES
(7782,'CLARK','MANAGER',7839,DATE('1981-6-9'),2450,NULL,10);
INSERT INTO emp VALUES
(7788,'SCOTT','ANALYST',7566,DATE('1987-4-19'),3000,NULL,20);
INSERT INTO emp VALUES
(7839,'KING','PRESIDENT',NULL,DATE('1981-11-17'),5000,NULL,10);
INSERT INTO emp VALUES
(7844,'TURNER','SALESMAN',7698,DATE('1981-9-8'),1500,0,30);
INSERT INTO emp VALUES
(7876,'ADAMS','CLERK',7788,DATE('1987-5-23'),1100,NULL,20);
INSERT INTO emp VALUES
(7900,'JAMES','CLERK',7698,DATE('1981-12-3'),950,NULL,30);
INSERT INTO emp VALUES
(7902,'FORD','ANALYST',7566,DATE('1981-12-3'),3000,NULL,20);
INSERT INTO emp VALUES
(7934,'MILLER','CLERK',7782,DATE('1982-1-23'),1300,NULL,10);
CREATE
TABLE
salgrade
(
grade
INT
PRIMARY
KEY
,
losal
INT
,
hisal
INT
);
INSERT
INTO
salgrade
VALUES
(1,700,1200);
INSERT
INTO
salgrade
VALUES
(2,1201,1400);
INSERT
INTO
salgrade
VALUES
(3,1401,2000);
INSERT
INTO
salgrade
VALUES
(4,2001,3000);
INSERT
INTO
salgrade
VALUES
(5,3001,9999);
相关文章
- mysql的安装,数据库的操作,创建数据库,修改表,创建表,删除表,插入数据mysql是什么?
- Mongo数据两表关联创建视图示例
- Google Earth Engine ——非洲净初级生产量(NPP)数据集FAO/WAPOR/2/L1_NPP_D
- 42EasyUI 数据网格- 创建子网格
- Linkedin如何用大数据变现
- 《大数据导论》导读
- 【HMS Core】运动健康服务如何读取用户数据,是否需要创建数据采集器
- 《Python数据可视化编程实战》——5.2 创建3D柱状图
- Android数据存储
- 服务器数据丢失的紧急处理办法
- 如何在 Python 中创建用于分类的模拟数据
- GIS教程之创建 GIS 数据的 web 地图最简单的方法streamlit、ellipsis 和 folium
- SwiftUI CloudKit 入门之 16 提供选项供用户从您的应用程序中删除其CloudKit数据
- 教你几招,快速创建 MySQL 五百万级数据,愉快的学习各种优化技巧
- Oracle-创建新表,创建备份表,对表中插入多条数据
- 大数据 影响电影服务生态
- 云计算在大数据形式下的发展
- 创建Ceph crush运行图实现基于HDD和SSD磁盘实现数据冷热数据分类存储
- 用大数据建设 数字化校园
- 如何在大数据视野下寻找商机
- flask+vue:创建一个数据列表并实现简单的查询功能(三)
- HttpWebRequest WebClient给远程服务器上传数据; 未能创建 SSL/TLS 安全通道;JSON字符长度超出限制;
- 如何区分数据科学家,数据工程师与数据分析师
- AT&T炮轰苹果:库克无权决定对iPhone数据加密