最美情侣中文字幕电影,在线麻豆精品传媒,在线网站高清黄,久久黄色视频

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

【韓順平講MySQL】零基礎一周學會MySQL -sql mysql教程 m

2023-06-02 17:09 作者:就當是夢吧a  | 我要投稿

【雇員表】

CREATE TABLE dept( /*部門表*/

deptno MEDIUMINT??UNSIGNED?NOT NULL?DEFAULT 0,?

dname VARCHAR(20)?NOT NULL?DEFAULT "",

loc VARCHAR(13) NOT NULL DEFAULT ""

);


INSERT INTO dept VALUES(10, 'ACCOUNTING', 'NEW YORK'), (20, 'RESEARCH', 'DALLAS'), (30, 'SALES', 'CHICAGO'), (40, 'OPERATIONS', 'BOSTON');





#創(chuàng)建表EMP雇員

CREATE TABLE emp

(empno?MEDIUMINT UNSIGNED?NOT NULL?DEFAULT 0, /*編號*/

ename VARCHAR(20) NOT NULL DEFAULT "", /*名字*/

job VARCHAR(9) NOT NULL DEFAULT "",/*工作*/

mgr MEDIUMINT UNSIGNED ,/*上級編號*/

hiredate DATE NOT NULL,/*入職時間*/

sal DECIMAL(7,2)?NOT NULL,/*薪水*/

comm DECIMAL(7,2) ,/*紅利*/

deptno MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 /*部門編號*/

);


?

?INSERT INTO emp VALUES(7369, 'SMITH', 'CLERK', 7902, '1990-12-17', 800.00,NULL , 20),?

(7499, 'ALLEN', 'SALESMAN', 7698, '1991-2-20', 1600.00, 300.00, 30),??

(7521, 'WARD', 'SALESMAN', 7698, '1991-2-22', 1250.00, 500.00, 30),??

(7566, 'JONES', 'MANAGER', 7839, '1991-4-2', 2975.00,NULL,20),??

(7654, 'MARTIN', 'SALESMAN', 7698, '1991-9-28',1250.00,1400.00,30),??

(7698, 'BLAKE','MANAGER', 7839,'1991-5-1', 2850.00,NULL,30),??

(7782, 'CLARK','MANAGER', 7839, '1991-6-9',2450.00,NULL,10),??

(7788, 'SCOTT','ANALYST',7566, '1997-4-19',3000.00,NULL,20),??

(7839, 'KING','PRESIDENT',NULL,'1991-11-17',5000.00,NULL,10),??

(7844, 'TURNER', 'SALESMAN',7698, '1991-9-8', 1500.00, NULL,30),??

(7900, 'JAMES','CLERK',7698, '1991-12-3',950.00,NULL,30),??

(7902, 'FORD', 'ANALYST',7566,'1991-12-3',3000.00, NULL,20),??

(7934,'MILLER','CLERK',7782,'1992-1-23', 1300.00, NULL,10);




#工資級別表

CREATE TABLE salgrade

(

grade MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,

losal DECIMAL(17,2)?NOT NULL,

hisal DECIMAL(17,2)?NOT NULL

);


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 -sql mysql教程 m的評論 (共 條)

分享到微博請遵守國家法律
宝丰县| 乌拉特前旗| 大田县| 南涧| 新干县| 苏尼特右旗| 鹤壁市| 东兴市| 云霄县| 左权县| 民勤县| 汶川县| 大宁县| 深州市| 岗巴县| 惠州市| 东光县| 三都| 农安县| 富川| 禹州市| 陕西省| 永靖县| 康乐县| 通榆县| 宁德市| 盐池县| 贵定县| 敦煌市| 桃江县| 出国| 双辽市| 阿拉善右旗| 舟山市| 隆林| 封丘县| 民丰县| 墨脱县| 特克斯县| 霍邱县| 乌拉特前旗|