今日完成的事情：

1、重新安装了mysql，并配置环境变量

2、解决mysql与navicat编码不统一的状况

3、初步了解索引的概念

明天计划的事情：

1、给表格建立索引

2、思索mysql相关问题

3、下载java7

收获：

1、下载并配置安装5.7版MySQL， MIS根据百度经验没有安装成功；然后根据博客园安装了zip版，最后在哥们的帮助下安装好了zip版；下面记录了具体步骤以及遇到的问题及解决办法：

首先是官网下载对应型号的社区版zip版，然后解压到D。

配置环境变量，在path中新建：D:\mysql-5.7.12-winx64\bin;

在D:\mysql-5.7.12-winx64中，新建一个data文件夹，然后新建my.ini并且对mysql进行配置。内容为：              

          [client]

          port=3306

          default-character-set=utf8

          [mysqld]

          port=3306

          character_set_server=utf8

          #解压目录

          basedir=D:\mysql-5.7.12-winx64

         #解压目录下data目录

         datadir=D:\mysql-5.7.12-winx64\data

         sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

在bin目录下运行powershell，快捷键是鼠标右键加shift；

D:\mysql\mysql-5.7.19-winx64\bin> mysqld --skip-grant-tables

PS D:\mysql\mysql-5.7.19-winx64\bin> mysql -u root -p

2、解决mysql与navicat编码不统一的状况，在MySQL中又重新做了之前的表格，在navicat中进行了检测，编码不统一的状况没有了,用了新的命令行软件cmder，复习之前的sql语句；

λ mysql -uroot -p
Enter password: ****

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| llll           |
+----------------+
1 row in set (0.00 sec)

mysql> select *from llll;
+----+----------+-----------+-----------+-----------+------+------------+--------------------+----------+------------+--------------+--------------+--------+
| id | create_a | update_at | name      | qq        | type | begin      | graschool          | code     | link       | pledge       | knowfrom     | bro    |
+----+----------+-----------+-----------+-----------+------+------------+--------------------+----------+------------+--------------+--------------+--------+
|  1 |     NULL |      NULL | donwinhal | 891973544 | java | 2013-09-01 | 天津科技大学       | 13031103 | www.com.cn | 老大最帅     | 朋友推荐     | 陈昊   |
+----+----------+-----------+-----------+-----------+------+------------+--------------------+----------+------------+--------------+--------------+--------+
1 row in set (0.00 sec)

mysql> show create database test;
+----------+---------------------------------------------------------------+
| Database | Create Database                                               |
+----------+---------------------------------------------------------------+
| test     | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> create database oo;
Query OK, 1 row affected (0.00 sec)

mysql> show create database oo;
+----------+-------------------------------------------------------------+
| Database | Create Database                                             |
+----------+-------------------------------------------------------------+
| oo       | CREATE DATABASE `oo` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> use oo;
Database changed
mysql> CREATE TABLE `dd` (   `name` varchar(25) DEFAULT NULL,   `qq` int(11) DEFAULT NULL,   `type` varchar(35) DEFAULT NULL,   `begin` date DEFAULT NULL,   `graschool` varchar(40) DEFAULT NULL,   `code` int(11) DEFAULT NULL,   `link` varchar(50) DEFAULT NULL,   `pledge` varchar(50) DEFAULT NULL,   `knowfrom` varchar(50) DEFAULT NULL,
   `bro` varchar(15) DEFAULT NULL);
Query OK, 0 rows affected (0.18 sec)

mysql> insert into dd values('donwinhal',891973544,'java','2013.9.1', '天津科技大学',130311,'www.wschool.com.cn','不努力胖三斤','朋荐','陈昊');
Query OK, 1 row affected (0.07 sec)

mysql> insert into dd values('donwinhal',891973544,'java','2013.9.1', '天津科技大学',130311,'www.wschool.com.cn','不努力胖三斤','朋荐','陈昊');
Query OK, 1 row affected (0.08 sec)

mysql> select *from dd;
+-----------+-----------+------+------------+--------------------+--------+--------------------+--------------------+----------+--------+
| name      | qq        | type | begin      | graschool          | code   | link               | pledge             | knowfrom | bro    |
+-----------+-----------+------+------------+--------------------+--------+--------------------+--------------------+----------+--------+
| donwinhal | 891973544 | java | 2013-09-01 | 天津科技大学       | 130311 | www.wschool.com.cn | 不努力胖三斤       | 朋荐     | 陈昊   |
| donwinhal | 891973544 | java | 2013-09-01 | 天津科技大学       | 130311 | www.wschool.com.cn | 不努力胖三斤       | 朋荐     | 陈昊   |
+-----------+-----------+------+------------+--------------------+--------+--------------------+--------------------+----------+--------+
2 rows in set (0.00 sec)

最后在navicat上也进行了一下检测，发现编码也统一了。

ps：师兄，由于停电的原因今天也只能写这么多了，电脑连着手机热点也是挺耗流量的！！！