MySQL安装与案例

一，下载安装包

进入MySQL官网www.mysql.com

点击进行下载，完成后双击打开根据提示完成安装

注意:安装路径必须全面英文！

二，配置环境变量

1.桌面选择此电脑，右键选择“属性”；

2.选择高级属性

 

选择path，点击编辑

配置完成！

三. 创建一个数据库`db_classes`

mysql> create database db_classes;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| db_classes         |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| user               |
+--------------------+
6 rows in set (0.00 sec)

四，创建一行表`db_hero`

mysql> use db_classes;
Database changed

mysql> desc db_hero;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id       | int          | YES  |     | NULL    |       |
| name     | varchar(100) | YES  |     | NULL    |       |
| nickname | varchar(100) | YES  |     | NULL    |       |
| age      | int          | YES  |     | NULL    |       |
| gebder   | varchar(100) | YES  |     | NULL    |       |
| address  | varchar(100) | YES  |     | NULL    |       |
| weapon   | varchar(100) | YES  |     | NULL    |       |
| word     | varchar(100) | YES  |     | NULL    |       |
| types    | varchar(100) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

五. 将四大名著中的常见人物插入这个英雄表