56,687
社区成员
发帖
与我相关
我的任务
分享
show create TABLE t_employee
CREATE TABLE `t_employee` (
`empno` int(11) DEFAULT NULL,
`ename` varchar(20) DEFAULT NULL,
`job` varchar(40) DEFAULT NULL,
`MGR` int(11) DEFAULT NULL,
`Hiredate` date DEFAULT NULL,
`sal` double(10,2) DEFAULT NULL,
`comm` double(10,2) DEFAULT NULL,
`deptno` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
INSERT INTO t_employee
VALUES
(7369, 'SMITH', 'CLERK', 7902, '1981-03-12', 800, NULL, 20),
(7499, 'ALLEN', 'SALESMAN', 7698, '1982-03-12', 1600, 300, 30),
(7521, 'WARD', 'SALESMAN', 7698, '1983-03-12', 1250, 500, 30),
(7566, 'JONES', 'MANAGER', 7839, '1981-03-12', 2975, NULL, 20),
(7654, 'MARTIN', 'SALESMAN', 7698, '1981-03-12', 1250, 1400, 30),
(7698, 'BLAKE', 'MANAGER', 7839, '1981-03-12', 2850, NULL, 30),
(7782, 'CLARK', 'MANAGER', 7839, '1985-03-12', 2450, NULL, 10),
(7788, 'SCOTT', 'ANALYST', 7566, '1981-03-12', 3000, NULL, 20),
(7839, 'KING', 'PRESIDENT', NULL, '1981-03-12', 5000, NULL, 10),
(7844, 'TURNER', 'SALESMAN', 7698, '1989-03-12', 1500, 0, 30),
(7876, 'ADAMS', 'CLERK', 7788, '1998-03-12', 1100, NULL, 20),
(7900, 'JAMES', 'CLERK', 7698, '1997-03-12', 950, NULL, 30),
(7902, 'FORD', 'ANALYST', 7566, '0000-00-10', 3000, NULL, 20),
(7934, 'MILLER', 'CLERK', 7782, '1981-03-12', 1300, NULL, 10);