mysql的使用12

来源：互联网发布：再生龙安装linux 编辑：程序博客网时间：2024/04/29 19:00

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

0 0