mysql5.7下载及安装

windows下的MySQL安装、创建数据库、创建表、删除表、新增字段、修改字段

1. 安装mysql5.7
2. 首先，进入mysql官网下载页面，https://www.mysql.com/downloads/

3.下载MySQL 我用的是5.7.25
打开下载链接：https://dev.mysql.com/downloads/windows/installer/5.7.html

点击Download进行下载 会弹出页面，点击No thanks进行下载

下载之后，打开MySQL安装程序 这个时候就可以顺利进行安装了

勾选I accept 然后 Next

这里我选择的是Custom 自定义的意思 然后Next

根据自己系统的位数进行选择是X64还是X86 点选后 点击中间的箭头
然后可以选择路径（默认安装的是C盘）

然后点击Next 点击Execute 然后Next

这个选择默认即可

服务器专用

MySQL端口默认3306 一般不建议修改 继续Next

设置MySQL密码 然后Next

这里是服务显示的名称 无特殊需要也不建议修改 继续Next

都检测通过后 点击Finish 然后继续Next 最后Finish即安装完成

4.启动mysql并进行数据库的创建、建表、查看表结构、新增字段、修改字段

管理员身份打开cmd命令行工具，cd到安装目录下：

然后输入密码，出现下图，表示成功进入

mysql> show databases;显示数据库

mysql> use yss;使用数据库
Database changed
mysql> show tables;显示表
+---------------+
| Tables_in_yss |
+---------------+
| stu_edu       |
+---------------+
1 row in set (0.00 sec)

mysql> desc stu_edu;查看表
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| stu_id           | int(11)      | NO   | PRI | NULL    |       |
| edu_from_date    | date         | NO   |     | NULL    |       |
| edu_end_date     | date         | NO   |     | NULL    |       |
| edu_degree       | varchar(50)  | NO   |     | NULL    |       |
| edu_school_id    | int(11)      | NO   |     | NULL    |       |
| edu_major_course | varchar(300) | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> create table aa( id int primary key,name char(10) not null);创建表aa
Query OK, 0 rows affected (0.04 sec)

mysql> drop table aa;删除表aa
Query OK, 0 rows affected (0.01 sec)

mysql> create table aa( id int primary key,name char(10) not null);创建表aa
Query OK, 0 rows affected (0.04 sec)

mysql> show tables;
+---------------+
| Tables_in_yss |
+---------------+
| aa            |
| stu_edu       |
| t_work1       |
+---------------+
3 rows in set (0.00 sec)

mysql> desc aa;查看aa
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| id    | int(11)  | NO   | PRI | NULL    |       |
| name  | char(10) | NO   |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> alter table aa rename bb;重命名aa为bb
Query OK, 0 rows affected (0.01 sec)

mysql> desc bb;查看bb
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| id    | int(11)  | NO   | PRI | NULL    |       |
| name  | char(10) | NO   |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> alter table bb add phone varchar(11);为bb增加字段phone
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc bb;查看bb
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name  | char(10)    | NO   |     | NULL    |       |
| phone | varchar(11) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> alter table bb modify phone varchar(15);修改bb中的phone 字段为carchar（15）
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc bb;显示bb
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name  | char(10)    | NO   |     | NULL    |       |
| phone | varchar(15) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> alter table bb change name name2 char(15);使用change修改bb
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc bb;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name2 | char(15)    | YES  |     | NULL    |       |
| phone | varchar(15) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

2019.3.16 pm