Mysql
技术点汇总
目录
Mysql 技术点汇总 .......................................................................................................................... 1
0.DBA 工作管理 .............................................................................................................................. 4
0.1 开发 DBA 如何有效地保障数据库应用的质量............................................................... 4
0.2 DBA 工作职责 ................................................................................................................... 7
0.3 大型应用设计中的数据库架构 ....................................................................................... 10
1.MySQL 找回超级管理员 root 密码的 ....................................................................................... 12
1.1 windows 下找回 root 密码的方法 ................................................................................... 12
1.2 linux 下找回 root 密码的方法 ......................................................................................... 13
2.MySQL 常用命令汇总 ................................................................................................................ 14
2.1 常用基本命令 .................................................................................................................. 14
2.2 MySQL 帮助的使用 ........................................................................................................ 18
2.2.1 按照层次看帮助 ................................................................................................... 18
2.2.2 快速查阅帮助 ....................................................................................................... 19
3.MySQL 的安装与配置 ................................................................................................................ 20
3.1 Windows 修改 MySQL 默认的安装目录和数据目录 .................................................... 20
3.2 Linux 下 MySQL 的安装与配置 ..................................................................................... 20
3.3 源码安装的性能考虑 ...................................................................................................... 22
3.4 mysqld_safe 读取 my.cnf 顺序 ........................................................................................ 24
3.5 Innodb plugins 安装 .......................................................................................................... 24
3.6 MySQL 的 information_schema 数据库 .......................................................................... 26
4.MySQL 的字符集 ....................................................................................................................... 28
4.1 Mysql 支持的字符集简介................................................................................................ 28
4.2 Mysql 字符集的设置 ....................................................................................................... 29
4.3 怎样选择合适的字符集 .................................................................................................. 32
4.4 深入 Mysql 字符集设置查询出现乱码及字符集详解 .................................................. 32
4.4.1. 字符集基本概念 .................................................................................................. 32
4.4.2 MySQL 中的字符集转换过程 .............................................................................. 33
5.标准的 SQL 语法及 Mysql 的扩展语法 .................................................................................... 35
5.1 MySQL 语法 –DDL 语句 ............................................................................................... 36
5.2 MySQL 语法 –DML 语句 .............................................................................................. 41
5.3 MySQL 语法 --SELECT 语句........................................................................................ 42
5.4 MySQL 语法 --DCL 语句 .............................................................................................. 42
6.MySQL 的基本数据类型和运算符 ............................................................................................ 43
6.1 数值类型 .......................................................................................................................... 43
6.1.1 整数类型 ................................................................................................................ 43
6.1.2 浮点数类型 ............................................................................................................ 44
剩余236页未读，继续阅读
资源评论
