master

分支 (1)

管理

管理

master

mysql-crash-course
/
_book
/
index.html


<!DOCTYPE HTML>
<html lang="zh-hans" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>前言 · MySQL必知必会</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="零创世界">


    <link rel="stylesheet" href="gitbook/style.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-chapter-fold/chapter-fold.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-search-pro/search.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-back-to-top-button/plugin.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-code/plugin.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-splitter/splitter.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-insert-logo/plugin.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-pageview-count/plugin.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-donate/plugin.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-highlight/website.css">


                <link rel="stylesheet" href="gitbook/gitbook-plugin-fontsettings/website.css">


    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="gitbook/images/favicon.ico" type="image/x-icon">


    <link rel="next" href="chapter/01/0100.html" />


    </head>
    <body>

<div class="book">
    <div class="book-summary">


<div id="book-search-input" role="search">
    <input type="text" placeholder="输入并搜索" />
</div>


                <nav role="navigation">


<ul class="summary">


        <li class="chapter active" data-level="1.1" data-path="./">

                <a href="./">


                    前言

                </a>


        </li>

        <li class="chapter " data-level="1.2" data-path="chapter/01/0100.html">

                <a href="chapter/01/0100.html">


                    第1章 了解SQL

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.2.1" data-path="chapter/01/0101.html">

                <a href="chapter/01/0101.html">


                    1.1 数据库基础

                </a>


        </li>

        <li class="chapter " data-level="1.2.2" data-path="chapter/01/0102.html">

                <a href="chapter/01/0102.html">


                    1.2 什么是SQL

                </a>


        </li>

        <li class="chapter " data-level="1.2.3" data-path="chapter/01/0103.html">

                <a href="chapter/01/0103.html">


                    1.3 动手实践

                </a>


        </li>

        <li class="chapter " data-level="1.2.4" data-path="chapter/01/0104.html">

                <a href="chapter/01/0104.html">


                    1.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.3" data-path="chapter/02/0200.html">

                <a href="chapter/02/0200.html">


                    第2章 MySQL简介

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.3.1" data-path="chapter/02/0201.html">

                <a href="chapter/02/0201.html">


                    2.1 什么是MySQL

                </a>


        </li>

        <li class="chapter " data-level="1.3.2" data-path="chapter/02/0202.html">

                <a href="chapter/02/0202.html">


                    2.2 MySQL工具

                </a>


        </li>

        <li class="chapter " data-level="1.3.3" data-path="chapter/02/0203.html">

                <a href="chapter/02/0203.html">


                    2.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.4" data-path="chapter/03/0300.html">

                <a href="chapter/03/0300.html">


                    第3章 使用MySQL

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.4.1" data-path="chapter/03/0301.html">

                <a href="chapter/03/0301.html">


                    3.1 连接

                </a>


        </li>

        <li class="chapter " data-level="1.4.2" data-path="chapter/03/0302.html">

                <a href="chapter/03/0302.html">


                    3.2 选择数据库

                </a>


        </li>

        <li class="chapter " data-level="1.4.3" data-path="chapter/03/0303.html">

                <a href="chapter/03/0303.html">


                    3.3 了解数据库和表

                </a>


        </li>

        <li class="chapter " data-level="1.4.4" data-path="chapter/03/0304.html">

                <a href="chapter/03/0304.html">


                    3.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.5" data-path="chapter/04/0400.html">

                <a href="chapter/04/0400.html">


                    第4章 检索数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.5.1" data-path="chapter/04/0401.html">

                <a href="chapter/04/0401.html">


                    4.1 SELECT语句

                </a>


        </li>

        <li class="chapter " data-level="1.5.2" data-path="chapter/04/0402.html">

                <a href="chapter/04/0402.html">


                    4.2 检索单个列

                </a>


        </li>

        <li class="chapter " data-level="1.5.3" data-path="chapter/04/0403.html">

                <a href="chapter/04/0403.html">


                    4.3 检索多个列

                </a>


        </li>

        <li class="chapter " data-level="1.5.4" data-path="chapter/04/0404.html">

                <a href="chapter/04/0404.html">


                    4.4 检索所有列

                </a>


        </li>

        <li class="chapter " data-level="1.5.5" data-path="chapter/04/0405.html">

                <a href="chapter/04/0405.html">


                    4.5 检索不同的行

                </a>


        </li>

        <li class="chapter " data-level="1.5.6" data-path="chapter/04/0406.html">

                <a href="chapter/04/0406.html">


                    4.6 限制结果

                </a>


        </li>

        <li class="chapter " data-level="1.5.7" data-path="chapter/04/0407.html">

                <a href="chapter/04/0407.html">


                    4.7 使用完全限定的表名

                </a>


        </li>

        <li class="chapter " data-level="1.5.8" data-path="chapter/04/0408.html">

                <a href="chapter/04/0408.html">


                    4.8 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.6" data-path="chapter/05/0500.html">

                <a href="chapter/05/0500.html">


                    第5章 排序检索数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.6.1" data-path="chapter/05/0501.html">

                <a href="chapter/05/0501.html">


                    5.1 排序数据

                </a>


        </li>

        <li class="chapter " data-level="1.6.2" data-path="chapter/05/0502.html">

                <a href="chapter/05/0502.html">


                    5.2 按多个列排序

                </a>


        </li>

        <li class="chapter " data-level="1.6.3" data-path="chapter/05/0503.html">

                <a href="chapter/05/0503.html">


                    5.3 指定排序方向

                </a>


        </li>

        <li class="chapter " data-level="1.6.4" data-path="chapter/05/0504.html">

                <a href="chapter/05/0504.html">


                    5.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.7" data-path="chapter/06/0600.html">

                <a href="chapter/06/0600.html">


                    第6章 过滤数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.7.1" data-path="chapter/06/0601.html">

                <a href="chapter/06/0601.html">


                    6.1 使用WHERE子句

                </a>


        </li>

        <li class="chapter " data-level="1.7.2" data-path="chapter/06/0602.html">

                <a href="chapter/06/0602.html">


                    6.2 WHERE子句操作符

                </a>


        </li>

        <li class="chapter " data-level="1.7.3" data-path="chapter/06/0603.html">

                <a href="chapter/06/0603.html">


                    6.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.8" data-path="chapter/07/0700.html">

                <a href="chapter/07/0700.html">


                    第7章 数据过滤

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.8.1" data-path="chapter/07/0701.html">

                <a href="chapter/07/0701.html">


                    7.1 组合WHERE子句

                </a>


        </li>

        <li class="chapter " data-level="1.8.2" data-path="chapter/07/0702.html">

                <a href="chapter/07/0702.html">


                    7.2 IN操作符

                </a>


        </li>

        <li class="chapter " data-level="1.8.3" data-path="chapter/07/0703.html">

                <a href="chapter/07/0703.html">


                    7.3 NOT操作符

                </a>


        </li>

        <li class="chapter " data-level="1.8.4" data-path="chapter/07/0704.html">

                <a href="chapter/07/0704.html">


                    7.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.9" data-path="chapter/08/0800.html">

                <a href="chapter/08/0800.html">


                    第8章 用通配符进行过滤

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.9.1" data-path="chapter/08/0801.html">

                <a href="chapter/08/0801.html">


                    8.1 LIKE操作符

                </a>


        </li>

        <li class="chapter " data-level="1.9.2" data-path="chapter/08/0802.html">

                <a href="chapter/08/0802.html">


                    8.2 使用通配符的技巧

                </a>


        </li>

        <li class="chapter " data-level="1.9.3" data-path="chapter/08/0803.html">

                <a href="chapter/08/0803.html">


                    8.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.10" data-path="chapter/09/0900.html">

                <a href="chapter/09/0900.html">


                    第9章 用正则表达式进行搜索

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.10.1" data-path="chapter/09/0901.html">

                <a href="chapter/09/0901.html">


                    9.1 正则表达式介绍

                </a>


        </li>

        <li class="chapter " data-level="1.10.2" data-path="chapter/09/0902.html">

                <a href="chapter/09/0902.html">


                    9.2 使用MySQL正则表达式

                </a>


        </li>

        <li class="chapter " data-level="1.10.3" data-path="chapter/09/0903.html">

                <a href="chapter/09/0903.html">


                    9.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.11" data-path="chapter/10/1000.html">

                <a href="chapter/10/1000.html">


                    第10章 创建计算字段

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.11.1" data-path="chapter/10/1001.html">

                <a href="chapter/10/1001.html">


                    10.1 计算字段

                </a>


        </li>

        <li class="chapter " data-level="1.11.2" data-path="chapter/10/1002.html">

                <a href="chapter/10/1002.html">


                    10.2 拼接字段

                </a>


        </li>

        <li class="chapter " data-level="1.11.3" data-path="chapter/10/1003.html">

                <a href="chapter/10/1003.html">


                    10.3 执行算术计算

                </a>


        </li>

        <li class="chapter " data-level="1.11.4" data-path="chapter/10/1004.html">

                <a href="chapter/10/1004.html">


                    10.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.12" data-path="chapter/11/1100.html">

                <a href="chapter/11/1100.html">


                    第11章 使用数据处理函数

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.12.1" data-path="chapter/11/1101.html">

                <a href="chapter/11/1101.html">


                    11.1 函数

                </a>


        </li>

        <li class="chapter " data-level="1.12.2" data-path="chapter/11/1102.html">

                <a href="chapter/11/1102.html">


                    11.2 使用函数

                </a>


        </li>

        <li class="chapter " data-level="1.12.3" data-path="chapter/11/1103.html">

                <a href="chapter/11/1103.html">


                    11.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.13" data-path="chapter/12/1200.html">

                <a href="chapter/12/1200.html">


                    第12章 汇总数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.13.1" data-path="chapter/12/1201.html">

                <a href="chapter/12/1201.html">


                    12.1 聚集函数

                </a>


        </li>

        <li class="chapter " data-level="1.13.2" data-path="chapter/12/1202.html">

                <a href="chapter/12/1202.html">


                    12.2 聚集不同值

                </a>


        </li>

        <li class="chapter " data-level="1.13.3" data-path="chapter/12/1203.html">

                <a href="chapter/12/1203.html">


                    12.3 组合聚集函数

                </a>


        </li>

        <li class="chapter " data-level="1.13.4" data-path="chapter/12/1204.html">

                <a href="chapter/12/1204.html">


                    12.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.14" data-path="chapter/13/1300.html">

                <a href="chapter/13/1300.html">


                    第13章 分组数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.14.1" data-path="chapter/13/1301.html">

                <a href="chapter/13/1301.html">


                    13.1 数据分组

                </a>


        </li>

        <li class="chapter " data-level="1.14.2" data-path="chapter/13/1302.html">

                <a href="chapter/13/1302.html">


                    13.2 创建分组

                </a>


        </li>

        <li class="chapter " data-level="1.14.3" data-path="chapter/13/1303.html">

                <a href="chapter/13/1303.html">


                    13.3 过滤分组

                </a>


        </li>

        <li class="chapter " data-level="1.14.4" data-path="chapter/13/1304.html">

                <a href="chapter/13/1304.html">


                    13.4 分组和排序

                </a>


        </li>

        <li class="chapter " data-level="1.14.5" data-path="chapter/13/1305.html">

                <a href="chapter/13/1305.html">


                    13.5 SELECT子句顺序

                </a>


        </li>

        <li class="chapter " data-level="1.14.6" data-path="chapter/13/1306.html">

                <a href="chapter/13/1306.html">


                    13.6 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.15" data-path="chapter/14/1400.html">

                <a href="chapter/14/1400.html">


                    第14章 使用子查询

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.15.1" data-path="chapter/14/1401.html">

                <a href="chapter/14/1401.html">


                    14.1 子查询

                </a>


        </li>

        <li class="chapter " data-level="1.15.2" data-path="chapter/14/1402.html">

                <a href="chapter/14/1402.html">


                    14.2 利用子查询进行过滤

                </a>


        </li>

        <li class="chapter " data-level="1.15.3" data-path="chapter/14/1403.html">

                <a href="chapter/14/1403.html">


                    14.3 作为计算字段使用子查询

                </a>


        </li>

        <li class="chapter " data-level="1.15.4" data-path="chapter/14/1404.html">

                <a href="chapter/14/1404.html">


                    14.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.16" data-path="chapter/15/1500.html">

                <a href="chapter/15/1500.html">


                    第15章 联结表

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.16.1" data-path="chapter/15/1501.html">

                <a href="chapter/15/1501.html">


                    15.1 联结

                </a>


        </li>

        <li class="chapter " data-level="1.16.2" data-path="chapter/15/1502.html">

                <a href="chapter/15/1502.html">


                    15.2 创建联结

                </a>


        </li>

        <li class="chapter " data-level="1.16.3" data-path="chapter/15/1503.html">

                <a href="chapter/15/1503.html">


                    15.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.17" data-path="chapter/16/1600.html">

                <a href="chapter/16/1600.html">


                    第16章 创建高级联结

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.17.1" data-path="chapter/16/1601.html">

                <a href="chapter/16/1601.html">


                    16.1 使用表别名

                </a>


        </li>

        <li class="chapter " data-level="1.17.2" data-path="chapter/16/1602.html">

                <a href="chapter/16/1602.html">


                    16.2 使用不同类型的联结

                </a>


        </li>

        <li class="chapter " data-level="1.17.3" data-path="chapter/16/1603.html">

                <a href="chapter/16/1603.html">


                    16.3 使用带聚集函数的联结

                </a>


        </li>

        <li class="chapter " data-level="1.17.4" data-path="chapter/16/1604.html">

                <a href="chapter/16/1604.html">


                    16.4 使用联结和联结条件

                </a>


        </li>

        <li class="chapter " data-level="1.17.5" data-path="chapter/16/1605.html">

                <a href="chapter/16/1605.html">


                    16.5 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.18" data-path="chapter/17/1700.html">

                <a href="chapter/17/1700.html">


                    第17章 组合查询

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.18.1" data-path="chapter/17/1701.html">

                <a href="chapter/17/1701.html">


                    17.1 组合查询

                </a>


        </li>

        <li class="chapter " data-level="1.18.2" data-path="chapter/17/1702.html">

                <a href="chapter/17/1702.html">


                    17.2 创建组合查询

                </a>


        </li>

        <li class="chapter " data-level="1.18.3" data-path="chapter/17/1703.html">

                <a href="chapter/17/1703.html">


                    17.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.19" data-path="chapter/18/1800.html">

                <a href="chapter/18/1800.html">


                    第18章 全文本搜索

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.19.1" data-path="chapter/18/1801.html">

                <a href="chapter/18/1801.html">


                    18.1 理解全文本搜索

                </a>


        </li>

        <li class="chapter " data-level="1.19.2" data-path="chapter/18/1802.html">

                <a href="chapter/18/1802.html">


                    18.2 使用全文本搜索

                </a>


        </li>

        <li class="chapter " data-level="1.19.3" data-path="chapter/18/1803.html">

                <a href="chapter/18/1803.html">


                    18.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.20" data-path="chapter/19/1900.html">

                <a href="chapter/19/1900.html">


                    第19章 插入数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.20.1" data-path="chapter/19/1901.html">

                <a href="chapter/19/1901.html">


                    19.1 数据插入

                </a>


        </li>

        <li class="chapter " data-level="1.20.2" data-path="chapter/19/1902.html">

                <a href="chapter/19/1902.html">


                    19.2 插入完整的行

                </a>


        </li>

        <li class="chapter " data-level="1.20.3" data-path="chapter/19/1903.html">

                <a href="chapter/19/1903.html">


                    19.3 插入多个行

                </a>


        </li>

        <li class="chapter " data-level="1.20.4" data-path="chapter/19/1904.html">

                <a href="chapter/19/1904.html">


                    19.4 插入检索出的数据

                </a>


        </li>

        <li class="chapter " data-level="1.20.5" data-path="chapter/19/1905.html">

                <a href="chapter/19/1905.html">


                    19.5 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.21" data-path="chapter/20/2000.html">

                <a href="chapter/20/2000.html">


                    第20章 更新和删除数据

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.21.1" data-path="chapter/20/2001.html">

                <a href="chapter/20/2001.html">


                    20.1 更新数据

                </a>


        </li>

        <li class="chapter " data-level="1.21.2" data-path="chapter/20/2002.html">

                <a href="chapter/20/2002.html">


                    20.2 删除数据

                </a>


        </li>

        <li class="chapter " data-level="1.21.3" data-path="chapter/20/2003.html">

                <a href="chapter/20/2003.html">


                    20.3 更新和删除的指导原则

                </a>


        </li>

        <li class="chapter " data-level="1.21.4" data-path="chapter/20/2004.html">

                <a href="chapter/20/2004.html">


                    20.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.22" data-path="chapter/21/2100.html">

                <a href="chapter/21/2100.html">


                    第21章 创建和操纵表

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.22.1" data-path="chapter/21/2101.html">

                <a href="chapter/21/2101.html">


                    21.1 创建表

                </a>


        </li>

        <li class="chapter " data-level="1.22.2" data-path="chapter/21/2102.html">

                <a href="chapter/21/2102.html">


                    21.2 更新表

                </a>


        </li>

        <li class="chapter " data-level="1.22.3" data-path="chapter/21/2103.html">

                <a href="chapter/21/2103.html">


                    21.3 删除表

                </a>


        </li>

        <li class="chapter " data-level="1.22.4" data-path="chapter/21/2104.html">

                <a href="chapter/21/2104.html">


                    21.4 重命名表

                </a>


        </li>

        <li class="chapter " data-level="1.22.5" data-path="chapter/21/2105.html">

                <a href="chapter/21/2105.html">


                    21.5 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.23" data-path="chapter/22/2200.html">

                <a href="chapter/22/2200.html">


                    第22章 使用视图

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.23.1" data-path="chapter/22/2201.html">

                <a href="chapter/22/2201.html">


                    22.1 视图

                </a>


        </li>

        <li class="chapter " data-level="1.23.2" data-path="chapter/22/2202.html">

                <a href="chapter/22/2202.html">


                    22.2 使用视图

                </a>


        </li>

        <li class="chapter " data-level="1.23.3" data-path="chapter/22/2203.html">

                <a href="chapter/22/2203.html">


                    22.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.24" data-path="chapter/23/2300.html">

                <a href="chapter/23/2300.html">


                    第23章 使用存储过程

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.24.1" data-path="chapter/23/2301.html">

                <a href="chapter/23/2301.html">


                    23.1 存储过程

                </a>


        </li>

        <li class="chapter " data-level="1.24.2" data-path="chapter/23/2302.html">

                <a href="chapter/23/2302.html">


                    23.2 为什么要使用存储过程

                </a>


        </li>

        <li class="chapter " data-level="1.24.3" data-path="chapter/23/2303.html">

                <a href="chapter/23/2303.html">


                    23.3 使用存储过程

                </a>


        </li>

        <li class="chapter " data-level="1.24.4" data-path="chapter/23/2304.html">

                <a href="chapter/23/2304.html">


                    23.4 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.25" data-path="chapter/24/2400.html">

                <a href="chapter/24/2400.html">


                    第24章 使用游标

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.25.1" data-path="chapter/24/2401.html">

                <a href="chapter/24/2401.html">


                    24.1 游标

                </a>


        </li>

        <li class="chapter " data-level="1.25.2" data-path="chapter/24/2402.html">

                <a href="chapter/24/2402.html">


                    24.2 使用游标

                </a>


        </li>

        <li class="chapter " data-level="1.25.3" data-path="chapter/24/2403.html">

                <a href="chapter/24/2403.html">


                    24.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.26" data-path="chapter/25/2500.html">

                <a href="chapter/25/2500.html">


                    第25章 使用触发器

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.26.1" data-path="chapter/25/2501.html">

                <a href="chapter/25/2501.html">


                    25.1 触发器

                </a>


        </li>

        <li class="chapter " data-level="1.26.2" data-path="chapter/25/2502.html">

                <a href="chapter/25/2502.html">


                    25.2 创建触发器

                </a>


        </li>

        <li class="chapter " data-level="1.26.3" data-path="chapter/25/2503.html">

                <a href="chapter/25/2503.html">


                    25.3 删除触发器

                </a>


        </li>

        <li class="chapter " data-level="1.26.4" data-path="chapter/25/2504.html">

                <a href="chapter/25/2504.html">


                    25.4 使用触发器

                </a>


        </li>

        <li class="chapter " data-level="1.26.5" data-path="chapter/25/2505.html">

                <a href="chapter/25/2505.html">


                    25.5 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.27" data-path="chapter/26/2600.html">

                <a href="chapter/26/2600.html">


                    第26章 管理事务处理

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.27.1" data-path="chapter/26/2601.html">

                <a href="chapter/26/2601.html">


                    26.1 事务处理

                </a>


        </li>

        <li class="chapter " data-level="1.27.2" data-path="chapter/26/2602.html">

                <a href="chapter/26/2602.html">


                    26.2 控制事务处理

                </a>


        </li>

        <li class="chapter " data-level="1.27.3" data-path="chapter/26/2603.html">

                <a href="chapter/26/2603.html">


                    26.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.28" data-path="chapter/27/2700.html">

                <a href="chapter/27/2700.html">


                    第27章 全球化和本地化

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.28.1" data-path="chapter/27/2701.html">

                <a href="chapter/27/2701.html">


                    27.1 字符集和校对顺序

                </a>


        </li>

        <li class="chapter " data-level="1.28.2" data-path="chapter/27/2702.html">

                <a href="chapter/27/2702.html">


                    27.2 使用字符集和校对顺序

                </a>


        </li>

        <li class="chapter " data-level="1.28.3" data-path="chapter/27/2703.html">

                <a href="chapter/27/2703.html">


                    27.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.29" data-path="chapter/28/2800.html">

                <a href="chapter/28/2800.html">


                    第28章 安全管理

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.29.1" data-path="chapter/28/2801.html">

                <a href="chapter/28/2801.html">


                    28.1 访问控制

                </a>


        </li>

        <li class="chapter " data-level="1.29.2" data-path="chapter/28/2802.html">

                <a href="chapter/28/2802.html">


                    28.2 管理用户

                </a>


        </li>

        <li class="chapter " data-level="1.29.3" data-path="chapter/28/2803.html">

                <a href="chapter/28/2803.html">


                    28.3 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.30" data-path="chapter/29/2900.html">

                <a href="chapter/29/2900.html">


                    第29章 数据库维护

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.30.1" data-path="chapter/29/2901.html">

                <a href="chapter/29/2901.html">


                    29.1 备份数据

                </a>


        </li>

        <li class="chapter " data-level="1.30.2" data-path="chapter/29/2902.html">

                <a href="chapter/29/2902.html">


                    29.2 进行数据库维护

                </a>


        </li>

        <li class="chapter " data-level="1.30.3" data-path="chapter/29/2903.html">

                <a href="chapter/29/2903.html">


                    29.3 诊断启动问题

                </a>


        </li>

        <li class="chapter " data-level="1.30.4" data-path="chapter/29/2904.html">

                <a href="chapter/29/2904.html">


                    29.4 查看日志文件

                </a>


        </li>

        <li class="chapter " data-level="1.30.5" data-path="chapter/29/2905.html">

                <a href="chapter/29/2905.html">


                    29.5 小结

                </a>


        </li>


            </ul>

        </li>

        <li class="chapter " data-level="1.31" data-path="chapter/30/3000.html">

                <a href="chapter/30/3000.html">


                    第30章 改善性能

                </a>


            <ul class="articles">


        <li class="chapter " data-level="1.31.1" data-path="chapter/30/3001.html">

                <a href="chapter/30/3001.html">


                    30.1 改善性能

                </a>


        </li>

        <li class="chapter " data-level="1.31.2" data-path="chapter/30/3002.html">

                <a href="chapter/30/3002.html">


                    30.2 小结

                </a>


        </li>


            </ul>

        </li>


    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            本书使用 GitBook 发布
        </a>
    </li>
