mysql> create table dept_manager(
-> dept_no varchar(10) primary key not null,
-> emp_no int not null,
-> birth_date date,
-> worktime date);
Query OK, 0 rows affected (0.10 sec)
mysql> source /root/load_dept_manager.dump
ERROR 1062 (23000): Duplicate entry 'd001' for key 'PRIMARY'
mysql> drop table dept_manager;
Query OK, 0 rows affected (0.03 sec)
mysql> create table dept_manager( dept_no varchar(10) not null, emp_no int not null, birth_date date, worktime date);
Query OK, 0 rows affected (0.08 sec)
mysql> source /root/load_dept_manager.dump
Query OK, 24 rows affected (0.03 sec)
Records: 24 Duplicates: 0 Warnings: 0
mysql> select * from dept_manager limit 10;
+---------+--------+------------+------------+
| dept_no | emp_no | birth_date | worktime |
+---------+--------+------------+------------+
| d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 |
+---------+--------+------------+------------+
10 rows in set (0.00 sec)
mysql> exit
-> dept_no varchar(10) primary key not null,
-> emp_no int not null,
-> birth_date date,
-> worktime date);
Query OK, 0 rows affected (0.10 sec)
mysql> source /root/load_dept_manager.dump
ERROR 1062 (23000): Duplicate entry 'd001' for key 'PRIMARY'
mysql> drop table dept_manager;
Query OK, 0 rows affected (0.03 sec)
mysql> create table dept_manager( dept_no varchar(10) not null, emp_no int not null, birth_date date, worktime date);
Query OK, 0 rows affected (0.08 sec)
mysql> source /root/load_dept_manager.dump
Query OK, 24 rows affected (0.03 sec)
Records: 24 Duplicates: 0 Warnings: 0
mysql> select * from dept_manager limit 10;
+---------+--------+------------+------------+
| dept_no | emp_no | birth_date | worktime |
+---------+--------+------------+------------+
| d001 | 110022 | 1985-01-01 | 1991-10-01 |
| d001 | 110039 | 1991-10-01 | 9999-01-01 |
| d002 | 110085 | 1985-01-01 | 1989-12-17 |
| d002 | 110114 | 1989-12-17 | 9999-01-01 |
| d003 | 110183 | 1985-01-01 | 1992-03-21 |
| d003 | 110228 | 1992-03-21 | 9999-01-01 |
| d004 | 110303 | 1985-01-01 | 1988-09-09 |
| d004 | 110344 | 1988-09-09 | 1992-08-02 |
| d004 | 110386 | 1992-08-02 | 1996-08-30 |
| d004 | 110420 | 1996-08-30 | 9999-01-01 |
+---------+--------+------------+------------+
10 rows in set (0.00 sec)
mysql> exit