超哥mysql数据库部分blog整理:

总目录:mysql数据库阶段学习目录

https://www.cnblogs.com/clschao/articles/10065275.html

Day1.

1.数据库初识

https://www.cnblogs.com/clschao/articles/9907529.html

2.mysql基础数据类型

https://www.cnblogs.com/clschao/articles/9959559.html

 

Day2.

2.mysql的sql语言DML/DQL/DDL/DCL

https://www.cnblogs.com/clschao/articles/9930802.html

 

3.mysql的库\表的详细操作

 https://www.cnblogs.com/clschao/articles/9951307.html

 

4.MYSQL存储引擎介绍

https://www.cnblogs.com/clschao/articles/9953550.html

 

5.mysql的sql_mode模式说明及设置(很多人很容易忽略的问题)

宽松模式不报错(可以修改成严格格式)

https://www.cnblogs.com/clschao/articles/9962347.html

 

6.mysql基础数据类型

https://www.cnblogs.com/clschao/articles/9959559.html

 

7.mysql的完整性约束

https://www.cnblogs.com/clschao/articles/9968396.html

 

day3

1.单表查询

https://www.cnblogs.com/clschao/articles/9995531.html

2.mysql行记录的详细操作

https://www.cnblogs.com/clschao/articles/9991911.html

 

day4

1.多表查询

https://www.cnblogs.com/clschao/articles/9995815.html

 2.初级版练习题(24)

https://www.cnblogs.com/clschao/articles/9995776.html

习题加答案

https://www.cnblogs.com/clschao/articles/9995776.html

3.升级版练习题(41)[答案+练习]

https://www.cnblogs.com/clschao/articles/9995768.html

4.Navicat和pymysql模块

 

day5

1.mysql之视图,触发器,事物,存储过程,函数(升级)

https://www.cnblogs.com/clschao/articles/10034539.html

 

2.mysql之索引原理和慢查询优化

https://www.cnblogs.com/clschao/articles/10049133.html

 

3.mysql之创建用户和授权

https://www.cnblogs.com/clschao/articles/10050473.html

 

4.mysql之mysqldump数据备份还原

https://www.cnblogs.com/clschao/articles/10263425.html

 

 

这个重点的参考blog:

布隆过滤等等:隔离级别mcc

https://www.2cto.com/database/201504/394481.html