Interview/mysql/MySQL面试常见问题.md · Emotion404/JavaBooks

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。

克隆/下载

MySQL面试常见问题.md 3.92 KB

- [数据库引擎innodb与myisam的区别？](/Interview/mysql/sql-存储引擎.md)
- [Mysql的ACID原理](/Interview/mysql/Mysql中ACID的原理.md)
- [并发事务带来的问题](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E5%B9%B6%E5%8F%91%E4%BA%8B%E5%8A%A1%E5%B8%A6%E6%9D%A5%E7%9A%84%E9%97%AE%E9%A2%98)
- [数据库的隔离级别](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB)
- [为什么使用索引？](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95)
- [索引这么多优点，为什么不对表中的每一个列创建一个索引呢？](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E7%B4%A2%E5%BC%95%E8%BF%99%E4%B9%88%E5%A4%9A%E4%BC%98%E7%82%B9%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%8D%E5%AF%B9%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E4%B8%AA%E5%88%97%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AA%E7%B4%A2%E5%BC%95%E5%91%A2)
- [索引如如何提高查询速度的？](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E7%B4%A2%E5%BC%95%E5%A6%82%E5%A6%82%E4%BD%95%E6%8F%90%E9%AB%98%E6%9F%A5%E8%AF%A2%E9%80%9F%E5%BA%A6%E7%9A%84)
- [使用索引的注意事项？](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E7%9A%84%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9)
- [Mysql索引主要使用的两种数据结构](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#mysql%E7%B4%A2%E5%BC%95%E4%B8%BB%E8%A6%81%E4%BD%BF%E7%94%A8%E7%9A%84%E4%B8%A4%E7%A7%8D%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84)
- [MyISAM和InnoDB实现BTree索引方式的区别](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#myisam%E5%92%8Cinnodb%E5%AE%9E%E7%8E%B0btree%E7%B4%A2%E5%BC%95%E6%96%B9%E5%BC%8F%E7%9A%84%E5%8C%BA%E5%88%AB)
- [数据库结构优化](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%93%E6%9E%84%E4%BC%98%E5%8C%96)
- [主键 超键 候选键 外键是什么](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E4%B8%BB%E9%94%AE-%E8%B6%85%E9%94%AE-%E5%80%99%E9%80%89%E9%94%AE-%E5%A4%96%E9%94%AE%E6%98%AF%E4%BB%80%E4%B9%88)
- [drop,delete与truncate的区别](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#dropdelete%E4%B8%8Etruncate%E7%9A%84%E5%8C%BA%E5%88%AB)
- [视图的作用，视图可以更改么？](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E8%A7%86%E5%9B%BE%E7%9A%84%E4%BD%9C%E7%94%A8%E8%A7%86%E5%9B%BE%E5%8F%AF%E4%BB%A5%E6%9B%B4%E6%94%B9%E4%B9%88)
- [数据库范式](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E6%95%B0%E6%8D%AE%E5%BA%93%E8%8C%83%E5%BC%8F)
- [什么是覆盖索引?](https://github.com/DreamCats/JavaBooks/blob/master/Interview/mysql/Mysql-%E9%9D%A2%E8%AF%95%E5%B8%B8%E8%A7%81%E7%9A%84%E9%97%AE%E9%A2%98.md#%E4%BB%80%E4%B9%88%E6%98%AF%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95)

一键复制编辑原始数据按行查看历史

提交于 2020-04-18 22:19 . 去掉了复杂的问题索引

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

https://gitee.com/Emotion404/JavaBooks.git

git@gitee.com:Emotion404/JavaBooks.git

Emotion404

JavaBooks

master

Emotion404 / JavaBooks

简介

发行版

贡献者

近期动态

Emotion404 / JavaBooks .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

Emotion404 / JavaBooks