> For the complete documentation index, see [llms.txt](https://404dream.gitbook.io/mysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://404dream.gitbook.io/mysql/summary.md).

# 第四章：指南

* [前言](/mysql/master.md)
* [第四章：指南](/mysql/summary.md)
  * [4.1 连接数据库](/mysql/summary/connecting-to-and-disconnecting-from-the-server.md)
  * [4.2 简单查询](/mysql/summary/entering-queries.md)
  * [4.3 创建并使用数据库](/mysql/summary/creating-and-using-a-database.md)
    * [4.3.1 选择数据库](/mysql/summary/creating-and-using-a-database/creating-and-selecting-a-database.md)
    * [4.3.2 创建表](/mysql/summary/creating-and-using-a-database/creating-a-table.md)
    * [4.3.3 加载数据](/mysql/summary/creating-and-using-a-database/loading-data-into-a-table.md)
    * [4.3.4 检索数据](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table.md)
      * [4.3.4.1 查询所有数据](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/selecting-all-data.md)
      * [4.3.4.2 查询指定行](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/selecting-particular-rows.md)
      * [4.3.4.3 查询指定列](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/selecting-particular-columns.md)
      * [4.3.4.4 结果排序](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/sorting-rows.md)
      * [4.3.4.5 日期计算](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/date-calculations.md)
      * [4.3.4.6 NULL值](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/working-with-null-values.md)
      * [4.3.4.7 正则匹配](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/pattern-matching.md)
      * [4.3.4.8 结果计数](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/counting-rows.md)
      * [4.3.4.9 多表查询](/mysql/summary/creating-and-using-a-database/retrieving-information-from-a-table/using-more-than-one-table.md)
  * [4.4 库表信息获取](/mysql/summary/getting-information-about-databases-and-tables.md)
  * [4.5 批处理模式](/mysql/summary/using-mysql-in-batch-mode.md)
  * [4.6 查询示例](/mysql/summary/examples-of-common-queries.md)
    * [4.6.1 列的最大值](/mysql/summary/examples-of-common-queries/the-maximum-value-for-a-column.md)
    * [4.6.2 某列最大值的行](/mysql/summary/examples-of-common-queries/maximum-of-column-per-group.md)
    * [4.6.3 多列的最大值](/mysql/summary/examples-of-common-queries/the-row-holding-the-maximum-of-a-certain-column.md)
    * [4.6.4 持有特定列的组合最大值的行](/mysql/summary/examples-of-common-queries/the-rows-holding-the-group-wise-maximum-of-a-certain-column.md)
    * [4.6.5 用户自定义变量](/mysql/summary/examples-of-common-queries/using-user-defined-variables.md)
    * [4.6.6 使用外键](/mysql/summary/examples-of-common-queries/using-foreign-keys.md)
    * [4.6.7 使用不同的key](/mysql/summary/examples-of-common-queries/searching-on-two-keys.md)
    * [4.6.8 每天计算访问量](/mysql/summary/examples-of-common-queries/calculating-visits-per-day.md)
    * [4.6.9 使用自增属性](/mysql/summary/examples-of-common-queries/using-autoincrement.md)
  * [4.7 在Apache中使用MySql](/mysql/summary/using-mysql-with-apache.md)
* [第五章：MySQL程序](/mysql/mysqlcheng-xu.md)
  * [5.1 MySQL程序概述](/mysql/mysqlcheng-xu/51-mysqlcheng-xu-gai-shu.md)
  * [5.2 使用MySQL程序](/mysql/mysqlcheng-xu/52-shi-yong-mysql-cheng-xu.md)
  * [5.3 MySQL服务器和服务器启动程序](/mysql/mysqlcheng-xu/53-mysqlfu-wu-qi-he-fu-wu-qi-qi-dong-cheng-xu.md)
  * [5.4 MySQL安装相关程序](/mysql/mysqlcheng-xu/54-mysqlan-zhuang-xiang-guan-cheng-xu.md)
  * [5.5 MySQL客户端程序](/mysql/mysqlcheng-xu/55-mysqlke-hu-duan-cheng-xu.md)
  * [5.6 MySQL管理和实用程序](/mysql/mysqlcheng-xu/56-mysqlguan-li-he-shi-yong-cheng-xu.md)
  * [5.7 MySQL程序开发实用程序](/mysql/mysqlcheng-xu/57-mysqlcheng-xu-kai-fa-shi-yong-cheng-xu.md)
  * [5.8 杂项计划](/mysql/mysqlcheng-xu/58-za-xiang-ji-hua.md)
  * [5.9 MySQL程序环境变量](/mysql/mysqlcheng-xu/59-mysqlcheng-xu-huan-jing-bian-liang.md)