manual_toc.html

MySQL参考手册中文版

        </ul>
      </li>
    </ul>
  </li>
  <li><a NAME="Compatibility" HREF="manual_Compatibility.html#Compatibility">5 MySQL&nbsp;与标准的兼容性？</a><ul>
      <li><a NAME="Extensions_to_ANSI" HREF="manual_Compatibility.html#Extensions_to_ANSI">5.1 
        MySQL对ANSI &nbsp;SQL92 的扩充</a></li>
      <li><a NAME="Ansi_mode" HREF="manual_Compatibility.html#Ansi_mode">5.2 以ANSI模式运行&nbsp;MySQL&nbsp;</a></li>
      <li><a NAME="Differences_from_ANSI" HREF="manual_Compatibility.html#Differences_from_ANSI">5.3 
        MySQL相比ANSI&nbsp;SQL92的差别</a></li>
      <li><a NAME="Missing_functions" HREF="manual_Compatibility.html#Missing_functions">5.4 MySQL&nbsp;缺乏的功能</a><ul>
          <li><a NAME="Missing_Sub-selects" HREF="manual_Compatibility.html#Missing_Sub-selects">5.4.1 
            子选择(Sub-selects)</a></li>
          <li><a NAME="Missing_SELECT_INTO_TABLE" HREF="manual_Compatibility.html#Missing_SELECT_INTO_TABLE">5.4.2 SELECT INTO TABLE</a></li>
          <li><a NAME="Missing_Transactions" HREF="manual_Compatibility.html#Missing_Transactions">5.4.3 
            事务(Transactions)</a></li>
          <li><a NAME="Missing_Triggers" HREF="manual_Compatibility.html#Missing_Triggers">5.4.4 
            存储过程和触发器</a></li>
          <li><a NAME="Missing_Foreign_Keys" HREF="manual_Compatibility.html#Missing_Foreign_Keys">5.4.5 
            外键(Foreign Keys)</a><ul>
              <li><a NAME="Broken_Foreign_KEY" HREF="manual_Compatibility.html#Broken_Foreign_KEY">5.4.5.1 
                不使用外键的理由</a></li>
            </ul>
          </li>
          <li><a NAME="Missing_Views" HREF="manual_Compatibility.html#Missing_Views">5.4.6 视图(Views)</a></li>
          <li><a NAME="Missing_comments" HREF="manual_Compatibility.html#Missing_comments">5.4.7 '--'作为一个 
            注解的开始</a></li>
        </ul>
      </li>
      <li><a NAME="Standards" HREF="manual_Compatibility.html#Standards">5.5 MySQL&nbsp;遵循什么标准？</a></li>
      <li><a NAME="Commit-rollback" HREF="manual_Compatibility.html#Commit-rollback">5.6 
        怎样处理没有提交/回卷(COMMIT / ROLLBACK)</a></li>
    </ul>
  </li>
  <li><a NAME="Privilege_system" HREF="manual_Privilege_system.html#Privilege_system">6 MySQL&nbsp;存取权限系统</a><ul>
      <li><a NAME="What_Privileges" href="manual_Privilege_system.html#What_Privileges">6.1 
        权限系统做什么</a></li>
      <li><a NAME="User_names" HREF="manual_Privilege_system.html#User_names">6.2 MySQL用户名和口令</a></li>
      <li><a NAME="Connecting" HREF="manual_Privilege_system.html#Connecting">6.3 与MySQL服务器连接</a></li>
      <li><a NAME="Password_security" HREF="manual_Privilege_system.html#Password_security">6.4 
        使你的口令安全</a></li>
      <li><a NAME="Privileges_provided" HREF="manual_Privilege_system.html#Privileges_provided">6.5 
        MySQL&nbsp;提供的权限</a></li>
      <li><a NAME="Privileges" href="manual_Privilege_system.html#Privileges">6.6 
        权限系统工作原理</a></li>
      <li><a NAME="Connection_access" HREF="manual_Privilege_system.html#Connection_access">6.7 
        存取控制,阶段1:连接证实</a></li>
      <li><a NAME="Request_access" HREF="manual_Privilege_system.html#Request_access">6.8 
        存取控制,阶段2:请求证实</a></li>
      <li><a NAME="Privilege_changes" HREF="manual_Privilege_system.html#Privilege_changes">6.9 
        权限更改何时生效</a></li>
      <li><a NAME="Default_privileges" HREF="manual_Privilege_system.html#Default_privileges">6.10 
        建立初始的&nbsp;MySQL权限</a></li>
      <li><a NAME="Adding_users" HREF="manual_Privilege_system.html#Adding_users">6.11 向MySQL增加新用户权限</a></li>
      <li><a NAME="Passwords" HREF="manual_Privilege_system.html#Passwords">6.12 
        怎样设置口令</a></li>
      <li><a NAME="Access_denied" HREF="manual_Privilege_system.html#Access_denied">6.13 
        存取拒绝(Access Denied)错误的原因</a></li>
      <li><a NAME="Security" HREF="manual_Privilege_system.html#Security">6.14 怎样使MySQL安全以对抗解密高手(cracker)</a></li>
    </ul>
  </li>
  <li><a NAME="Reference" HREF="manual_Reference.html#Reference">7 MySQL&nbsp;语言参考</a><ul>
      <li><a NAME="Literals" HREF="manual_Reference.html#Literals">7.1 文字:怎样写字符串和数字</a><ul>
          <li><a NAME="String_syntax" HREF="manual_Reference.html#String_syntax">7.1.1 字符串</a></li>
          <li><a NAME="Number_syntax" HREF="manual_Reference.html#Number_syntax">7.1.2 数字</a></li>
          <li><a NAME="Hexadecimal_values" HREF="manual_Reference.html#Hexadecimal_values">7.1.3 
            十六进制值</a></li>
          <li><a NAME="NULL_values" HREF="manual_Reference.html#NULL_values">7.1.4 NULL值</a></li>
          <li><a NAME="Legal_names" HREF="manual_Reference.html#Legal_names">7.1.5 
            数据库，表，索引，列和别名的命名</a><ul>
              <li><a NAME="Name_case_sensitivity" HREF="manual_Reference.html#Name_case_sensitivity">7.1.5.1 
                名字的大小写敏感性</a></li>
            </ul>
          </li>
        </ul>
      </li>
      <li><a NAME="Variables" HREF="manual_Reference.html#Variables">7.2 用户变量</a></li>
      <li><a NAME="Column_types" HREF="manual_Reference.html#Column_types">7.3 列类型</a><ul>
          <li><a NAME="Storage_requirements" HREF="manual_Reference.html#Storage_requirements">7.3.1 
            列类型的存储要求</a></li>
          <li><a NAME="Numeric_types" HREF="manual_Reference.html#Numeric_types">7.3.5 数字类型</a></li>
          <li><a NAME="Date_and_time_types" HREF="manual_Reference.html#Date_and_time_types">7.3.6 
            日期和时间类型</a><ul>
              <li><a NAME="Y2K_issues" HREF="manual_Reference.html#Y2K_issues">7.3.6.1 
                问题和日期类型</a></li>
              <li><a NAME="DATETIME" HREF="manual_Reference.html#DATETIME">7.3.6.2 DATETIME,DATE和TIMESTAMP类型</a></li>
              <li><a NAME="TIME" HREF="manual_Reference.html#TIME">7.3.6.3 TIME类型</a></li>
              <li><a NAME="YEAR" HREF="manual_Reference.html#YEAR">7.3.6.4 YEAR类型</a></li>
            </ul>
          </li>
          <li><a NAME="String_types" HREF="manual_Reference.html#String_types">7.3.7 字符串类型</a><ul>
              <li><a NAME="CHAR" HREF="manual_Reference.html#CHAR">7.3.7.1 CHAR和VARCHAR类型</a></li>
              <li><a NAME="BLOB" HREF="manual_Reference.html#BLOB">7.3.7.2 BLOB和TEXT类型</a></li>
              <li><a NAME="ENUM" HREF="manual_Reference.html#ENUM">7.3.7.3 ENUM类型</a></li>
              <li><a NAME="SET" HREF="manual_Reference.html#SET">7.3.7.4 SET类型</a></li>
            </ul>
          </li>
          <li><a NAME="Choosing_types" HREF="manual_Reference.html#Choosing_types">7.3.8 
            为列选择正确的类型</a></li>
          <li><a NAME="Indexes" HREF="manual_Reference.html#Indexes">7.3.9 列索引</a></li>
          <li><a NAME="Multiple-column_indexes" HREF="manual_Reference.html#Multiple-column_indexes">7.3.10 
            多列索引</a></li>
          <li><a NAME="Other-vendor_column_types" HREF="manual_Reference.html#Other-vendor_column_types">7.3.11 
            使用来自其他数据库引擎的列类型</a></li>
        </ul>
      </li>
      <li><a NAME="Functions" HREF="manual_Reference.html#Functions">7.4 用在SELECT和WHERE子句的函数</a><ul>
          <li><a NAME="Grouping_functions" HREF="manual_Reference.html#Grouping_functions">7.4.1 
            分组函数</a></li>
          <li><a NAME="Arithmetic_functions" HREF="manual_Reference.html#Arithmetic_functions">7.4.2 
            常用的算术运算</a></li>
          <li><a NAME="Bit_functions" HREF="manual_Reference.html#Bit_functions">7.4.3 位函数</a></li>
          <li><a NAME="Logical_functions" HREF="manual_Reference.html#Logical_functions">7.4.4 
            逻辑运算</a></li>
          <li><a NAME="Comparison_functions" HREF="manual_Reference.html#Comparison_functions">7.4.5 
            比较运算符</a></li>
          <li><a NAME="String_comparison_functions" HREF="manual_Reference.html#String_comparison_functions">7.4.6 字符串比较函数</a></li>
          <li><a NAME="Casts" HREF="manual_Reference.html#Casts">7.4.7 类型转换运算符</a></li>
          <li><a NAME="Control_flow_functions" HREF="manual_Reference.html#Control_flow_functions">7.4.8 
            控制流函数</a></li>
          <li><a NAME="Mathematical_functions" HREF="manual_Reference.html#Mathematical_functions">7.4.9 
            数学函数</a></li>
          <li><a NAME="String_functions" HREF="manual_Reference.html#String_functions">7.4.10 
            字符串函数</a></li>
          <li><a NAME="Date_and_time_functions" HREF="manual_Reference.html#Date_and_time_functions">7.4.11 
            日期和时间函数</a></li>
          <li><a NAME="Miscellaneous_functions" HREF="manual_Reference.html#Miscellaneous_functions">7.4.12 
            其他函数</a></li>
          <li><a NAME="Group_by_functions" HREF="manual_Reference.html#Group_by_functions">7.4.13 与GROUP 
            BY子句一起使用的函数</a></li>
        </ul>
      </li>
      <li><a NAME="CREATE_DATABASE" HREF="manual_Reference.html#CREATE_DATABASE">7.5 CREATE 
        DATABASE (创建数据库)句法</a></li>
      <li><a NAME="DROP_DATABASE" HREF="manual_Reference.html#DROP_DATABASE">7.6 DROP DATABASE (抛弃数据库)句法</a></li>
      <li><a NAME="CREATE_TABLE" HREF="manual_Reference.html#CREATE_TABLE">7.7 CREATE TABLE (创建表)句法</a><ul>
          <li><a NAME="Silent_column_changes" HREF="manual_Reference.html#Silent_column_changes">7.7.1 
            隐含(silent)的列指定变化</a></li>
        </ul>
      </li>
      <li><a NAME="ALTER_TABLE" HREF="manual_Reference.html#ALTER_TABLE">7.8 ALTER TABLE (改变表)句法</a></li>
      <li><a NAME="OPTIMIZE_TABLE" HREF="manual_Reference.html#OPTIMIZE_TABLE">7.9 OPTIMIZE TABLE 
        (优化表) 句法</a></li>
      <li><a NAME="DROP_TABLE" HREF="manual_Reference.html#DROP_TABLE">7.10 DROP TABLE (抛弃表)句法</a></li>
      <li><a NAME="DELETE" HREF="manual_Reference.html#DELETE">7.11 DELETE (删除)句法</a></li>
      <li><a NAME="SELECT" HREF="manual_Reference.html#SELECT">7.12 SELECT (精选)句法</a></li>
      <li><a NAME="JOIN" HREF="manual_Reference.html#JOIN">7.13 JOIN (联接)句法</a></li>
      <li><a NAME="INSERT" HREF="manual_Reference.html#INSERT">7.14 INSERT (插入)句法</a></li>
      <li><a NAME="REPLACE" HREF="manual_Reference.html#REPLACE">7.15 REPLACE (替换)句法</a></li>
      <li><a NAME="LOAD_DATA" HREF="manual_Reference.html#LOAD_DATA">7.16 LOAD DATA INFILE (装载数据到文件)句法</a></li>
      <li><a NAME="UPDATE" HREF="manual_Reference.html#UPDATE">7.17 UPDATE (更新)句法</a></li>
      <li><a NAME="USE" HREF="manual_Reference.html#USE">7.18 USE (使用)句法</a></li>
      <li><a NAME="FLUSH" HREF="manual_Reference.html#FLUSH">7.19 FLUSH (清除缓存）句法</a></li>
      <li><a NAME="KILL" HREF="manual_Reference.html#KILL">7.20 KILL (杀灭)句法</a></li>
      <li><a NAME="SHOW" HREF="manual_Reference.html#SHOW">7.21 SHOW (显示)句法(得到关于表,列等的信息）</a></li>
      <li><a NAME="EXPLAIN" HREF="manual_Reference.html#EXPLAIN">7.22 EXPLAIN (解释)句法(得到关于SELECT的信息)</a></li>
      <li><a NAME="DESCRIBE" HREF="manual_Reference.html#DESCRIBE">7.23 DESCRIBE (描述)句法(得到列的信息）</a></li>
      <li><a NAME="LOCK_TABLES" HREF="manual_Reference.html#LOCK_TABLES">7.24 LOCK TABLES/UNLOCK 
        TABLES (锁定表/解锁表)句法</a></li>
      <li><a NAME="SET_OPTION" HREF="manual_Reference.html#SET_OPTION">7.25 SET OPTION (设置选项)句法</a></li>
      <li><a NAME="GRANT" HREF="manual_Reference.html#GRANT">7.26 GRANT (授权)和REVOKE (撤回)句法</a></li>
      <li><a NAME="CREATE_INDEX" HREF="manual_Reference.html#CREATE_INDEX">7.27 CREATE INDEX (创建索引)句法</a></li>
      <li><a NAME="DROP_INDEX" HREF="manual_Reference.html#DROP_INDEX">7.28 DROP INDEX (抛弃索引)句法</a></li>
      <li><a NAME="Comments" HREF="manual_Reference.html#Comments">7.29 注释句法</a></li>
      <li><a NAME="CREATE_FUNCTION" HREF="manual_Reference.html#CREATE_FUNCTION">7.30 CREATE 
        FUNCTION/DROP FUNCTION (创建函数/抛弃函数)句法</a></li>
      <li><a NAME="Reserved_words" HREF="manual_Reference.html#Reserved_words">7.31 MySQL对保留字很挑剔吗？</a></li>
    </ul>
  </li>
  <li><a NAME="Tutorial" HREF="manual_Tutorial.html#Tutorial">8 MySQL&nbsp;教程</a><ul>
      <li><a NAME="Connecting-disconnecting" HREF="manual_Tutorial.html#Connecting-disconnecting">8.1 
        联接和断开服务器</a></li>
      <li><a NAME="Entering_queries" HREF="manual_Tutorial.html#Entering_queries">8.2 输入查询</a></li>
      <li><a NAME="Examples" HREF="manual_Tutorial.html#Examples">8.3 常用查询的例子</a><ul>
          <li><a NAME="example-Maximum-column" HREF="manual_Tutorial.html#example-Maximum-column">8.3.1 
            列的最大值</a></li>
          <li><a NAME="example-Maximum-row" HREF="manual_Tutorial.html#example-Maximum-row">8.3.2 
            拥有某个列的最大值的行</a></li>
          <li><a NAME="example-Maximum-column-group" HREF="manual_Tutorial.html#example-Maximum-column-group">8.3.3 列的最大值:按组:只有值</a></li>
          <li><a NAME="example-Maximum-column-group-row" HREF="manual_Tutorial.html#example-Maximum-column-group-row">8.3.4 
            拥有某个字段的组间最大值的行</a></li>
          <li><a NAME="example-Foreign_keys" HREF="manual_Tutorial.html#example-Foreign_keys">8.3.5 
            使用外键</a></li>
        </ul>
      </li>
      <li><a NAME="Database_use" HREF="manual_Tutorial.html#Database_use">8.4 
        创建并使用一个数据库</a><ul>
          <li><a NAME="Creating_database" HREF="manual_Tutorial.html#Creating_database">8.4.1 
            创建并选用一个数据库</a></li>
          <li><a NAME="Creating_tables" HREF="manual_Tutorial.html#Creating_tables">8.4.2 
            创建一个数据库表</a></li>
          <li><a NAME="Loading_tables" HREF="manual_Tutorial.html#Loading_tables">8.4.3 
            将数据装入数据库表</a></li>
          <li><a NAME="Retrieving_data" HREF="manual_Tutorial.html#Retrieving_data">8.4.4 
            从一个数据库表检索信息</a><ul>
              <li><a NAME="Selecting_all" HREF="manual_Tutorial.html#Selecting_all">8.4.4.1 
                选择所有数据</a></li>
              <li><a NAME="Selecting_rows" HREF="manual_Tutorial.html#Selecting_rows">8.4.4.2