Mysql - 05

目录
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#1%C2%A0%C2%A0%C2%A0%E5%A4%9A%E8%A1%A8%E7%9A%84%E8%BF%9E%E6%8E%A5%E6%9F%A5%E8%AF%A2">1 多表的连接查询</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#2%C2%A0%C2%A0%C2%A0%E6%A0%87%E5%87%86%E8%A1%A8%E8%BF%9E%E6%8E%A5%E8%AF%AD%E6%B3%95">2 标准表连接语法</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#2.1%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E5%A4%96%E8%BF%9E%E6%8E%A5">2.1 外连接</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3%C2%A0%C2%A0%C2%A0%E4%BA%8B%E5%8A%A1">3 事务</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.1%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E4%BA%8B%E5%8A%A1%E5%9B%9B%E4%B8%AA%E7%89%B9%E6%80%A7%EF%BC%9AACID">3.1 事务四个特性：ACID</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.2%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E4%BA%8B%E5%8A%A1%E6%93%8D%E4%BD%9C">3.2 事务操作</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.2.1%C2%A0%E5%BC%80%E5%A7%8B%E4%BA%8B%E5%8A%A1">3.2.1 开始事务</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.2.2%C2%A0%E6%8F%90%E4%BA%A4%E4%BA%8B%E5%8A%A1">3.2.2 提交事务</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.2.3%C2%A0%E5%9B%9E%E6%BB%9A%E4%BA%8B%E5%8A%A1">3.2.3 回滚事务</a>
<p id="3.3%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E5%A4%9A%E4%B8%AA%E4%BA%8B%E5%8A%A1%E5%B9%B6%E5%8F%91%E6%89%A7%E8%A1%8C%E6%97%B6%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E9%97%AE%E9%A2%98-toc" style="margin-left:40px;"><a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.3%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E5%A4%9A%E4%B8%AA%E4%BA%8B%E5%8A%A1%E5%B9%B6%E5%8F%91%E6%89%A7%E8%A1%8C%E6%97%B6%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E9%97%AE%E9%A2%98">3.3 多个事务并发执行时数据访问问题</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.3.1%C2%A0%E8%84%8F%E6%95%B0%E6%8D%AE">3.3.1 脏数据</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.3.2%C2%A0%E4%B8%8D%E5%8F%AF%E9%87%8D%E5%A4%8D%E8%AF%BB">3.3.2 不可重复读</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.3.3%C2%A0%E5%B9%BB%E8%AF%BB">3.3.3 幻读</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#3.4%C2%A0%E4%BA%8B%E5%8A%A1%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB">3.4 事务隔离级别</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#4%C2%A0%C2%A0%C2%A0%E8%A7%86%E5%9B%BE%C2%A0view">4 视图 view</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#4.1%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E5%88%9B%E5%BB%BA%E8%A7%86%E5%9B%BE">4.1 创建视图</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#4.2%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E6%9F%A5%E7%9C%8B%E8%A7%86%E5%9B%BE">4.2 查看视图</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#4.3%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E5%88%A0%E9%99%A4%E8%A7%86%E5%9B%BE">4.3 删除视图</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#5%C2%A0%C2%A0%C2%A0%E7%B4%A2%E5%BC%95">5 索引</a>
<a href="https://blog.csdn.net/weixin_41574239/article/details/82024901#5.1%C2%A0%C2%A0%C2%A0%C2%A0%C2%A0%E7%B4%A2%E5%BC%95%E7%9A%84%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84%C2%A0B%2BTree%28%E4%BA%86%E8%A7%A3%29">5.1