</ul>


                </nav>


    </div>

    <div class="book-body">

            <div class="body-inner">


<div class="book-header" role="navigation">


    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="." >前言</a>
    </h1>
</div>


                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">

<div id="book-search-results">
    <div class="search-noresults">

                                <section class="normal markdown-section">

                                <ul>
<li><strong>&#x4E66;&#x540D;&#xFF1A;</strong>&#x300A;MySQL&#x5FC5;&#x77E5;&#x5FC5;&#x4F1A;&#x300B;</li>
<li><strong>&#x4F5C;&#x8005;&#xFF1A;</strong> Ben Forta</li>
<li><strong>&#x8BD1;&#xFF1A;</strong> &#x5218;&#x6653;&#x971E;&#xFF0C; &#x949F;&#x9E23;</li>
<li><strong>ISBN&#xFF1A;</strong> 978-7-115-19112-0</li>
</ul>
<h4 id="&#x76EE;&#x5F55;">&#x76EE;&#x5F55;</h4>
<ul>
<li><a href="./">&#x524D;&#x8A00;</a></li>
<li><a href="chapter/01/0100.html">&#x7B2C;1&#x7AE0; &#x4E86;&#x89E3;SQL</a><ul>
<li><a href="chapter/01/0101.html">1.1 &#x6570;&#x636E;&#x5E93;&#x57FA;&#x7840;</a></li>
<li><a href="chapter/01/0102.html">1.2 &#x4EC0;&#x4E48;&#x662F;SQL</a></li>
<li><a href="chapter/01/0103.html">1.3 &#x52A8;&#x624B;&#x5B9E;&#x8DF5;</a></li>
<li><a href="chapter/01/0104.html">1.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/02/0200.html">&#x7B2C;2&#x7AE0; MySQL&#x7B80;&#x4ECB;</a><ul>
<li><a href="chapter/02/0201.html">2.1 &#x4EC0;&#x4E48;&#x662F;MySQL</a></li>
<li><a href="chapter/02/0202.html">2.2 MySQL&#x5DE5;&#x5177;</a></li>
<li><a href="chapter/02/0203.html">2.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/03/0300.html">&#x7B2C;3&#x7AE0; &#x4F7F;&#x7528;MySQL</a><ul>
<li><a href="chapter/03/0301.html">3.1 &#x8FDE;&#x63A5;</a></li>
<li><a href="chapter/03/0302.html">3.2 &#x9009;&#x62E9;&#x6570;&#x636E;&#x5E93;</a></li>
<li><a href="chapter/03/0303.html">3.3 &#x4E86;&#x89E3;&#x6570;&#x636E;&#x5E93;&#x548C;&#x8868;</a></li>
<li><a href="chapter/03/0304.html">3.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/04/0400.html">&#x7B2C;4&#x7AE0; &#x68C0;&#x7D22;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/04/0401.html">4.1 SELECT&#x8BED;&#x53E5;</a></li>
<li><a href="chapter/04/0402.html">4.2 &#x68C0;&#x7D22;&#x5355;&#x4E2A;&#x5217;</a></li>
<li><a href="chapter/04/0403.html">4.3 &#x68C0;&#x7D22;&#x591A;&#x4E2A;&#x5217;</a></li>
<li><a href="chapter/04/0404.html">4.4 &#x68C0;&#x7D22;&#x6240;&#x6709;&#x5217;</a></li>
<li><a href="chapter/04/0405.html">4.5 &#x68C0;&#x7D22;&#x4E0D;&#x540C;&#x7684;&#x884C;</a></li>
<li><a href="chapter/04/0406.html">4.6 &#x9650;&#x5236;&#x7ED3;&#x679C;</a></li>
<li><a href="chapter/04/0407.html">4.7 &#x4F7F;&#x7528;&#x5B8C;&#x5168;&#x9650;&#x5B9A;&#x7684;&#x8868;&#x540D;</a></li>
<li><a href="chapter/04/0408.html">4.8 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/05/0500.html">&#x7B2C;5&#x7AE0; &#x6392;&#x5E8F;&#x68C0;&#x7D22;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/05/0501.html">5.1 &#x6392;&#x5E8F;&#x6570;&#x636E;</a></li>
<li><a href="chapter/05/0502.html">5.2 &#x6309;&#x591A;&#x4E2A;&#x5217;&#x6392;&#x5E8F;</a></li>
<li><a href="chapter/05/0503.html">5.3 &#x6307;&#x5B9A;&#x6392;&#x5E8F;&#x65B9;&#x5411;</a></li>
<li><a href="chapter/05/0504.html">5.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/06/0600.html">&#x7B2C;6&#x7AE0; &#x8FC7;&#x6EE4;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/06/0601.html">6.1 &#x4F7F;&#x7528;WHERE&#x5B50;&#x53E5;</a></li>
<li><a href="chapter/06/0602.html">6.2 WHERE&#x5B50;&#x53E5;&#x64CD;&#x4F5C;&#x7B26;</a></li>
<li><a href="chapter/06/0603.html">6.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/07/0700.html">&#x7B2C;7&#x7AE0; &#x6570;&#x636E;&#x8FC7;&#x6EE4;</a><ul>
<li><a href="chapter/07/0701.html">7.1 &#x7EC4;&#x5408;WHERE&#x5B50;&#x53E5;</a></li>
<li><a href="chapter/07/0702.html">7.2 IN&#x64CD;&#x4F5C;&#x7B26;</a></li>
<li><a href="chapter/07/0703.html">7.3 NOT&#x64CD;&#x4F5C;&#x7B26;</a></li>
<li><a href="chapter/07/0704.html">7.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/08/0800.html">&#x7B2C;8&#x7AE0; &#x7528;&#x901A;&#x914D;&#x7B26;&#x8FDB;&#x884C;&#x8FC7;&#x6EE4;</a><ul>
<li><a href="chapter/08/0801.html">8.1 LIKE&#x64CD;&#x4F5C;&#x7B26;</a></li>
<li><a href="chapter/08/0802.html">8.2 &#x4F7F;&#x7528;&#x901A;&#x914D;&#x7B26;&#x7684;&#x6280;&#x5DE7;</a></li>
<li><a href="chapter/08/0803.html">8.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/09/0900.html">&#x7B2C;9&#x7AE0; &#x7528;&#x6B63;&#x5219;&#x8868;&#x8FBE;&#x5F0F;&#x8FDB;&#x884C;&#x641C;&#x7D22;</a><ul>
<li><a href="chapter/09/0901.html">9.1 &#x6B63;&#x5219;&#x8868;&#x8FBE;&#x5F0F;&#x4ECB;&#x7ECD;</a></li>
<li><a href="chapter/09/0902.html">9.2 &#x4F7F;&#x7528;MySQL&#x6B63;&#x5219;&#x8868;&#x8FBE;&#x5F0F;</a></li>
<li><a href="chapter/09/0903.html">9.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/10/1000.html">&#x7B2C;10&#x7AE0; &#x521B;&#x5EFA;&#x8BA1;&#x7B97;&#x5B57;&#x6BB5;</a><ul>
<li><a href="chapter/10/1001.html">10.1 &#x8BA1;&#x7B97;&#x5B57;&#x6BB5;</a></li>
<li><a href="chapter/10/1002.html">10.2 &#x62FC;&#x63A5;&#x5B57;&#x6BB5;</a></li>
<li><a href="chapter/10/1003.html">10.3 &#x6267;&#x884C;&#x7B97;&#x672F;&#x8BA1;&#x7B97;</a></li>
<li><a href="chapter/10/1004.html">10.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/11/1100.html">&#x7B2C;11&#x7AE0; &#x4F7F;&#x7528;&#x6570;&#x636E;&#x5904;&#x7406;&#x51FD;&#x6570;</a><ul>
<li><a href="chapter/11/1101.html">11.1 &#x51FD;&#x6570;</a></li>
<li><a href="chapter/11/1102.html">11.2 &#x4F7F;&#x7528;&#x51FD;&#x6570;</a></li>
<li><a href="chapter/11/1103.html">11.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/12/1200.html">&#x7B2C;12&#x7AE0; &#x6C47;&#x603B;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/12/1201.html">12.1 &#x805A;&#x96C6;&#x51FD;&#x6570;</a></li>
<li><a href="chapter/12/1202.html">12.2 &#x805A;&#x96C6;&#x4E0D;&#x540C;&#x503C;</a></li>
<li><a href="chapter/12/1203.html">12.3 &#x7EC4;&#x5408;&#x805A;&#x96C6;&#x51FD;&#x6570;</a></li>
<li><a href="chapter/12/1204.html">12.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/13/1300.html">&#x7B2C;13&#x7AE0; &#x5206;&#x7EC4;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/13/1301.html">13.1 &#x6570;&#x636E;&#x5206;&#x7EC4;</a></li>
<li><a href="chapter/13/1302.html">13.2 &#x521B;&#x5EFA;&#x5206;&#x7EC4;</a></li>
<li><a href="chapter/13/1303.html">13.3 &#x8FC7;&#x6EE4;&#x5206;&#x7EC4;</a></li>
<li><a href="chapter/13/1304.html">13.4 &#x5206;&#x7EC4;&#x548C;&#x6392;&#x5E8F;</a></li>
<li><a href="chapter/13/1305.html">13.5 SELECT&#x5B50;&#x53E5;&#x987A;&#x5E8F;</a></li>
<li><a href="chapter/13/1306.html">13.6 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/14/1400.html">&#x7B2C;14&#x7AE0; &#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;</a><ul>
<li><a href="chapter/14/1401.html">14.1 &#x5B50;&#x67E5;&#x8BE2;</a></li>
<li><a href="chapter/14/1402.html">14.2 &#x5229;&#x7528;&#x5B50;&#x67E5;&#x8BE2;&#x8FDB;&#x884C;&#x8FC7;&#x6EE4;</a></li>
<li><a href="chapter/14/1403.html">14.3 &#x4F5C;&#x4E3A;&#x8BA1;&#x7B97;&#x5B57;&#x6BB5;&#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;</a></li>
<li><a href="chapter/14/1404.html">14.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/15/1500.html">&#x7B2C;15&#x7AE0; &#x8054;&#x7ED3;&#x8868;</a><ul>
<li><a href="chapter/15/1501.html">15.1 &#x8054;&#x7ED3;</a></li>
<li><a href="chapter/15/1502.html">15.2 &#x521B;&#x5EFA;&#x8054;&#x7ED3;</a></li>
<li><a href="chapter/15/1503.html">15.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/16/1600.html">&#x7B2C;16&#x7AE0; &#x521B;&#x5EFA;&#x9AD8;&#x7EA7;&#x8054;&#x7ED3;</a><ul>
<li><a href="chapter/16/1601.html">16.1 &#x4F7F;&#x7528;&#x8868;&#x522B;&#x540D;</a></li>
<li><a href="chapter/16/1602.html">16.2 &#x4F7F;&#x7528;&#x4E0D;&#x540C;&#x7C7B;&#x578B;&#x7684;&#x8054;&#x7ED3;</a></li>
<li><a href="chapter/16/1603.html">16.3 &#x4F7F;&#x7528;&#x5E26;&#x805A;&#x96C6;&#x51FD;&#x6570;&#x7684;&#x8054;&#x7ED3;</a></li>
<li><a href="chapter/16/1604.html">16.4 &#x4F7F;&#x7528;&#x8054;&#x7ED3;&#x548C;&#x8054;&#x7ED3;&#x6761;&#x4EF6;</a></li>
<li><a href="chapter/16/1605.html">16.5 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/17/1700.html">&#x7B2C;17&#x7AE0; &#x7EC4;&#x5408;&#x67E5;&#x8BE2;</a><ul>
<li><a href="chapter/17/1701.html">17.1 &#x7EC4;&#x5408;&#x67E5;&#x8BE2;</a></li>
<li><a href="chapter/17/1702.html">17.2 &#x521B;&#x5EFA;&#x7EC4;&#x5408;&#x67E5;&#x8BE2;</a></li>
<li><a href="chapter/17/1703.html">17.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/18/1800.html">&#x7B2C;18&#x7AE0; &#x5168;&#x6587;&#x672C;&#x641C;&#x7D22;</a><ul>
<li><a href="chapter/18/1801.html">18.1 &#x7406;&#x89E3;&#x5168;&#x6587;&#x672C;&#x641C;&#x7D22;</a></li>
<li><a href="chapter/18/1802.html">18.2 &#x4F7F;&#x7528;&#x5168;&#x6587;&#x672C;&#x641C;&#x7D22;</a></li>
<li><a href="chapter/18/1803.html">18.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/19/1900.html">&#x7B2C;19&#x7AE0; &#x63D2;&#x5165;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/19/1901.html">19.1 &#x6570;&#x636E;&#x63D2;&#x5165;</a></li>
<li><a href="chapter/19/1902.html">19.2 &#x63D2;&#x5165;&#x5B8C;&#x6574;&#x7684;&#x884C;</a></li>
<li><a href="chapter/19/1903.html">19.3 &#x63D2;&#x5165;&#x591A;&#x4E2A;&#x884C;</a></li>
<li><a href="chapter/19/1904.html">19.4 &#x63D2;&#x5165;&#x68C0;&#x7D22;&#x51FA;&#x7684;&#x6570;&#x636E;</a></li>
<li><a href="chapter/19/1905.html">19.5 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/20/2000.html">&#x7B2C;20&#x7AE0; &#x66F4;&#x65B0;&#x548C;&#x5220;&#x9664;&#x6570;&#x636E;</a><ul>
<li><a href="chapter/20/2001.html">20.1 &#x66F4;&#x65B0;&#x6570;&#x636E;</a></li>
<li><a href="chapter/20/2002.html">20.2 &#x5220;&#x9664;&#x6570;&#x636E;</a></li>
<li><a href="chapter/20/2003.html">20.3 &#x66F4;&#x65B0;&#x548C;&#x5220;&#x9664;&#x7684;&#x6307;&#x5BFC;&#x539F;&#x5219;</a></li>
<li><a href="chapter/20/2004.html">20.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/21/2100.html">&#x7B2C;21&#x7AE0; &#x521B;&#x5EFA;&#x548C;&#x64CD;&#x7EB5;&#x8868;</a><ul>
<li><a href="chapter/21/2101.html">21.1 &#x521B;&#x5EFA;&#x8868;</a></li>
<li><a href="chapter/21/2102.html">21.2 &#x66F4;&#x65B0;&#x8868;</a></li>
<li><a href="chapter/21/2103.html">21.3 &#x5220;&#x9664;&#x8868;</a></li>
<li><a href="chapter/21/2104.html">21.4 &#x91CD;&#x547D;&#x540D;&#x8868;</a></li>
<li><a href="chapter/21/2105.html">21.5 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/22/2200.html">&#x7B2C;22&#x7AE0; &#x4F7F;&#x7528;&#x89C6;&#x56FE;</a><ul>
<li><a href="chapter/22/2201.html">22.1 &#x89C6;&#x56FE;</a></li>
<li><a href="chapter/22/2202.html">22.2 &#x4F7F;&#x7528;&#x89C6;&#x56FE;</a></li>
<li><a href="chapter/22/2203.html">22.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/23/2300.html">&#x7B2C;23&#x7AE0; &#x4F7F;&#x7528;&#x5B58;&#x50A8;&#x8FC7;&#x7A0B;</a><ul>
<li><a href="chapter/23/2301.html">23.1 &#x5B58;&#x50A8;&#x8FC7;&#x7A0B;</a></li>
<li><a href="chapter/23/2302.html">23.2 &#x4E3A;&#x4EC0;&#x4E48;&#x8981;&#x4F7F;&#x7528;&#x5B58;&#x50A8;&#x8FC7;&#x7A0B;</a></li>
<li><a href="chapter/23/2303.html">23.3 &#x4F7F;&#x7528;&#x5B58;&#x50A8;&#x8FC7;&#x7A0B;</a></li>
<li><a href="chapter/23/2304.html">23.4 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/24/2400.html">&#x7B2C;24&#x7AE0; &#x4F7F;&#x7528;&#x6E38;&#x6807;</a><ul>
<li><a href="chapter/24/2401.html">24.1 &#x6E38;&#x6807;</a></li>
<li><a href="chapter/24/2402.html">24.2 &#x4F7F;&#x7528;&#x6E38;&#x6807;</a></li>
<li><a href="chapter/24/2403.html">24.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/25/2500.html">&#x7B2C;25&#x7AE0; &#x4F7F;&#x7528;&#x89E6;&#x53D1;&#x5668;</a><ul>
<li><a href="chapter/25/2501.html">25.1 &#x89E6;&#x53D1;&#x5668;</a></li>
<li><a href="chapter/25/2502.html">25.2 &#x521B;&#x5EFA;&#x89E6;&#x53D1;&#x5668;</a></li>
<li><a href="chapter/25/2503.html">25.3 &#x5220;&#x9664;&#x89E6;&#x53D1;&#x5668;</a></li>
<li><a href="chapter/25/2504.html">25.4 &#x4F7F;&#x7528;&#x89E6;&#x53D1;&#x5668;</a></li>
<li><a href="chapter/25/2505.html">25.5 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/26/2600.html">&#x7B2C;26&#x7AE0; &#x7BA1;&#x7406;&#x4E8B;&#x52A1;&#x5904;&#x7406;</a><ul>
<li><a href="chapter/26/2601.html">26.1 &#x4E8B;&#x52A1;&#x5904;&#x7406;</a></li>
<li><a href="chapter/26/2602.html">26.2 &#x63A7;&#x5236;&#x4E8B;&#x52A1;&#x5904;&#x7406;</a></li>
<li><a href="chapter/26/2603.html">26.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/27/2700.html">&#x7B2C;27&#x7AE0; &#x5168;&#x7403;&#x5316;&#x548C;&#x672C;&#x5730;&#x5316;</a><ul>
<li><a href="chapter/27/2701.html">27.1 &#x5B57;&#x7B26;&#x96C6;&#x548C;&#x6821;&#x5BF9;&#x987A;&#x5E8F;</a></li>
<li><a href="chapter/27/2702.html">27.2 &#x4F7F;&#x7528;&#x5B57;&#x7B26;&#x96C6;&#x548C;&#x6821;&#x5BF9;&#x987A;&#x5E8F;</a></li>
<li><a href="chapter/27/2703.html">27.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/28/2800.html">&#x7B2C;28&#x7AE0; &#x5B89;&#x5168;&#x7BA1;&#x7406;</a><ul>
<li><a href="chapter/28/2801.html">28.1 &#x8BBF;&#x95EE;&#x63A7;&#x5236;</a></li>
<li><a href="chapter/28/2802.html">28.2 &#x7BA1;&#x7406;&#x7528;&#x6237;</a></li>
<li><a href="chapter/28/2803.html">28.3 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/29/2900.html">&#x7B2C;29&#x7AE0; &#x6570;&#x636E;&#x5E93;&#x7EF4;&#x62A4;</a><ul>
<li><a href="chapter/29/2901.html">29.1 &#x5907;&#x4EFD;&#x6570;&#x636E;</a></li>
<li><a href="chapter/29/2902.html">29.2 &#x8FDB;&#x884C;&#x6570;&#x636E;&#x5E93;&#x7EF4;&#x62A4;</a></li>
<li><a href="chapter/29/2903.html">29.3 &#x8BCA;&#x65AD;&#x542F;&#x52A8;&#x95EE;&#x9898;</a></li>
<li><a href="chapter/29/2904.html">29.4 &#x67E5;&#x770B;&#x65E5;&#x5FD7;&#x6587;&#x4EF6;</a></li>
<li><a href="chapter/29/2905.html">29.5 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
<li><a href="chapter/30/3000.html">&#x7B2C;30&#x7AE0; &#x6539;&#x5584;&#x6027;&#x80FD;</a><ul>
<li><a href="chapter/30/3001.html">30.1 &#x6539;&#x5584;&#x6027;&#x80FD;</a></li>
<li><a href="chapter/30/3002.html">30.2 &#x5C0F;&#x7ED3;</a></li>
</ul>
</li>
</ul>


                                </section>

    </div>
    <div class="search-results">
        <div class="has-results">

            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>

        </div>
        <div class="no-results">

            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>

        </div>
    </div>
