MySQL5.7.9.1解压版配置与数据库创建

MYSQL-5.7.9.1解压版
例如我的在D:\Program Files\MySQL\MySQL Server 5.7（解压时名字mysql-installer-community-5.7.9.1可以自己修改名称）
MySQL Server 5.7中的my-default.ini修改：
# These are commonly set, remove the # and set as required.
# basedir = D:\Program Files\MySQL\MySQL Server 5.7（MySQL Server 5.7是自己的修改过的名称）
# datadir = D:\Program Files\MySQL\MySQL Server 5.7\data (MySQL Server 5.7没有data新建data)
# port = 3306
# server_id = .....

配置变量：
电脑->右键属性->高级系统设置->环境变量->系统变量->Path
双击Path，在最后面添加英文分号“;”然后添加mysql存放目录，如：D:\Program Files\MySQL\MySQL Server 5.7\bin
命令提示符（管理员）>进入到MYSQL存放目录，
C:\Windows\system32>d:

D:\>cd "Program Files"

D:\Program Files>

D:\Program Files>cd MySQL

D:\Program Files\MySQL>cd My按tab键 然后回车

D:\Program Files\MySQL\MySQL Server 5.7>

D:\Program Files\MySQL\MySQL Server 5.7>cd bin 然后回车

D:\Program Files\MySQL\MySQL Server 5.7\bin>

D:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --initialize-insecure --user=mysql

D:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld install
Service successfully installed.

D:\Program Files\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


D:\Program Files\MySQL\MySQL Server 5.7\bin>

新建数据库
C:\Windows\system32>mysql -u root -p //登陆数据库
Enter password: ****** //输入密码，如果没有不用输入直接回车
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test2; //创建数据库
Query OK, 1 row affected (0.00 sec)

mysql> drop database test2; //删除数据库
Query OK, 0 rows affected (0.00 sec)

mysql> create database test2; //刚刚删除了重新创建数据库
mysql> use test2; //说明在哪个数据库里创建表
Database changed
mysql> create table student( //创建表
-> sno int not null primary key,
-> sname varchar(10) not null,
-> saddress varchar(40)
-> );

mysql> insert into student values(1000, ' 张三' , '上海徐汇' ); //插入数据

mysql> insert into student values(1001, ' 李四' , '上海普陀' );

mysql> insert into student values(1002, ' 王五', '上海金山' );

mysql> insert into student values(1003, ' 马六', '上海松江' );

mysql> insert into student values(1004, ' 马七', '上海松江' );

mysql>
//修改表名
mysql> use test2; //说明修改那个数据库里的表名

mysql> alter table student rename to student1; //student是旧的名字，student1是新的名字
mysql> desc student; //查看修改后的表的结构
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| sno | int(1

1) | NO | PRI | NULL | |
| sname | varchar(10) | NO | | NULL | |
| saddress | varchar(40) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+

mysql>alter table student change sno student_sno varchar(15); //修改数据库表的字段名，sno是旧名，student_sno是新名

mysql>drop table student;//删除数据表
mysql> select * from student;//查看数据表
+------+-------+----------+
| sno | sname | saddress |
+------+-------+----------+
| 1000 | 张三 | 上海徐汇 |
| 1001 | 李四 | 上海普陀 |
| 1002 | 王五 | 上海金山 |
| 1003 | 马六 | 上海松江 |
| 1004 | 马七 | 上海松江 |
+------+-------+----------+
//修改数据
mysql> update student set sname='小一'saddress='shhai' where sno=1000;
mysql> update student set sname='李二',saddress='上海虹桥 ' where sno=1001;
mysql> update student set sname='李三',saddress='上海松江 'where sno=1002 ; update student set sname='王四 ' where sno=1003;
mysql> update student set sname='马五 ' where sname='王晶';
mysql> select * from student;
+------+-------+-----------+
| sno | sname | saddress |
+------+-------+-----------+
| 1000 | 小一 | shhai |
| 1001 | 李二 | 上海虹桥 |
| 1002 | 李三 | 上海松江 |
| 1003 | 王四 | 上海松江 |
| 1004 | 马五 | 上海松江 |
+------+-------+-----------+

//删除数据
mysql> delete from student where sname='马五';
mysql> delete from student where sno=1003;
mysql> select * from student;
+------+-------+-----------+
| sno | sname | saddress |
+------+-------+-----------+
| 1000 | 小一 | shhai |
| 1001 | 李二 | 上海虹桥 |
| 1002 | 李三 | 上海松江 |
+------+-------+-----------+