Mysql-why is this error reported when I import an SQL table to MYSQL?

Start importing ----------. Upload image description (img.ask.csdn.netupload201601201453302810_229193.jpg) then prompt --------! IMG (img.ask.csdn.netupload201601201453302849_428711.jpg) file path :! [Image description] (img. ask. csdn. netupload201601201453303336_23412... mysql1_ql

Start importing ----------

Then I will prompt --------.

File path:

The path I selected is correct: D: \ Source code \ download storage \ day7-mysql multi table \ data and job \ EMPDEPT. SQL

The information Log is as follows:

[Err] 1051-Unknown table 'dept'
[Err] -- ------------------------------
-- Table structure for DEPT

DROP TABLEDEPT;
CREATE TABLEDEPT(
DEPTNOBigint primary key AUTO_INCREMENT,
DNAMEVARCHAR (20 ),
LOCVARCHAR (20)
);

-- Records of DEPT

INSERTDEPTVALUES (10, 'accounting', 'New YORK ');
INSERTDEPTVALUES (20, 'Research ', 'Dallas ');
INSERTDEPTVALUES (30, 'sales', 'Chicago ');
INSERTDEPTVALUES (40, 'operations', 'Boston ');

-- Table structure for EMP

DROP TABLEEMP;
CREATE TABLEEMP(
EMPNOBigint primary key AUTO_INCREMENT,
ENAMEVARCHAR (20 ),
JOBVARCHAR (20 ),
MGRBIGINT,
HIREDATEDATE,
SALDOUBLE (7,2 ),
COMMDOUBLE (7,2 ),
DEPTNOBIGINT (2)
);

-- Records of EMP

INSERTEMPVALUES (7369, 'Smith ', 'cler', 7902, '2017-12-17', 1980, NULL, 20 );
INSERTEMPVALUES (7499, 'Allen ', 'Salesman', 7698, '2017-02-20', 1981, 30 );
INSERTEMPVALUES (7521, 'ward ', 'salesman', 7698, '2017-02-22 ', 1981, 30 );
INSERTEMPVALUES (7566, 'Jones ', 'manager', 7839, '2017-04-02', 1981, NULL, 20 );
INSERTEMPVALUES (7654, 'Martin ', 'salesman', 7698, '2017-09-28 ', 1981 0, 30 );
INSERTEMPVALUES (7698, 'bucket', 'manager', 7839, '2017-05-01 ', 1981, NULL, 30 );
INSERTEMPVALUES (7782, 'Clark', 'manager', 7839, '2017-06-09 ', 1981, NULL, 10 );
INSERTEMPVALUES (7788, 'Scott ', 'Analyst', 7566, '2017-04-19', 1987, NULL, 20 );
INSERTEMPVALUES (7839, 'King', 'President ', NULL, '2017-11-17', 1981, NULL, 10 );
INSERTEMPVALUES (7844, 'Turner ', 'Salesman', 7698, '2017-09-08', 1981, 0, 30 );
INSERTEMPVALUES (7876, 'Adams', 'cler', 7788, '2017-05-23 ', 1987, NULL, 20 );
INSERTEMPVALUES (7900, 'James ', 'cler', 7698, '2017-12-03', 1981, NULL, 30 );
INSERTEMPVALUES (7902, 'Ford ', 'Analyst', 7566, '2017-12-03', 1981, NULL, 20 );
INSERTEMPVALUES (7934, 'Miller ', 'cler', 7782, '2017-01-23', 1982, NULL, 10 );

[Msg] Finished-Unsuccessfully