</div>

                        </div>
                    </div>

            </div>


                <a href="chapter/01/0100.html" class="navigation navigation-next navigation-unique" aria-label="Next page: 第1章 了解SQL">
                    <i class="fa fa-angle-right"></i>
                </a>


    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"前言","level":"1.1","depth":1,"next":{"title":"第1章 了解SQL","level":"1.2","depth":1,"path":"chapter/01/0100.md","ref":"chapter/01/0100.md","articles":[{"title":"1.1 数据库基础","level":"1.2.1","depth":2,"path":"chapter/01/0101.md","ref":"chapter/01/0101.md","articles":[]},{"title":"1.2 什么是SQL","level":"1.2.2","depth":2,"path":"chapter/01/0102.md","ref":"chapter/01/0102.md","articles":[]},{"title":"1.3 动手实践","level":"1.2.3","depth":2,"path":"chapter/01/0103.md","ref":"chapter/01/0103.md","articles":[]},{"title":"1.4 小结","level":"1.2.4","depth":2,"path":"chapter/01/0104.md","ref":"chapter/01/0104.md","articles":[]}]},"dir":"ltr"},"config":{"plugins":["chapter-fold","mathjax","-lunr","-search","search-pro","hide-element","back-to-top-button","code","splitter","insert-logo","pageview-count","-sharing","sharing-plus","donate"],"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"chapter-fold":{},"splitter":{},"search-pro":{},"sharing-plus":{"qq":false,"all":["facebook","google","twitter","instapaper","linkedin","pocket","stumbleupon"],"douban":false,"facebook":true,"weibo":false,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":true,"messenger":false,"line":false,"vk":false,"pocket":true,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":false},"code":{"copyButtons":true},"donate":{"alipay":"https://vardar.oss-cn-shenzhen.aliyuncs.com/common/alipay.png","alipayText":"支付宝打赏","button":"赏","title":"","wechat":"https://vardar.oss-cn-shenzhen.aliyuncs.com/common/wechat.png","wechatText":"微信打赏"},"hide-element":{"elements":[".gitbook-link"]},"fontsettings":{"theme":"white","family":"sans","size":2},"highlight":{},"back-to-top-button":{},"pageview-count":{},"mathjax":{"forceSVG":false,"version":"2.6-latest"},"sharing":{"qq":true,"all":["google","weibo","qq","qzone"],"douban":false,"facebook":false,"weibo":true,"twitter":false,"pocket":false,"google":true,"qzone":true},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false},"insert-logo":{"style":"background: none; max-height: 100px; min-height: 50px","url":"https://upload.jianshu.io/users/upload_avatars/14645888/84d088ac-f881-45e0-8344-2388a65fd65a.png?imageMogr2/auto-orient/strip|imageView2/1/w/240/h/240"}},"theme":"default","author":"零创世界","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"MySQL必知必会","language":"zh-hans","gitbook":"3.2.3","description":"这是个零创世界"},"file":{"path":"README.md","mtime":"2020-05-07T08:33:50.908Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2020-05-14T06:35:10.638Z"},"basePath":".","book":{"language":""}});
        });
    </script>
</div>


    <script src="gitbook/gitbook.js"></script>
    <script src="gitbook/theme.js"></script>


        <script src="gitbook/gitbook-plugin-chapter-fold/chapter-fold.js"></script>


        <script src="https://cdn.mathjax.org/mathjax/2.6-latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>


        <script src="gitbook/gitbook-plugin-mathjax/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-search-pro/jquery.mark.min.js"></script>


        <script src="gitbook/gitbook-plugin-search-pro/search.js"></script>


        <script src="gitbook/gitbook-plugin-hide-element/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-back-to-top-button/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-code/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-splitter/splitter.js"></script>


        <script src="gitbook/gitbook-plugin-insert-logo/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-pageview-count/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-sharing-plus/buttons.js"></script>


        <script src="gitbook/gitbook-plugin-donate/plugin.js"></script>


        <script src="gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>


    </body>
</html>