本手册使用了某些排版约定：This manual uses certain typographical conventions:

当命令或语句以提示为前缀时，我们使用这些：When commands or statements are prefixed by a prompt, we use these:

$> type a command here
#> type a command as root here
C:\> type a command here (Windows only)
mysql> type a mysql statement here

命令在以下位置发出你的命令解释器。在 Unix 上，这通常是一个程序，例如 sh、csh 或 bash。在 Windows 上，等效程序是 command.com 或 cmd.exe，通常在控制台窗口中运行。以 mysql 为前缀的语句在 mysql 命令行客户端中发出。Commands are issued in your command interpreter. On Unix, this is typically a program such as sh, csh, or bash. On Windows, the equivalent program is command.com or cmd.exe, typically run in a console window. Statements prefixed by mysql are issued in the mysql command-line client.

在某些地区，不同的系统可能会彼此区分以表明命令应在两个不同的环境中执行。例如，在使用复制时，命令可能会以 source 和 replica 为前缀：In some areas different systems may be distinguished from each other to show that commands should be executed in two different environments. For example, while working with replication the commands might be prefixed with source and replica:

source> type a mysql statement on the replication source here
replica> type a mysql statement on the replica here

数据库、表和列名称通常必须替换为语句。为了表明这种替换是必要的，本手册使用 db_name、tbl_name 和 col_name。例如，您可能会看到如下语句：Database, table, and column names must often be substituted into statements. To indicate that such substitution is necessary, this manual uses db_name, tbl_name, and col_name. For example, you might see a statement like this:

mysql> SELECT col_name FROM db_name.tbl_name;

这意味着，如果您要输入类似的语句，您将提供自己的数据库、表和列名称，可能如下所示：This means that if you were to enter a similar statement, you would supply your own database, table, and column names, perhaps like this:

mysql> SELECT author_name FROM biblio_db.author_list;

SQL 关键字不区分大小写，可以以任何字母大小写书写。本手册使用大写字母。SQL keywords are not case-sensitive and may be written in any lettercase. This manual uses uppercase.

在语法说明中，方括号（“[”和“]”）表示可选单词或子句。例如，在以下语句中，IF EXISTS 是可选的：In syntax descriptions, square brackets (“[” and “]”) indicate optional words or clauses. For example, in the following statement, IF EXISTS is optional:

DROP TABLE [IF EXISTS] tbl_name

当语法元素由多个替代项组成时，替代项之间用竖线分隔（“|”）。当从一组选项可能中选择一个成员时，替代方案会在方括号内列出（“[”和“]”):When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). When one member from a set of choices may be chosen, the alternatives are listed within square brackets (“[” and “]”):

TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str)

When one member from a set of choices 必须 be chosen, the alternatives are listed within braces (“{”以及“}”):When one member from a set of choices must be chosen, the alternatives are listed within braces (“{” and “}”):

{DESCRIBE | DESC} tbl_name [col_name | wild]

省略号 (...) 表示省略语句的一部分，通常是为了提供更复杂语法的较短版本。例如， SELECT ... INTO OUTFILE 是 SELECT 语句形式的简写，该语句在其他部分后面有一个 INTO OUTFILE 子句An ellipsis (...) indicates the omission of a section of a statement, typically to provide a shorter version of more complex syntax. For example, SELECT ... INTO OUTFILE is shorthand for the form of SELECT statement that has an INTO OUTFILE clause following other parts of the statement.

省略号还可以指示语句的前面的语法元素可以重复。在以下示例中，可以给出多个 reset_option 值，第一个值后面的每个值都以逗号开头：An ellipsis can also indicate that the preceding syntax element of a statement may be repeated. In the following example, multiple reset_option values may be given, with each of those after the first preceded by commas:

RESET reset_option [,reset_option] ...

用于设置 shell 变量的命令使用 Bourne shell 语法显示。例如，设置 CC 环境变量并运行 configure 命令的顺序在 Bourne shell 语法中如下所示：Commands for setting shell variables are shown using Bourne shell syntax. For example, the sequence to set the CC environment variable and run the configure command looks like this in Bourne shell syntax:

$> CC=gcc ./configure

如果您使用 csh 或 tcsh，则必须以某种方式发出命令不同的是：If you are using csh or tcsh, you must issue commands somewhat differently:

$> setenv CC gcc
$> ./configure

参考手册源文件以 DocBook XML 格式编写。 HTML 版本和其他格式是自动生成的，主要使用 DocBook XSL 样式表。有关 DocBook 的信息，请参阅http://docbook.org/The Reference Manual source files are written in DocBook XML format. The HTML version and other formats are produced automatically, primarily using the DocBook XSL stylesheets. For information about DocBook, see http://docbook.org/

本手册最初由 David Axmark 和 Michael “Monty” Widenius 编写。它由 MySQL 文档团队维护，成员包括 Edward Gilmore、Sudharsana Gomadam、Kim seong Loh、Garima Sharma、Carlos Ortiz、Daniel So 和 Jon Stephens。This manual was originally written by David Axmark and Michael “Monty” Widenius. It is maintained by the MySQL Documentation Team, consisting of Edward Gilmore, Sudharsana Gomadam, Kim seong Loh, Garima Sharma, Carlos Ortiz, Daniel So, and Jon Stephens.