how to get emp table in mysql

1DROP TABLE IF EXISTS emp;
2
3CREATE TABLE emp (
4  empno decimal(4,0) NOT NULL,
5  ename varchar(10) default NULL,
6  job varchar(9) default NULL,
7  mgr decimal(4,0) default NULL,
8  hiredate date default NULL,
9  sal decimal(7,2) default NULL,
10  comm decimal(7,2) default NULL,
11  deptno decimal(2,0) default NULL
12);
13
14DROP TABLE IF EXISTS dept;
15
16CREATE TABLE dept (
17  deptno decimal(2,0) default NULL,
18  dname varchar(14) default NULL,
19  loc varchar(13) default NULL
20);
21
22INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
23INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
24INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
25INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
26INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
27INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
28INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
29INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
30INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
31INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
32INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
33INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
34INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
35INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
36
37INSERT INTO dept VALUES ('10','ACCOUNTING','NEW YORK');
38INSERT INTO dept VALUES ('20','RESEARCH','DALLAS');
39INSERT INTO dept VALUES ('30','SALES','CHICAGO');
40INSERT INTO dept VALUES ('40','OPERATIONS','BOSTON');