MySQL环境安装

版本：8.0.17.0

运行环境：windows 10 

1.

2.选择自定义安装

3.选择64位

 

 4.点击下一步

 5.开始安装

6.点击下一步

 

 

 

7.设置密码

 

8.下一步

 

 

 9.安装完成

 

10.配置环境变量

 

11.打开cmd指令窗口

输入

MySQL -V

 

12.输入

mysql -uroot -p

13.输入密码

 

14.创建数据库db_classes，创建表db_hero，并添加数据

create database db_classes; //创建数据库

show databases; //查看所有数据库

use db_classes; //修改数据库

mysql> create table db_hero(   //创建表
    -> id int,
    -> name varchar(50),
    -> nickname varchar(50),
    -> age int,
    -> gender varchar(1),
    -> address varchar(20),
    -> weapon varchar(20),
    -> word varchar(20),
    -> types varchar(10))
    -> ;

desc db_hero; //描述表


//插入数据到表db_hero
insert into db_hero values(1,"孙悟空","齐天大圣",700,"男","花果山","金箍棒","西游记","妖族");
insert into db_hero values(2,"唐三藏","唐僧",30,"男","长安","禅杖","西游记","人族");
insert into db_hero values(3,"武松","行者",30,"男","梁山","拳头","水浒传","人族");
insert into db_hero values(4,"猪八戒","天蓬元帅",800,"男","高老庄","九齿钉耙","西游记","妖族");
insert into db_hero values(5,"沙僧","卷帘大将",800,"男","流沙河","降妖宝杖","西游记","妖族");
insert into db_hero values(6,"宋江","及时雨",40,"男","梁山","朴刀","水浒传","人族");
insert into db_hero values(7,"诸葛亮","武侯",50,"男","蜀地","朱雀羽扇","三国演义","人族");
insert into db_hero values(8,"关羽","武圣",55,"男","蜀地","青龙偃月刀","三国演义","人族");
insert into db_hero values(9,"林黛玉","林妹妹",17,"女","潇湘馆","无","红楼梦","人族");

 select * from db_hero; //查询表db_hero的所有

 15.结果