MySQL开发者SQL权威指南-附录(3)

MySQL开发者SQL权威指南的附录文档

分别等同于如下的3个定义：

<character literal> ::= <character string><varchar literal> ::= <character string><long varchar literal> ::= <character string>

"符号

少数几个元符号，如"符号，是特殊SQL语句本身的一部分。为了避免混淆，这些符号用一个双引号符号表示。另外，这意味着用于SQL中的符号"在生成规则中表示为"""。

其他注意事项

任何以大写字母出现的内容，只要符号不是表示法的一部分，必须不做改变地采用。 生成规则的右边部分的符号的顺序是固定的。

生成规则中的空白没有意义。通常，添加它们是为了让规则更加可读。因此，如下的两个生成规则的含义是相同的：

<alphanumeric literal> ::= ' [ <character>... ] '

和

<alphanumeric literal> ::= '[<character>...]'

A.3 SQL中的保留字

MySQL支持所谓的保留字或关键字，如SELECT和CREATE。在MySQL中，这些保留字不能用作数据库对象（如表、列、视图和用户）的名字。下面的列表包含了SQL3标准中定义的保留字，后面的是MySQL自己的保留字列表。

ABSOLUTE, ACTION, ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC,ASSERTION, AT, AUTHORIZATION, AVG

BEGIN, BETWEEN, BIT, BIT_LENGTH, BOTH, BY

CASCADE, CASCADED, CASE, CAST, CATALOG, CHAR, CHARACTER, CHAR_LENGTH,CHARACTER_LENGTH, CHECK, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMIT,CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONTINUE, CONVERT,CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME,CURRENT_TIMESTAMP, CURRENT_USER, CURSOR

DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED,DELETE, DESC, DESCRIBE, DESCRIPTOR, DIAGNOSTICS, DISCONNECT, DISTINCT, DOMAIN,DOUBLE, DROP

ELSE, END, END-EXEC, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS,EXTERNAL, EXTRACT

FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FOUND, FROM, FULL GET, GLOBAL, GO, GOTO, GRANT, GROUP HAVING, HOUR

IDENTITY, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INPUT, INSENSITIVE,INSERT, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION JOIN KEY

MySQL开发者SQL权威指南的附录文档

600附录

LANGUAGE, LAST, LEADING, LEFT, LEVEL, LIKE, LOCAL, LOWER MATCH, MAX, MIN, MINUTE, MODULE, MONTH

NAMES, NATIONAL, NATURAL, NCHAR, NEXT, NO, NOT, NULL, NULLIF, NUMERIC

OCTET_LENGTH, OF, ON, ONLY, OPEN, OPTION, OR, ORDER, OUTER, OUTPUT, OVERLAPS PARTIAL, POSITION, PRECISION, PREPARE, PRESERVE, PRIMARY, PRIOR, PRIVILEGES,PROCEDURE, PUBLIC

READ, REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, ROLLBACK, ROWS

SCHEMA, SCROLL, SECOND, SECTION, SELECT, SESSION, SESSION_USER, SET, SIZE,SMALLINT, SOME, SQL, SQLCODE, SQLERROR, SQLSTATE, SUBSTRING, SUM, SYSTEM_USER TABLE, TEMPORARY, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO,TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIM, TRUE UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING VALUE, VALUES, VARCHAR, VARYING, VIEW WHEN, WHENEVER, WHERE, WITH, WORK, WRITE YEAR ZONE

这个列表是MySQL中保留字的列表。前面的列表中已经出现过的单词在这里省略掉了。 ANALYZE, ASENSITIVE

BEFORE, BIGINT, BINARY, BLOB CALL, CHANGE, CONDITION

DATABASE, DATABASES, DAY_HOUR, DAY_MICROSECOND, DAY_MINUTE,DAY_SECOND,DELAYED, DETERMINISTIC, DISTINCTROW, DIV, DUAL EACH, ELSEIF, ENCLOSED, ESCAPED, EXIT, EXPLAIN FLOAT4, FLOAT8, FORCE, FULLTEXT

HIGH_PRIORITY, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND

IF, IGNORE, INDEX, INFILE, INOUT, INT1, INT2, INT3, INT4, INT8, ITERATE KEYS, KILL

LABEL, LEAVE, LIMIT, LINES, LOAD, LOCALTIME, LOCALTIMESTAMP, LOCK, LONG,LONGBLOB, LONGTEXT, LOOP, LOW_PRIORITY

MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MIDDLEINT, MINUTE_MICROSECOND,MINUTE_SECOND, MOD, MODIFIES NO_WRITE_TO_BINLOG

OPTIMIZE, OPTIONALLY, OUT, OUTFILE PURGE

RAID0, READS, REGEXP, RELEASE, RENAME, REPEAT, REPLACE, REQUIRE, RETURN, RLIKE SCHEMAS, SECOND_MICROSECOND, SENSITIVE, SEPARATOR, SHOW, SONAME, SPATIAL,SPECIFIC, SQLEXCEPTION, SQLWARNING, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT, SSL, STARTING, STRAIGHT_JOIN TERMINATED, TINYBLOB, TINYINT, TINYTEXT, TRIGGER

UNDO, UNLOCK, UNSIGNED, USE, UTC_DATE, UTC_TIME, UTC_TIMESTAMP