# MySQL 进阶笔记

视频：[黑马程序员 MySQL 数据库入门到精通，从 mysql 安装到 mysql 高级](https://www.bilibili.com/video/BV1Kr4y1i7ru)

### MySQL 基础篇

- 约束
- 函数
- 事务

### MySQL 进阶篇
[在Linux上安装MySQL](blog/mysq-advance/install.md)

[1. 存储引擎](blog/mysq-advance/engine.md)

[2. 索引](blog/mysq-advance/mysql-index.md)

[3. SQL优化](blog/mysq-advance/sql-optimization.md)

3. SQL 优化
4. 视图/存储过程/触发器
5. 锁
6. InnoDB 引擎
7. MySQL 管理


MySQL 运维篇


## 网友笔记

- 1. [https://dhc.pythonanywhere.com/entry/share/?key=3ad29aad765a2b98b2b2a745d71bef715507ee9db8adbec98257bac0ad84cbe4](https://dhc.pythonanywhere.com/entry/share/?key=3ad29aad765a2b98b2b2a745d71bef715507ee9db8adbec98257bac0ad84cbe4)

- 2. [https://aismy.github.io/2021/08/17/MYSQL/](https://aismy.github.io/2021/08/17/MYSQL/)

- 3. [https://www.yuque.com/heychu/akbndd/zhuxqd](https://www.yuque.com/heychu/akbndd/zhuxqd)



https://www.bilibili.com/video/BV1Kr4y1i7ru?p=97&spm_id_from=pageDriver