零基础轻松学mysql_零基础轻松学MySQL 5.7

前 言

第1章 数据库概述 ·····································1

1.1 数据库基本概念 ·······························1

1.1.1 数据存储方式 ·······························1

1.1.2 什么是数据库 ············································2

1.1.3 数据库的存储结构 ················&midd

前 言

第1章 数据库概述 ·····································1

1.1 数据库基本概念 ·······························1

1.1.1 数据存储方式 ·······························1

1.1.2 什么是数据库 ············································2

1.1.3 数据库的存储结构 ····································2

1.1.4 数据库在开发中的作用 ···········································4

1.2 数据库技术 ··············································4

1.2.1 数据库系统 ·······························4

1.2.2 了解SQL语言 ·······································6

1.2.3 数据库访问技术 ···············································6

1.3 认识MySQL ···············································7

1.3.1 MySQL的优势 ······································7

1.3.2 MySQL的版本 ······································8

1.3.3 如何获取MySQL ···········································8

1.4 数据库的学习方法 ···········································10

1.5 小结 ·········································11

1.6 练习题 ·····································11

第2章 安装和配置MySQL ·········································12

2.1 MySQL 5.7的新特性 ·······································12

2.2 在不同平台上安装MySQL ·····································13

2.2.1 安装条件 ··············································13

2.2.2 在Windows系统上安装MySQL ········································13

2.2.3 在Linux系统上安装MySQL ································17

2.2.4 打开MySQL数据库 ··············································20

2.3 验证MySQL是否安装成功 ············································21

2.3.1 获取服务器状态 ············································22

2.3.2 执行简单的SQL 命令 ············································22

2.4 启动服务和登录MySQL 数据库 ·······································22

2.4.1 启动MySQL 服务 ··············································22

2.4.2 登录MySQL 数据库 ··············································23

2.4.3 配置Path 变量 ·····································25

2.5 配置MySQL 数据库 ········································26

2.5.1 使用配置向导 ······································26

2.5.2 手工更改配置 ······································30

2.6 使用MySQL Workbench 图形管理工具·····································30

2.7 使用免安装的MySQL ·····································31

2.8 小结 ·········································33

2.9 练习题 ·····································33

第3 章 操作MySQL 数据库 ········································ 34

3.1 创建数据库 ································34

3.1.1 基本语法 ··············································34

3.1.2 创建并查看数据库 ·······································35

3.1.3 创建指定字符集的数据库 ·····································36

3.2 修改数据库 ··········································37

3.2.1 基本语法 ··············································37

3.2.2 修改数据库的字符集 ·············································38

3.3 删除数据库 ·············································38

3.3.1 基本语法 ··············································38

3.3.2 删除数据库 ··········································39

3.4 选择数据库 ···········································40

3.5 使用图形界面管理数据库 ·····································40

3.6 综合案例 ·······························43

3.6.1 案例目的 ··············································43

3.6.2 案例演示过程 ······································44

3.7 小结 ·········································46

3.8 练习题 ·····································46

第4 章 MySQL 存储引擎与数据类型 ········································· 47

4.1 存储引擎 ·······························47

4.1.1 什么是存储引擎 ·········································47

4.1.2 MySQL 5.7 支持的存储引擎 ·································48

4.1.3 如何选择存储引擎 ··············································48

4.1.4 操作默认存储引擎 ·············································49

4.2 数据类型 ·······························49

4.2.1 整数类型 ··············································50

4.2.2 浮点数类型和定点数类型 ·····································51

4.2.3 日期与时间类型 ········································52

4.2.4 字符串和二进制类型 ··········································55

4.3 综合案例 ·······························59

4.3.1 案例目的 ··············································59

4.3.2 案例演示过程 ······································59

4.4 小结 ·········································60

4.5 练习题 ·····································60

第5 章 操 作 表 ········································ 62

5.1 表的基本概念 ··································62

5.2 创建表 ·····································62

5.2.1 基本语法 ··············································62

5.2.2 在指定的数据库中创建表 ·····································63

5.2.3 查看表结构 ··········································64

5.3 修改表 ·····································65

5.3.1 基本语法 ··············································66

5.3.2 添加字段 ··············································66

5.3.3 修改字段数据类型 ································67

5.3.4 删除字段 ··························