数据库实验

实验要求：新建数据库表pet

实验过程：

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uLiuKeling -p867425

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 58

Server version: 5.7.25-log MySQL Community Server (GPL)

 

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

新建数据库

mysql> create database magnerie;    

Query OK, 1 row affected (0.00 sec)

使用数据库menagerie

mysql> USE menagerie;  

Database changed

在menagerie数据库中新建数据表pet，并定义数据字段

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),

    ->        species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

Query OK, 0 rows affected (0.02 sec)

查看数据库表

mysql> DESCRIBE pet;

+---------+-------------+------+-----+---------+-------+

| Field   | Type        | Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+

| name    | varchar(20) | YES  |     | NULL    |       |

| owner   | varchar(20) | YES  |     | NULL    |       |

| species | varchar(20) | YES  |     | NULL    |       |

| sex     | char(1)     | YES  |     | NULL    |       |

| birth   | date        | YES  |     | NULL    |       |

| death   | date        | YES  |     | NULL    |       |

+---------+-------------+------+-----+---------+-------+

6 rows in set (0.00 sec)

 

从本地文件导入数据

mysql> LOAD DATA LOCAL INFILE 'F:/Linux/la.txt' INTO TABLE pet;

Query OK, 9 rows affected, 10 warnings (0.01 sec)

Records: 9  Deleted: 0  Skipped: 0  Warnings: 10

显示pet表所有内容

mysql> select * from pet;

+----------+--------+---------+------+------------+------------+

| name     | owner  | species | sex  | birth      | death      |

+----------+--------+---------+------+------------+------------+

| name     | owner  | species | s    | 0000-00-00 | 0000-00-00 |

| Fluffy   | Harold | cat     | f    | 1993-02-04 | 0000-00-00 |

| Claws    | Gwen   | cat     | m    | 1994-03-17 | 0000-00-00 |

| Buffy    | Harold | dog     | f    | 1989-05-13 | 0000-00-00 |

| Fang     | Benny  | dog     | m    | 1990-08-27 | 0000-00-00 |

| Bowser   | Diane  | dog     | m    | 1979-08-31 | 1995-07-29 |

| Chirpy   | Gwen   | bird    | f    | 1998-09-11 | 0000-00-00 |

| Whistler | Gwen   | bird    |      | 1997-12-09 | 0000-00-00 |

| Slim     | Benny  | snake   | m    | 1996-04-29 | 0000-00-00 |

+----------+--------+---------+------+------------+------------+

9 rows in set (0.00 sec)

 

实验截图：