DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Function Index

Info Catalog (mysql.info.gz) MySQL FLOSS License Exception (mysql.info.gz) Top (mysql.info.gz) Concept Index
 
 SQL Command, Type, and Function Index
 *************************************
 
 [index]

Menu

 
* ! (logical NOT)                       Logical Operators.   (line  11)
* != (not equal)                        Comparison Operators.
                                                               (line  97)
* "                                     Legal names.         (line  42)
* % (modulo)                            Mathematical functions.
                                                               (line 175)
* % (wildcard character)                String syntax.       (line  44)
* & (bitwise AND)                       Bit functions.       (line  17)
* && (logical AND)                      Logical Operators.   (line  29)
* () (parentheses)                      Parentheses.         (line   6)
* (Control-Z) \Z                        String syntax.       (line  39)
* * (multiplication)                    Arithmetic functions.
                                                               (line  34)
* + (addition)                          Arithmetic functions.
                                                               (line  12)
* - (subtraction)                       Arithmetic functions.
                                                               (line  18)
* - (unary minus)                       Arithmetic functions.
                                                               (line  24)
* --password option                     Password security.   (line  18)
* -p option                             Password security.   (line  18)
* .my.cnf file <1>                      Multiple-server clients.
                                                               (line  34)
* .my.cnf file <2>                      Password security.   (line  49)
* .my.cnf file <3>                      Access denied.       (line  94)
* .my.cnf file <4>                      Connecting.          (line  56)
* .my.cnf file                          Option files.        (line  33)
* .mysql_history file                   mysql.               (line 262)
* .pid (process ID) file                Maintenance schedule.
                                                               (line  17)
* / (division)                          Arithmetic functions.
                                                               (line  48)
* /etc/passwd <1>                       SELECT.              (line 238)
* /etc/passwd                           Security against attack.
                                                               (line 109)
* < (less than)                         Comparison Operators.
                                                               (line 114)
* <<                                    Calculating days.    (line   6)
* << (left shift)                       Bit functions.       (line  39)
* <= (less than or equal)               Comparison Operators.
                                                               (line 108)
* <=> (equal to)                        Comparison Operators.
                                                               (line  84)
* <> (not equal)                        Comparison Operators.
                                                               (line  97)
* = (equal)                             Comparison Operators.
                                                               (line  70)
* > (greater than)                      Comparison Operators.
                                                               (line 126)
* >= (greater than or equal)            Comparison Operators.
                                                               (line 120)
* >> (right shift)                      Bit functions.       (line  47)
* \" (double quote)                     String syntax.       (line  34)
* \' (single quote)                     String syntax.       (line  33)
* \0 (ASCII 0)                          String syntax.       (line  32)
* \\ (escape)                           String syntax.       (line  43)
* \b (backspace)                        String syntax.       (line  35)
* \n (linefeed)                         String syntax.       (line  36)
* \n (newline)                          String syntax.       (line  36)
* \r (carriage return)                  String syntax.       (line  37)
* \t (tab)                              String syntax.       (line  38)
* \Z (Control-Z) ASCII 26               String syntax.       (line  39)
* ^ (bitwise XOR)                       Bit functions.       (line  25)
* _ (wildcard character)                String syntax.       (line  45)
* `                                     Legal names.         (line  42)
* ABS()                                 Mathematical functions.
                                                               (line   8)
* ACOS()                                Mathematical functions.
                                                               (line  18)
* ADDDATE()                             Date and time functions.
                                                               (line  44)
* addition (+)                          Arithmetic functions.
                                                               (line  12)
* ADDTIME()                             Date and time functions.
                                                               (line  63)
* AES_DECRYPT()                         Encryption functions.
                                                               (line  12)
* AES_ENCRYPT()                         Encryption functions.
                                                               (line  12)
* alias                                 Problems with alias. (line   6)
* ALL                                   SELECT.              (line 319)
* ALTER COLUMN                          ALTER TABLE.         (line 147)
* ALTER DATABASE                        ALTER DATABASE.      (line   6)
* ALTER FUNCTION                        ALTER PROCEDURE.     (line   6)
* ALTER PROCEDURE                       ALTER PROCEDURE.     (line   6)
* ALTER SCHEMA                          ALTER DATABASE.      (line   6)
* ALTER TABLE <1>                       ALTER TABLE problems.
                                                               (line   6)
* ALTER TABLE                           ALTER TABLE.         (line   6)
* ALTER VIEW                            ALTER VIEW.          (line   6)
* ANALYZE TABLE                         ANALYZE TABLE.       (line   6)
* AND, bitwise                          Bit functions.       (line  17)
* AND, logical                          Logical Operators.   (line  29)
* Area() <1>                            Multipolygon property functions.
                                                               (line   6)
* Area()                                Polygon property functions.
                                                               (line   6)
* arithmetic functions                  Bit functions.       (line   6)
* AS <1>                                JOIN.                (line  22)
* AS                                    SELECT.              (line  75)
* AsBinary()                            Functions to convert geometries between formats.
                                                               (line   9)
* ASCII()                               String functions.    (line  13)
* ASIN()                                Mathematical functions.
                                                               (line  29)
* AsText()                              Functions to convert geometries between formats.
                                                               (line  13)
* ATAN()                                Mathematical functions.
                                                               (line  38)
* ATAN2()                               Mathematical functions.
                                                               (line  47)
* AVG()                                 GROUP-BY-Functions.  (line   9)
* backspace (\b)                        String syntax.       (line  35)
* BACKUP TABLE                          BACKUP TABLE.        (line   6)
* BdMPolyFromText()                     GIS WKT Functions.   (line  57)
* BdMPolyFromWKB()                      GIS WKB Functions.   (line  58)
* BdPolyFromText()                      GIS WKT Functions.   (line  62)
* BdPolyFromWKB()                       GIS WKB Functions.   (line  63)
* BEGIN <1>                             BEGIN END.           (line   6)
* BEGIN                                 COMMIT.              (line   6)
* BENCHMARK()                           Information functions.
                                                               (line   6)
* BETWEEN ... AND                       Comparison Operators.
                                                               (line 175)
* BIGINT                                Numeric type overview.
                                                               (line  50)
* BIN()                                 String functions.    (line  28)
* BINARY <1>                            Cast Functions.      (line   6)
* BINARY                                String type overview.
                                                               (line 124)
* BIT                                   Numeric type overview.
                                                               (line  25)
* BIT_AND()                             GROUP-BY-Functions.  (line  16)
* BIT_COUNT                             Calculating days.    (line   6)
* BIT_COUNT()                           Bit functions.       (line  63)
* BIT_LENGTH()                          String functions.    (line  36)
* BIT_OR                                Calculating days.    (line   6)
* BIT_OR()                              GROUP-BY-Functions.  (line  25)
* BIT_XOR()                             GROUP-BY-Functions.  (line  31)
* BLOB <1>                              BLOB.                (line   6)
* BLOB                                  String type overview.
                                                               (line 141)
* BOOL                                  Numeric type overview.
                                                               (line  25)
* BOOLEAN                               Numeric type overview.
                                                               (line  25)
* Boundary()                            General geometry property functions.
                                                               (line  67)
* Buffer()                              Spatial operators.   (line  12)
* C\my.cnf file:                        Multiple-server clients.
                                                               (line  34)
* CACHE INDEX                           CACHE INDEX.         (line   6)
* CALL                                  CALL.                (line   6)
* carriage return (\r)                  String syntax.       (line  37)
* CASE <1>                              CASE Statement.      (line   6)
* CASE                                  Control flow functions.
                                                               (line   6)
* CAST                                  Cast Functions.      (line  59)
* casts                                 Cast Functions.      (line   6)
* CC environment variable <1>           Environment variables.
                                                               (line  18)
* CC environment variable <2>           Compilation problems.
                                                               (line 126)
* CC environment variable               configure options.   (line  70)
* CEILING()                             Mathematical functions.
                                                               (line  59)
* Centroid()                            Multipolygon property functions.
                                                               (line  23)
* CFLAGS environment variable <1>       Environment variables.
                                                               (line  18)
* CFLAGS environment variable <2>       Compilation problems.
                                                               (line 126)
* CFLAGS environment variable           configure options.   (line  84)
* CHANGE MASTER TO                      CHANGE MASTER TO.    (line   6)
* CHAR <1>                              String types.        (line   6)
* CHAR                                  String type overview.
                                                               (line  50)
* CHAR VARYING                          String type overview.
                                                               (line  95)
* CHAR()                                String functions.    (line  44)
* CHAR_LENGTH()                         String functions.    (line  54)
* CHARACTER                             String type overview.
                                                               (line  50)
* CHARACTER VARYING                     String type overview.
                                                               (line  95)
* CHARACTER_LENGTH()                    String functions.    (line  60)
* CHARACTER_SETS, INFORMATION_SCHEMA table CHARACTER_SETS Table.
                                                               (line   6)
* CHARSET()                             Information functions.
                                                               (line  26)
* CHECK TABLE                           CHECK TABLE.         (line   6)
* CHECKSUM TABLE                        CHECKSUM TABLE.      (line   6)
* CLOSE                                 CLOSE.               (line   6)
* COALESCE()                            Comparison Operators.
                                                               (line 197)
* COERCIBILITY()                        Information functions.
                                                               (line  38)
* COLLATION()                           Information functions.
                                                               (line  60)
* COLLATION_CHARACTER_SET_APPLICABILITY, INFORMATION_SCHEMA table COLLATION_CHARACTER_SET_APPLICABILITY Table.
                                                               (line   6)
* COLLATIONS, INFORMATION_SCHEMA table  COLLATIONS Table.    (line   6)
* COLUMN_PRIVILEGES, INFORMATION_SCHEMA table COLUMN_PRIVILEGES Table.
                                                               (line   6)
* COLUMNS, INFORMATION_SCHEMA table     COLUMNS Table.       (line   6)
* command-line options                  Server options.      (line   6)
* Comment syntax                        Comments.            (line   6)
* COMMIT <1>                            COMMIT.              (line   6)
* COMMIT                                ANSI diff Transactions.
                                                               (line   6)
* comparison operators                  Comparison Operators.
                                                               (line   6)
* COMPRESS()                            String functions.    (line  63)
* CONCAT()                              String functions.    (line  92)
* CONCAT_WS()                           String functions.    (line 107)
* configure option, --with-charset      configure options.   (line 130)
* configure option, --with-collation    configure options.   (line 130)
* configure option, --with-extra-charsets configure options. (line 130)
* CONNECTION_ID()                       Information functions.
                                                               (line  70)
* constraints                           Constraints.         (line   6)
* CONSTRAINTS, INFORMATION_SCHEMA table TABLE_CONSTRAINTS Table.
                                                               (line   6)
* Contains()                            Functions that test spatial relationships between geometries.
                                                               (line  17)
* control flow functions                Control flow functions.
                                                               (line   6)
* CONV()                                String functions.    (line 123)
* CONVERT                               Cast Functions.      (line  59)
* CONVERT TO                            ALTER TABLE.         (line 219)
* CONVERT_TZ()                          Date and time functions.
                                                               (line  75)
* ConvexHull()                          Spatial operators.   (line  16)
* COS()                                 Mathematical functions.
                                                               (line  72)
* COT()                                 Mathematical functions.
                                                               (line  78)
* COUNT()                               GROUP-BY-Functions.  (line  39)
* COUNT(DISTINCT)                       GROUP-BY-Functions.  (line  65)
* CR_SERVER_GONE_ERROR                  Gone away.           (line   6)
* CR_SERVER_LOST_ERROR                  Gone away.           (line   6)
* CRC32()                               Mathematical functions.
                                                               (line  86)
* CREATE DATABASE                       CREATE DATABASE.     (line   6)
* CREATE FUNCTION <1>                   CREATE FUNCTION.     (line   6)
* CREATE FUNCTION                       CREATE PROCEDURE.    (line   6)
* CREATE INDEX                          CREATE INDEX.        (line   6)
* CREATE PROCEDURE                      CREATE PROCEDURE.    (line   6)
* CREATE SCHEMA                         CREATE DATABASE.     (line   6)
* CREATE TABLE                          CREATE TABLE.        (line   6)
* CREATE USER                           CREATE USER.         (line   6)
* CREATE VIEW                           CREATE VIEW.         (line   6)
* CROSS JOIN                            JOIN.                (line   6)
* Crosses()                             Functions that test spatial relationships between geometries.
                                                               (line  21)
* CURDATE()                             Date and time functions.
                                                               (line  98)
* CURRENT_DATE                          Date and time functions.
                                                               (line 108)
* CURRENT_TIME                          Date and time functions.
                                                               (line 122)
* CURRENT_TIMESTAMP                     Date and time functions.
                                                               (line 126)
* CURRENT_USER()                        Information functions.
                                                               (line  79)
* CURTIME()                             Date and time functions.
                                                               (line 112)
* CXX environment variable <1>          Environment variables.
                                                               (line  18)
* CXX environment variable <2>          Compilation problems.
                                                               (line  66)
* CXX environment variable              configure options.   (line  70)
* CXXFLAGS environment variable <1>     Environment variables.
                                                               (line  18)
* CXXFLAGS environment variable <2>     Compilation problems.
                                                               (line 126)
* CXXFLAGS environment variable         configure options.   (line  84)
* Database information, obtaining       SHOW.                (line   6)
* DATABASE()                            Information functions.
                                                               (line 102)
* DATE <1>                              Using DATE.          (line   6)
* DATE <2>                              DATETIME.            (line   6)
* DATE                                  Date and time type overview.
                                                               (line  10)
* date and time functions               Date and time functions.
                                                               (line   6)
* DATE()                                Date and time functions.
                                                               (line 131)
* DATE_ADD()                            Date and time functions.
                                                               (line 152)
* DATE_FORMAT()                         Date and time functions.
                                                               (line 265)
* DATE_SUB()                            Date and time functions.
                                                               (line 152)
* DATEDIFF()                            Date and time functions.
                                                               (line 139)
* DATETIME <1>                          DATETIME.            (line   6)
* DATETIME                              Date and time type overview.
                                                               (line  16)
* DAY()                                 Date and time functions.
                                                               (line 340)
* DAYNAME()                             Date and time functions.
                                                               (line 344)
* DAYOFMONTH()                          Date and time functions.
                                                               (line 350)
* DAYOFWEEK()                           Date and time functions.
                                                               (line 356)
* DAYOFYEAR()                           Date and time functions.
                                                               (line 364)
* DBI->quote                            String syntax.       (line 107)
* DBI->trace                            Using gdb on mysqld. (line  86)
* DBI_TRACE environment variable <1>    Environment variables.
                                                               (line  18)
* DBI_TRACE environment variable        Using gdb on mysqld. (line  86)
* DBI_USER environment variable         Environment variables.
                                                               (line  18)
* DEALLOCATE PREPARE                    SQLPS.               (line   6)
* DEC                                   Numeric type overview.
                                                               (line 146)
* DECIMAL                               Numeric type overview.
                                                               (line 128)
* DECLARE                               DECLARE.             (line   6)
* DECODE()                              Encryption functions.
                                                               (line  48)
* DEFAULT value clause                  CREATE TABLE.        (line 211)
* DEFAULT()                             Miscellaneous functions.
                                                               (line   6)
* DEGREES()                             Mathematical functions.
                                                               (line  97)
* DELAYED                               INSERT DELAYED.      (line   6)
* DELETE                                DELETE.              (line   6)
* DES_DECRYPT()                         Encryption functions.
                                                               (line  59)
* DES_ENCRYPT()                         Encryption functions.
                                                               (line  81)
* DESC                                  DESCRIBE.            (line   6)
* DESCRIBE <1>                          DESCRIBE.            (line   6)
* DESCRIBE                              Getting information. (line   6)
* Difference()                          Spatial operators.   (line  20)
* Dimension()                           General geometry property functions.
                                                               (line   9)
* DISCARD TABLESPACE <1>                Multiple tablespaces.
                                                               (line  76)
* DISCARD TABLESPACE                    ALTER TABLE.         (line 259)
* Disjoint()                            Functions that test spatial relationships between geometries.
                                                               (line  39)
* Distance()                            Functions that test spatial relationships between geometries.
                                                               (line  43)
* DISTINCT <1>                          SELECT.              (line 319)
* DISTINCT <2>                          GROUP-BY-Functions.  (line  65)
* DISTINCT <3>                          DISTINCT optimization.
                                                               (line   6)
* DISTINCT                              Selecting columns.   (line  43)
* DISTINCTROW                           SELECT.              (line 319)
* DIV                                   Arithmetic functions.
                                                               (line  62)
* division (/)                          Arithmetic functions.
                                                               (line  48)
* DO                                    DO.                  (line   6)
* DOUBLE                                Numeric type overview.
                                                               (line 112)
* DOUBLE PRECISION                      Numeric type overview.
                                                               (line 122)
* double quote (\")                     String syntax.       (line  34)
* DOUBLE(M,D)                           Numeric type overview.
                                                               (line 112)
* DROP DATABASE                         DROP DATABASE.       (line   6)
* DROP FOREIGN KEY <1>                  InnoDB foreign key constraints.
                                                               (line 134)
* DROP FOREIGN KEY                      ALTER TABLE.         (line 208)
* DROP FUNCTION <1>                     CREATE FUNCTION.     (line   6)
* DROP FUNCTION                         DROP PROCEDURE.      (line   6)
* DROP INDEX <1>                        DROP INDEX.          (line   6)
* DROP INDEX                            ALTER TABLE.         (line 153)
* DROP PRIMARY KEY                      ALTER TABLE.         (line 164)
* DROP PROCEDURE                        DROP PROCEDURE.      (line   6)
* DROP SCHEMA                           DROP DATABASE.       (line   6)
* DROP TABLE                            DROP TABLE.          (line   6)
* DROP USER                             DROP USER.           (line   6)
* DROP VIEW                             DROP VIEW.           (line   6)
* DUMPFILE                              SELECT.              (line 293)
* ELT()                                 String functions.    (line 142)
* ENCODE()                              Encryption functions.
                                                               (line  52)
* ENCRYPT()                             Encryption functions.
                                                               (line 136)
* encryption functions                  Encryption functions.
                                                               (line   6)
* END                                   BEGIN END.           (line   6)
* EndPoint()                            Linestring property functions.
                                                               (line  10)
* ENUM <1>                              ENUM.                (line   6)
* ENUM                                  String type overview.
                                                               (line 160)
* Envelope()                            General geometry property functions.
                                                               (line  21)
* Environment variable, CC              Environment variables.
                                                               (line  18)
* environment variable, CC <1>          Compilation problems.
                                                               (line 126)
* environment variable, CC              configure options.   (line  70)
* Environment variable, CFLAGS          Environment variables.
                                                               (line  18)
* environment variable, CFLAGS <1>      Compilation problems.
                                                               (line 126)
* environment variable, CFLAGS          configure options.   (line  84)
* Environment variable, CXX             Environment variables.
                                                               (line  18)
* environment variable, CXX             Compilation problems.
                                                               (line 126)
* Environment variable, CXX             Compilation problems.
                                                               (line  66)
* environment variable, CXX             configure options.   (line  70)
* Environment variable, CXXFLAGS        Environment variables.
                                                               (line  18)
* environment variable, CXXFLAGS <1>    Compilation problems.
                                                               (line 126)
* environment variable, CXXFLAGS        configure options.   (line  84)
* Environment variable, DBI_TRACE <1>   Environment variables.
                                                               (line  18)
* Environment variable, DBI_TRACE       Using gdb on mysqld. (line  86)
* Environment variable, DBI_USER        Environment variables.
                                                               (line  18)
* Environment variable, HOME            Environment variables.
                                                               (line  18)
* environment variable, HOME            mysql.               (line 262)
* Environment variable, LD_LIBRARY_PATH Perl support problems.
                                                               (line  24)
* Environment variable, LD_RUN_PATH <1> Environment variables.
                                                               (line  18)
* Environment variable, LD_RUN_PATH     Perl support problems.
                                                               (line  24)
* environment variable, LD_RUN_PATH <1> Solaris.             (line 142)
* environment variable, LD_RUN_PATH     Source notes-Linux.  (line 103)
* Environment variable, MYSQL_DEBUG <1> Environment variables.
                                                               (line  18)
* Environment variable, MYSQL_DEBUG     Debugging client.    (line  10)
* environment variable, MYSQL_DEBUG     Client-Side Overview.
                                                               (line  75)
* Environment variable, MYSQL_HISTFILE  Environment variables.
                                                               (line  18)
* environment variable, MYSQL_HISTFILE  mysql.               (line 262)
* Environment variable, MYSQL_HOST      Environment variables.
                                                               (line  18)
* environment variable, MYSQL_HOST      Connecting.          (line  67)
* Environment variable, MYSQL_PS1       Environment variables.
                                                               (line  18)
* Environment variable, MYSQL_PWD       Environment variables.
                                                               (line  18)
* environment variable, MYSQL_PWD <1>   Client-Side Overview.
                                                               (line  75)
* environment variable, MYSQL_PWD       Connecting.          (line  67)
* Environment variable, MYSQL_TCP_PORT  Environment variables.
                                                               (line  18)
* environment variable, MYSQL_TCP_PORT <1> Client-Side Overview.
                                                               (line  75)
* environment variable, MYSQL_TCP_PORT <2> Multiple-server clients.
                                                               (line  27)
* environment variable, MYSQL_TCP_PORT  Multiple Unix servers.
                                                               (line  56)
* Environment variable, MYSQL_UNIX_PORT Environment variables.
                                                               (line  18)
* environment variable, MYSQL_UNIX_PORT <1> Client-Side Overview.
                                                               (line  75)
* environment variable, MYSQL_UNIX_PORT <2> Multiple-server clients.
                                                               (line  27)
* environment variable, MYSQL_UNIX_PORT Multiple Unix servers.
                                                               (line  56)
* Environment variable, MYSQL_UNIX_PORT mysql_install_db.    (line  67)
* Environment variable, PATH            Environment variables.
                                                               (line  18)
* environment variable, PATH            Installing binary.   (line 121)
* Environment variable, TMPDIR <1>      Environment variables.
                                                               (line  18)
* Environment variable, TMPDIR          mysql_install_db.    (line  67)
* Environment variable, TZ <1>          Environment variables.
                                                               (line  18)
* Environment variable, TZ              Timezone problems.   (line   6)
* Environment variable, UMASK <1>       Environment variables.
                                                               (line  18)
* Environment variable, UMASK           File permissions.    (line   6)
* Environment variable, UMASK_DIR <1>   Environment variables.
                                                               (line  18)
* Environment variable, UMASK_DIR       File permissions.    (line  19)
* Environment variable, USER            Environment variables.
                                                               (line  18)
* environment variable, USER            Connecting.          (line  67)
* Environment variables, CXX            Compilation problems.
                                                               (line  76)
* equal (=)                             Comparison Operators.
                                                               (line  70)
* Equals()                              Functions that test spatial relationships between geometries.
                                                               (line  47)
* escape (\\)                           String syntax.       (line  43)
* EXECUTE                               SQLPS.               (line   6)
* EXP()                                 Mathematical functions.
                                                               (line 103)
* EXPLAIN                               EXPLAIN.             (line   6)
* EXPORT_SET()                          String functions.    (line 152)
* ExteriorRing()                        Polygon property functions.
                                                               (line  18)
* EXTRACT()                             Date and time functions.
                                                               (line 370)
* FALSE                                 Number syntax.       (line   6)
* FETCH                                 FETCH.               (line   6)
* FIELD()                               String functions.    (line 165)
* FILE                                  String functions.    (line 255)
* FIND_IN_SET()                         String functions.    (line 176)
* FIXED                                 Numeric type overview.
                                                               (line 146)
* FLOAT                                 Numeric type overview.
                                                               (line  85)
* FLOAT(M,D)                            Numeric type overview.
                                                               (line 103)
* FLOAT(p)                              Numeric type overview.
                                                               (line  85)
* FLOOR()                               Mathematical functions.
                                                               (line 112)
* FLUSH                                 FLUSH.               (line   6)
* FOR UPDATE                            SELECT.              (line 308)
* FORCE INDEX <1>                       Optimizer Issues.    (line  25)
* FORCE INDEX <2>                       JOIN.                (line 103)
* FORCE INDEX                           SELECT.              (line  75)
* FORCE KEY <1>                         JOIN.                (line 109)
* FORCE KEY                             SELECT.              (line  75)
* FORMAT()                              Miscellaneous functions.
                                                               (line  15)
* FOUND_ROWS()                          Information functions.
                                                               (line 111)
* FROM                                  SELECT.              (line  75)
* FROM_DAYS()                           Date and time functions.
                                                               (line 387)
* FROM_UNIXTIME()                       Date and time functions.
                                                               (line 397)
* functions, arithmetic                 Bit functions.       (line   6)
* functions, bit                        Bit functions.       (line   6)
* functions, control flow               Control flow functions.
                                                               (line   6)
* functions, date and time              Date and time functions.
                                                               (line   6)
* functions, encryption                 Encryption functions.
                                                               (line   6)
* functions, GROUP BY                   GROUP-BY-Functions.  (line   6)
* functions, information                Information functions.
                                                               (line   6)
* functions, mathematical               Mathematical functions.
                                                               (line   8)
* functions, miscellaneous              Miscellaneous functions.
                                                               (line   6)
* functions, string                     String functions.    (line   6)
* functions, string comparison          String comparison functions.
                                                               (line   6)
* Functions, user-defined               CREATE FUNCTION.     (line   6)
* GeomCollFromText()                    GIS WKT Functions.   (line  14)
* GeomCollFromWKB()                     GIS WKB Functions.   (line  15)
* GEOMETRY                              MySQL spatial datatypes.
                                                               (line   6)
* GEOMETRYCOLLECTION                    MySQL spatial datatypes.
                                                               (line   6)
* GeometryCollection()                  GIS MySQL-Specific Functions.
                                                               (line  16)
* GeometryCollectionFromText()          GIS WKT Functions.   (line  14)
* GeometryCollectionFromWKB()           GIS WKB Functions.   (line  15)
* GeometryFromText()                    GIS WKT Functions.   (line  19)
* GeometryFromWKB()                     GIS WKB Functions.   (line  20)
* GeometryN()                           Geometrycollection property functions.
                                                               (line   6)
* GeometryType()                        General geometry property functions.
                                                               (line  36)
* GeomFromText() <1>                    Functions to convert geometries between formats.
                                                               (line  25)
* GeomFromText()                        GIS WKT Functions.   (line  19)
* GeomFromWKB() <1>                     Functions to convert geometries between formats.
                                                               (line  31)
* GeomFromWKB()                         GIS WKB Functions.   (line  20)
* GET_FORMAT()                          Date and time functions.
                                                               (line 416)
* GET_LOCK()                            Miscellaneous functions.
                                                               (line  27)
* GLength() <1>                         Multilinestring property functions.
                                                               (line   6)
* GLength()                             Linestring property functions.
                                                               (line  22)
* GRANT                                 GRANT.               (line   6)
* GRANT statement <1>                   Secure GRANT.        (line   6)
* GRANT statement                       Adding users.        (line   6)
* GRANTS                                SHOW GRANTS.         (line   6)
* greater than (>)                      Comparison Operators.
                                                               (line 126)
* greater than or equal (>=)            Comparison Operators.
                                                               (line 120)
* GREATEST()                            Comparison Operators.
                                                               (line 207)
* GROUP BY                              GROUP BY optimization.
                                                               (line   6)
* GROUP BY functions                    GROUP-BY-Functions.  (line   6)
* GROUP_CONCAT()                        GROUP-BY-Functions.  (line  77)
* HANDLER                               HANDLER.             (line   6)
* HAVING                                SELECT.              (line 159)
* HEX()                                 String functions.    (line 190)
* hexadecimal values                    Hexadecimal values.  (line   6)
* HIGH_PRIORITY                         SELECT.              (line 328)
* HOME environment variable <1>         Environment variables.
                                                               (line  18)
* HOME environment variable             mysql.               (line 262)
* host.frm, problems finding            Unix post-installation.
                                                               (line 181)
* HOUR()                                Date and time functions.
                                                               (line 451)
* identifiers, quoting                  Legal names.         (line  42)
* IF                                    IF Statement.        (line   6)
* IF()                                  Control flow functions.
                                                               (line  29)
* IFNULL()                              Control flow functions.
                                                               (line  77)
* IGNORE INDEX <1>                      JOIN.                (line  95)
* IGNORE INDEX                          SELECT.              (line  75)
* IGNORE KEY <1>                        JOIN.                (line 109)
* IGNORE KEY                            SELECT.              (line  75)
* IMPORT TABLESPACE <1>                 Multiple tablespaces.
                                                               (line  76)
* IMPORT TABLESPACE                     ALTER TABLE.         (line 259)
* IN                                    Comparison Operators.
                                                               (line 220)
* INET_ATON()                           Miscellaneous functions.
                                                               (line  60)
* INET_NTOA()                           Miscellaneous functions.
                                                               (line  80)
* information functions                 Information functions.
                                                               (line   6)
* INFORMATION_SCHEMA <1>                INFORMATION_SCHEMA Tables.
                                                               (line   6)
* INFORMATION_SCHEMA                    INFORMATION_SCHEMA.  (line   6)
* INNER JOIN                            JOIN.                (line   6)
* INSERT <1>                            INSERT.              (line   6)
* INSERT                                Insert speed.        (line   6)
* INSERT ... SELECT                     INSERT.              (line 248)
* INSERT DELAYED                        INSERT DELAYED.      (line   6)
* INSERT statement, grant privileges    Adding users.        (line  84)
* INSERT()                              String functions.    (line 206)
* INSTR()                               String functions.    (line 223)
* INT                                   Numeric type overview.
                                                               (line  43)
* INTEGER                               Numeric type overview.
                                                               (line  47)
* InteriorRingN()                       Polygon property functions.
                                                               (line  30)
* Intersection()                        Spatial operators.   (line  24)
* Intersects()                          Functions that test spatial relationships between geometries.
                                                               (line  51)
* INTERVAL()                            Comparison Operators.
                                                               (line 261)
* IS boolean_value                      Comparison Operators.
                                                               (line 132)
* IS NOT boolean_value                  Comparison Operators.
                                                               (line 132)
* IS NOT NULL                           Comparison Operators.
                                                               (line 144)
* IS NULL <1>                           Comparison Operators.
                                                               (line 144)
* IS NULL                               IS NULL optimization.
                                                               (line   6)
* IS NULL, and indexes                  MySQL indexes.       (line 117)
* IS_FREE_LOCK()                        Miscellaneous functions.
                                                               (line  89)
* IS_USED_LOCK()                        Miscellaneous functions.
                                                               (line  97)
* IsClosed() <1>                        Multilinestring property functions.
                                                               (line  19)
* IsClosed()                            Linestring property functions.
                                                               (line  34)
* IsEmpty()                             General geometry property functions.
                                                               (line  71)
* ISNULL()                              Comparison Operators.
                                                               (line 249)
* ISOLATION LEVEL                       SET TRANSACTION.     (line   6)
* IsRing()                              Linestring property functions.
                                                               (line  86)
* IsSimple()                            General geometry property functions.
                                                               (line  76)
* ITERATE                               ITERATE Statement.   (line   6)
* JOIN                                  JOIN.                (line   6)
* KEY_COLUMN_USAGE, INFORMATION_SCHEMA table KEY_COLUMN_USAGE Table.
                                                               (line   6)
* KILL                                  KILL.                (line   6)
* LAST_DAY()                            Date and time functions.
                                                               (line 464)
* LAST_INSERT_ID() <1>                  INSERT.              (line 200)
* LAST_INSERT_ID()                      ANSI diff Transactions.
                                                               (line 157)
* LAST_INSERT_ID([EXPR])                Information functions.
                                                               (line 171)
* LCASE()                               String functions.    (line 237)
* LD_LIBRARY_PATH environment variable  Perl support problems.
                                                               (line  24)
* LD_RUN_PATH environment variable <1>  Environment variables.
                                                               (line  18)
* LD_RUN_PATH environment variable <2>  Perl support problems.
                                                               (line  24)
* LD_RUN_PATH environment variable <3>  Solaris.             (line 142)
* LD_RUN_PATH environment variable      Source notes-Linux.  (line 103)
* LEAST()                               Comparison Operators.
                                                               (line 274)
* LEAVE                                 LEAVE Statement.     (line   6)
* LEFT JOIN <1>                         JOIN.                (line   6)
* LEFT JOIN                             LEFT JOIN optimization.
                                                               (line   6)
* LEFT OUTER JOIN                       JOIN.                (line   6)
* LEFT()                                String functions.    (line 240)
* LENGTH()                              String functions.    (line 246)
* less than (<)                         Comparison Operators.
                                                               (line 114)
* less than or equal (<=)               Comparison Operators.
                                                               (line 108)
* LIKE                                  String comparison functions.
                                                               (line  31)
* LIKE, and indexes                     MySQL indexes.       (line  92)
* LIKE, and wildcards                   MySQL indexes.       (line  92)
* LIMIT <1>                             SELECT.              (line 211)
* LIMIT <2>                             Information functions.
                                                               (line 111)
* LIMIT                                 LIMIT optimization.  (line   6)
* linefeed (\n)                         String syntax.       (line  36)
* LineFromText()                        GIS WKT Functions.   (line  24)
* LineFromWKB()                         GIS WKB Functions.   (line  25)
* LINESTRING                            MySQL spatial datatypes.
                                                               (line   6)
* LineString()                          GIS MySQL-Specific Functions.
                                                               (line  21)
* LineStringFromText()                  GIS WKT Functions.   (line  24)
* LineStringFromWKB()                   GIS WKB Functions.   (line  25)
* LN()                                  Mathematical functions.
                                                               (line 122)
* LOAD DATA FROM MASTER                 LOAD DATA FROM MASTER.
                                                               (line   6)
* LOAD DATA INFILE <1>                  Problems with NULL.  (line  50)
* LOAD DATA INFILE                      LOAD DATA.           (line   6)
* LOAD TABLE FROM MASTER                LOAD TABLE FROM MASTER.
                                                               (line   6)
* LOAD_FILE()                           String functions.    (line 255)
* LOCALTIME                             Date and time functions.
                                                               (line 480)
* LOCALTIMESTAMP                        Date and time functions.
                                                               (line 485)
* LOCATE()                              String functions.    (line 274)
* LOCK IN SHARE MODE                    SELECT.              (line 308)
* LOCK TABLES                           LOCK TABLES.         (line   6)
* LOG()                                 Mathematical functions.
                                                               (line 133)
* LOG10()                               Mathematical functions.
                                                               (line 165)
* LOG2()                                Mathematical functions.
                                                               (line 153)
* logical operators                     Logical Operators.   (line   6)
* LONG                                  BLOB.                (line   6)
* LONGBLOB                              String type overview.
                                                               (line 151)
* LONGTEXT                              String type overview.
                                                               (line 151)
* LOOP                                  LOOP Statement.      (line   6)
* LOWER()                               String functions.    (line 293)
* LPAD()                                String functions.    (line 303)
* LTRIM()                               String functions.    (line 313)
* MAKE_SET()                            String functions.    (line 321)
* MAKEDATE()                            Date and time functions.
                                                               (line 490)
* MAKETIME()                            Date and time functions.
                                                               (line 503)
* MASTER_POS_WAIT() <1>                 MASTER_POS_WAIT.     (line   6)
* MASTER_POS_WAIT()                     Miscellaneous functions.
                                                               (line 104)
* MATCH ... AGAINST()                   Fulltext Search.     (line  14)
* mathematical functions                Mathematical functions.
                                                               (line   8)
* MAX()                                 GROUP-BY-Functions.  (line 127)
* MAX_CONNECTIONS_PER_HOUR              User resources.      (line   6)
* MAX_QUERIES_PER_HOUR                  User resources.      (line   6)
* MAX_UPDATES_PER_HOUR                  User resources.      (line   6)
* MAX_USER_CONNECTIONS                  User resources.      (line   6)
* MBRContains()                         Relations on geometry MBR.
                                                               (line   9)
* MBRDisjoint()                         Relations on geometry MBR.
                                                               (line  22)
* MBREqual()                            Relations on geometry MBR.
                                                               (line  27)
* MBRIntersects()                       Relations on geometry MBR.
                                                               (line  31)
* MBROverlaps()                         Relations on geometry MBR.
                                                               (line  35)
* MBRTouches()                          Relations on geometry MBR.
                                                               (line  39)
* MBRWithin()                           Relations on geometry MBR.
                                                               (line  43)
* MD5()                                 Encryption functions.
                                                               (line 154)
* MEDIUMBLOB                            String type overview.
                                                               (line 146)
* MEDIUMINT                             Numeric type overview.
                                                               (line  39)
* MEDIUMTEXT                            String type overview.
                                                               (line 146)
* MICROSECOND()                         Date and time functions.
                                                               (line 512)
* MID()                                 String functions.    (line 337)
* MIN()                                 GROUP-BY-Functions.  (line 127)
* minus, unary (-)                      Arithmetic functions.
                                                               (line  24)
* MINUTE()                              Date and time functions.
                                                               (line 523)
* miscellaneous functions               Miscellaneous functions.
                                                               (line   6)
* MLineFromText()                       GIS WKT Functions.   (line  29)
* MLineFromWKB()                        GIS WKB Functions.   (line  30)
* MOD (modulo)                          Mathematical functions.
                                                               (line 175)
* MOD()                                 Mathematical functions.
                                                               (line 175)
* modulo (%)                            Mathematical functions.
                                                               (line 175)
* modulo (MOD)                          Mathematical functions.
                                                               (line 175)
* MONTH()                               Date and time functions.
                                                               (line 529)
* MONTHNAME()                           Date and time functions.
                                                               (line 535)
* MPointFromText()                      GIS WKT Functions.   (line  34)
* MPointFromWKB()                       GIS WKB Functions.   (line  35)
* MPolyFromText()                       GIS WKT Functions.   (line  39)
* MPolyFromWKB()                        GIS WKB Functions.   (line  40)
* MULTILINESTRING                       MySQL spatial datatypes.
                                                               (line   6)
* MultiLineString()                     GIS MySQL-Specific Functions.
                                                               (line  27)
* MultiLineStringFromText()             GIS WKT Functions.   (line  29)
* MultiLineStringFromWKB()              GIS WKB Functions.   (line  30)
* multiplication (*)                    Arithmetic functions.
                                                               (line  34)
* MULTIPOINT                            MySQL spatial datatypes.
                                                               (line   6)
* MultiPoint()                          GIS MySQL-Specific Functions.
                                                               (line  32)
* MultiPointFromText()                  GIS WKT Functions.   (line  34)
* MultiPointFromWKB()                   GIS WKB Functions.   (line  35)
* MULTIPOLYGON                          MySQL spatial datatypes.
                                                               (line   6)
* MultiPolygon()                        GIS MySQL-Specific Functions.
                                                               (line  36)
* MultiPolygonFromText()                GIS WKT Functions.   (line  39)
* MultiPolygonFromWKB()                 GIS WKB Functions.   (line  40)
* my_init()                             my_init.             (line   6)
* my_ulonglong C type                   C API datatypes.     (line  36)
* my_ulonglong values, printing         C API datatypes.     (line  36)
* MySQL C type                          C API Prepared statement datatypes.
                                                               (line 121)
* MYSQL C type                          C API datatypes.     (line   6)
* mysql_affected_rows()                 mysql_affected_rows. (line   6)
* mysql_autocommit().                   mysql_autocommit.    (line   6)
* MYSQL_BIND C type                     C API Prepared statement datatypes.
                                                               (line  28)
* mysql_change_user()                   mysql_change_user.   (line   6)
* mysql_character_set_name()            mysql_character_set_name.
                                                               (line   6)
* mysql_close()                         mysql_close.         (line   6)
* mysql_commit().                       mysql_commit.        (line   6)
* mysql_connect()                       mysql_connect.       (line   6)
* mysql_create_db()                     mysql_create_db.     (line   6)
* mysql_data_seek()                     mysql_data_seek.     (line   6)
* MYSQL_DEBUG environment variable <1>  Environment variables.
                                                               (line  18)
* MYSQL_DEBUG environment variable <2>  Debugging client.    (line  10)
* MYSQL_DEBUG environment variable      Client-Side Overview.
                                                               (line  75)
* mysql_debug()                         mysql_debug.         (line   6)
* mysql_drop_db()                       mysql_drop_db.       (line   6)
* mysql_dump_debug_info()               mysql_dump_debug_info.
                                                               (line   6)
* mysql_eof()                           mysql_eof.           (line   6)
* mysql_errno()                         mysql_errno.         (line   6)
* mysql_error()                         mysql_error.         (line   6)
* mysql_escape_string()                 mysql_escape_string. (line   6)
* mysql_fetch_field()                   mysql_fetch_field.   (line   6)
* mysql_fetch_field_direct()            mysql_fetch_field_direct.
                                                               (line   6)
* mysql_fetch_fields()                  mysql_fetch_fields.  (line   6)
* mysql_fetch_lengths()                 mysql_fetch_lengths. (line   6)
* mysql_fetch_row()                     mysql_fetch_row.     (line   6)
* MYSQL_FIELD C type                    C API datatypes.     (line  23)
* mysql_field_count() <1>               mysql_num_fields.    (line   6)
* mysql_field_count()                   mysql_field_count.   (line   6)
* MYSQL_FIELD_OFFSET C type             C API datatypes.     (line  31)
* mysql_field_seek()                    mysql_field_seek.    (line   6)
* mysql_field_tell()                    mysql_field_tell.    (line   6)
* mysql_free_result()                   mysql_free_result.   (line   6)
* mysql_get_client_info()               mysql_get_client_info.
                                                               (line   6)
* mysql_get_client_version()            mysql_get_client_version.
                                                               (line   6)
* mysql_get_host_info()                 mysql_get_host_info. (line   6)
* mysql_get_proto_info()                mysql_get_proto_info.
                                                               (line   6)
* mysql_get_server_info()               mysql_get_server_info.
                                                               (line   6)
* mysql_get_server_version()            mysql_get_server_version.
                                                               (line   6)
* mysql_hex_string()                    mysql_hex_string.    (line   6)
* MYSQL_HISTFILE environment variable <1> Environment variables.
                                                               (line  18)
* MYSQL_HISTFILE environment variable   mysql.               (line 262)
* MYSQL_HOST environment variable <1>   Environment variables.
                                                               (line  18)
* MYSQL_HOST environment variable       Connecting.          (line  67)
* mysql_info() <1>                      mysql_info.          (line   6)
* mysql_info() <2>                      ALTER TABLE.         (line 276)
* mysql_info() <3>                      UPDATE.              (line  60)
* mysql_info() <4>                      LOAD DATA.           (line 482)
* mysql_info()                          INSERT.              (line 245)
* mysql_init()                          mysql_init.          (line   6)
* mysql_insert_id() <1>                 mysql_insert_id.     (line   6)
* mysql_insert_id() <2>                 INSERT.              (line 200)
* mysql_insert_id()                     ANSI diff Transactions.
                                                               (line 157)
* mysql_kill()                          mysql_kill.          (line   6)
* mysql_library_end()                   mysql_library_end.   (line   6)
* mysql_library_init()                  mysql_library_init.  (line   6)
* mysql_list_dbs()                      mysql_list_dbs.      (line   6)
* mysql_list_fields()                   mysql_list_fields.   (line   6)
* mysql_list_processes()                mysql_list_processes.
                                                               (line   6)
* mysql_list_tables()                   mysql_list_tables.   (line   6)
* mysql_more_results().                 mysql_more_results.  (line   6)
* mysql_next_result().                  mysql_next_result.   (line   6)
* mysql_num_fields()                    mysql_num_fields.    (line   6)
* mysql_num_rows()                      mysql_num_rows.      (line   6)
* mysql_options()                       mysql_options.       (line   6)
* mysql_ping()                          mysql_ping.          (line   6)
* MYSQL_PS1 environment variable        Environment variables.
                                                               (line  18)
* MYSQL_PWD environment variable <1>    Environment variables.
                                                               (line  18)
* MYSQL_PWD environment variable <2>    Client-Side Overview.
                                                               (line  75)
* MYSQL_PWD environment variable        Connecting.          (line  67)
* mysql_query() <1>                     C API problems.      (line   6)
* mysql_query()                         mysql_query.         (line   6)
* mysql_real_connect()                  mysql_real_connect.  (line   6)
* mysql_real_escape_string() <1>        mysql_real_escape_string.
                                                               (line   6)
* mysql_real_escape_string()            String syntax.       (line 107)
* mysql_real_query()                    mysql_real_query.    (line   6)
* mysql_reload()                        mysql_reload.        (line   6)
* MYSQL_RES C type                      C API datatypes.     (line  10)
* mysql_rollback().                     mysql_rollback.      (line   6)
* MYSQL_ROW C type                      C API datatypes.     (line  16)
* mysql_row_seek()                      mysql_row_seek.      (line   6)
* mysql_row_tell()                      mysql_row_tell.      (line   6)
* mysql_select_db()                     mysql_select_db.     (line   6)
* mysql_server_end()                    mysql_server_end.    (line   6)
* mysql_server_init()                   mysql_server_init.   (line   6)
* mysql_set_sever_option()              mysql_set_server_option.
                                                               (line   6)
* mysql_shutdown()                      mysql_shutdown.      (line   6)
* mysql_sqlstate()                      mysql_sqlstate.      (line   6)
* mysql_ssl_set()                       mysql_ssl_set.       (line   6)
* mysql_stat()                          mysql_stat.          (line   6)
* MYSQL_STMT C type                     C API Prepared statement datatypes.
                                                               (line  14)
* mysql_stmt_affected_rows()            mysql_stmt_affected_rows.
                                                               (line   6)
* mysql_stmt_attr_get()                 mysql_stmt_attr_get. (line   6)
* mysql_stmt_attr_set()                 mysql_stmt_attr_set. (line   6)
* mysql_stmt_bind_param()               mysql_stmt_bind_param.
                                                               (line   6)
* mysql_stmt_bind_result()              mysql_stmt_bind_result.
                                                               (line   6)
* mysql_stmt_close()                    mysql_stmt_close.    (line   6)
* mysql_stmt_data_seek()                mysql_stmt_data_seek.
                                                               (line   6)
* mysql_stmt_errno()                    mysql_stmt_errno.    (line   6)
* mysql_stmt_error().                   mysql_stmt_error.    (line   6)
* mysql_stmt_execute()                  mysql_stmt_execute.  (line   6)
* mysql_stmt_fetch()                    mysql_stmt_fetch.    (line   6)
* mysql_stmt_fetch_column()             mysql_stmt_fetch_column.
                                                               (line   6)
* mysql_stmt_field_count()              mysql_stmt_field_count.
                                                               (line   6)
* mysql_stmt_free_result()              mysql_stmt_free_result.
                                                               (line   6)
* mysql_stmt_init()                     mysql_stmt_init.     (line   6)
* mysql_stmt_insert_id()                mysql_stmt_insert_id.
                                                               (line   6)
* mysql_stmt_num_rows()                 mysql_stmt_num_rows. (line   6)
* mysql_stmt_param_count()              mysql_stmt_param_count.
                                                               (line   6)
* mysql_stmt_param_metadata()           mysql_stmt_param_metadata.
                                                               (line   6)
* mysql_stmt_prepare()                  mysql_stmt_prepare.  (line   6)
* mysql_stmt_reset()                    mysql_stmt_reset.    (line   6)
* mysql_stmt_result_metadata.           mysql_stmt_result_metadata.
                                                               (line   6)
* mysql_stmt_row_seek()                 mysql_stmt_row_seek. (line   6)
* mysql_stmt_row_tell()                 mysql_stmt_row_tell. (line   6)
* mysql_stmt_send_long_data().          mysql_stmt_send_long_data.
                                                               (line   6)
* mysql_stmt_sqlstate()                 mysql_stmt_sqlstate. (line   6)
* mysql_stmt_store_result()             mysql_stmt_store_result.
                                                               (line   6)
* mysql_store_result() <1>              C API problems.      (line   6)
* mysql_store_result()                  mysql_store_result.  (line   6)
* MYSQL_TCP_PORT environment variable <1> Environment variables.
                                                               (line  18)
* MYSQL_TCP_PORT environment variable <2> Client-Side Overview.
                                                               (line  75)
* MYSQL_TCP_PORT environment variable <3> Multiple-server clients.
                                                               (line  27)
* MYSQL_TCP_PORT environment variable   Multiple Unix servers.
                                                               (line  56)
* mysql_thread_end()                    mysql_thread_end.    (line   6)
* mysql_thread_id()                     mysql_thread_id.     (line   6)
* mysql_thread_init()                   mysql_thread_init.   (line   6)
* mysql_thread_safe()                   mysql_thread_safe.   (line   6)
* MYSQL_UNIX_PORT environment variable <1> Environment variables.
                                                               (line  18)
* MYSQL_UNIX_PORT environment variable <2> Client-Side Overview.
                                                               (line  75)
* MYSQL_UNIX_PORT environment variable <3> Multiple-server clients.
                                                               (line  27)
* MYSQL_UNIX_PORT environment variable <4> Multiple Unix servers.
                                                               (line  56)
* MYSQL_UNIX_PORT environment variable  mysql_install_db.    (line  67)
* mysql_use_result()                    mysql_use_result.    (line   6)
* mysql_warning_count().                mysql_warning_count. (line   6)
* NATIONAL CHAR                         String type overview.
                                                               (line  50)
* NATURAL LEFT JOIN                     JOIN.                (line   6)
* NATURAL LEFT OUTER JOIN               JOIN.                (line   6)
* NATURAL RIGHT JOIN                    JOIN.                (line   6)
* NATURAL RIGHT OUTER JOIN              JOIN.                (line   6)
* NCHAR                                 String type overview.
                                                               (line  50)
* newline (\n)                          String syntax.       (line  36)
* NOT BETWEEN                           Comparison Operators.
                                                               (line 194)
* not equal (!=)                        Comparison Operators.
                                                               (line  97)
* not equal (<>)                        Comparison Operators.
                                                               (line  97)
* NOT IN                                Comparison Operators.
                                                               (line 246)
* NOT LIKE                              String comparison functions.
                                                               (line  91)
* NOT REGEXP                            String comparison functions.
                                                               (line  94)
* NOT, logical                          Logical Operators.   (line  11)
* NOW()                                 Date and time functions.
                                                               (line 541)
* NUL                                   String syntax.       (line  32)
* NULL <1>                              Problems with NULL.  (line   6)
* NULL                                  Working with NULL.   (line   6)
* NULL value                            NULL values.         (line   6)
* NULLIF()                              Control flow functions.
                                                               (line 103)
* NUMERIC                               Numeric type overview.
                                                               (line 146)
* NumGeometries()                       Geometrycollection property functions.
                                                               (line  18)
* NumInteriorRings()                    Polygon property functions.
                                                               (line  42)
* NumPoints()                           Linestring property functions.
                                                               (line  47)
* OCT()                                 String functions.    (line 340)
* OCTET_LENGTH()                        String functions.    (line 348)
* OLAP                                  GROUP-BY-Modifiers.  (line   6)
* OLD_PASSWORD()                        Encryption functions.
                                                               (line 171)
* OPEN                                  OPEN.                (line   6)
* operators, logical                    Logical Operators.   (line   6)
* OPTIMIZE TABLE                        OPTIMIZE TABLE.      (line   6)
* OR <1>                                Index Merge optimization.
                                                               (line   6)
* OR                                    Searching on two keys.
                                                               (line   6)
* OR, bitwise                           Bit functions.       (line   9)
* OR, logical                           Logical Operators.   (line  54)
* ORD()                                 String functions.    (line 351)
* ORDER BY <1>                          ALTER TABLE.         (line 173)
* ORDER BY <2>                          SELECT.              (line 124)
* ORDER BY                              Sorting rows.        (line   6)
* OUTFILE                               SELECT.              (line 238)
* Overlaps()                            Functions that test spatial relationships between geometries.
                                                               (line  55)
* parentheses ( and )                   Parentheses.         (line   6)
* PASSWORD() <1>                        Ignoring user.       (line  28)
* PASSWORD() <2>                        Encryption functions.
                                                               (line 177)
* PASSWORD() <3>                        Passwords.           (line   6)
* PASSWORD()                            Connection access.   (line  87)
* PATH environment variable <1>         Environment variables.
                                                               (line  18)
* PATH environment variable             Installing binary.   (line 121)
* PERIOD_ADD()                          Date and time functions.
                                                               (line 551)
* PERIOD_DIFF()                         Date and time functions.
                                                               (line 559)
* PI()                                  Mathematical functions.
                                                               (line 204)
* POINT                                 MySQL spatial datatypes.
                                                               (line   6)
* Point()                               GIS MySQL-Specific Functions.
                                                               (line  41)
* PointFromText()                       GIS WKT Functions.   (line  44)
* PointFromWKB()                        GIS WKB Functions.   (line  45)
* PointN()                              Linestring property functions.
                                                               (line  58)
* PointOnSurface()                      Multipolygon property functions.
                                                               (line  28)
* PolyFromText()                        GIS WKT Functions.   (line  47)
* PolyFromWKB()                         GIS WKB Functions.   (line  48)
* POLYGON                               MySQL spatial datatypes.
                                                               (line   6)
* Polygon()                             GIS MySQL-Specific Functions.
                                                               (line  44)
* PolygonFromText()                     GIS WKT Functions.   (line  47)
* PolygonFromWKB()                      GIS WKB Functions.   (line  48)
* POSITION()                            String functions.    (line 366)
* POW()                                 Mathematical functions.
                                                               (line 214)
* POWER()                               Mathematical functions.
                                                               (line 214)
* PREPARE                               SQLPS.               (line   6)
* PRIMARY KEY <1>                       CREATE TABLE.        (line 296)
* PRIMARY KEY                           ALTER TABLE.         (line 169)
* PROCEDURE                             SELECT.              (line 305)
* PROCESSLIST                           SHOW PROCESSLIST.    (line   6)
* PURGE MASTER LOGS                     PURGE MASTER LOGS.   (line   6)
* QUARTER()                             Date and time functions.
                                                               (line 567)
* QUOTE()                               String functions.    (line 369)
* quoting of identifiers                Legal names.         (line  42)
* RADIANS()                             Mathematical functions.
                                                               (line 223)
* RAND()                                Mathematical functions.
                                                               (line 229)
* REAL                                  Numeric type overview.
                                                               (line 122)
* ref_or_null                           IS NULL optimization.
                                                               (line   6)
* REGEXP                                String comparison functions.
                                                               (line  98)
* Related()                             Functions that test spatial relationships between geometries.
                                                               (line  61)
* RELEASE_LOCK()                        Miscellaneous functions.
                                                               (line 124)
* RENAME TABLE                          RENAME TABLE.        (line   6)
* RENAME USER                           RENAME USER.         (line   6)
* REPAIR TABLE                          REPAIR TABLE.        (line   6)
* REPEAT                                REPEAT Statement.    (line   6)
* REPEAT()                              String functions.    (line 383)
* REPLACE                               REPLACE.             (line   6)
* REPLACE ... SELECT                    INSERT.              (line 248)
* REPLACE()                             String functions.    (line 391)
* REQUIRE GRANT option <1>              GRANT.               (line 353)
* REQUIRE GRANT option                  Secure GRANT.        (line   6)
* RESET MASTER                          RESET MASTER.        (line   6)
* RESET SLAVE                           RESET SLAVE.         (line   6)
* RESTORE TABLE                         RESTORE TABLE.       (line   6)
* return (\r)                           String syntax.       (line  37)
* REVERSE()                             String functions.    (line 400)
* REVOKE                                GRANT.               (line   6)
* RIGHT JOIN                            JOIN.                (line   6)
* RIGHT OUTER JOIN                      JOIN.                (line   6)
* RIGHT()                               String functions.    (line 408)
* RLIKE                                 String comparison functions.
                                                               (line  98)
* ROLLBACK <1>                          COMMIT.              (line   6)
* ROLLBACK                              ANSI diff Transactions.
                                                               (line   6)
* ROLLBACK TO SAVEPOINT                 Savepoints.          (line   6)
* ROLLUP                                GROUP-BY-Modifiers.  (line   6)
* ROUND()                               Mathematical functions.
                                                               (line 266)
* ROUTINES, INFORMATION_SCHEMA table    ROUTINES Table.      (line   6)
* ROW_COUNT()                           Information functions.
                                                               (line 237)
* RPAD()                                String functions.    (line 416)
* RTRIM()                               String functions.    (line 428)
* SAVEPOINT                             Savepoints.          (line   6)
* SCHEMA_PRIVILEGES, INFORMATION_SCHEMA table SCHEMA_PRIVILEGES Table.
                                                               (line   6)
* SCHEMATA, INFORMATION_SCHEMA table    SCHEMATA Table.      (line   6)
* SEC_TO_TIME()                         Date and time functions.
                                                               (line 579)
* SECOND()                              Date and time functions.
                                                               (line 573)
* SELECT INTO                           SELECT INTO Statement.
                                                               (line   6)
* SELECT INTO TABLE                     ANSI diff SELECT INTO TABLE.
                                                               (line   6)
* SELECT speed                          SELECT speed.        (line   6)
* SELECT, LIMIT                         SELECT.              (line   6)
* SELECT, optimizing                    EXPLAIN.             (line   6)
* SESSION_USER()                        Information functions.
                                                               (line 268)
* SET <1>                               SET Statement.       (line   6)
* SET <2>                               SET OPTION.          (line   6)
* SET <3>                               SET.                 (line   6)
* SET                                   String type overview.
                                                               (line 167)
* SET GLOBAL SQL_SLAVE_SKIP_COUNTER     SET GLOBAL SQL_SLAVE_SKIP_COUNTER.
                                                               (line   6)
* SET OPTION                            SET OPTION.          (line   6)
* SET PASSWORD                          SET PASSWORD.        (line   6)
* SET PASSWORD statement                Passwords.           (line   6)
* SET SQL_LOG_BIN                       SET SQL_LOG_BIN.     (line   6)
* SET TRANSACTION                       SET TRANSACTION.     (line   6)
* SHA()                                 Encryption functions.
                                                               (line 197)
* SHA1()                                Encryption functions.
                                                               (line 197)
* SHOW BINARY LOGS                      SHOW MASTER LOGS.    (line   6)
* SHOW BINLOG EVENTS <1>                SHOW BINLOG EVENTS.  (line   6)
* SHOW BINLOG EVENTS                    SHOW.                (line  38)
* SHOW CHARACTER SET                    SHOW CHARACTER SET.  (line   6)
* SHOW COLLATION                        SHOW COLLATION.      (line   6)
* SHOW COLUMNS <1>                      SHOW COLUMNS.        (line   6)
* SHOW COLUMNS                          SHOW.                (line   6)
* SHOW CREATE DATABASE <1>              SHOW CREATE DATABASE.
                                                               (line   6)
* SHOW CREATE DATABASE                  SHOW.                (line   6)
* SHOW CREATE FUNCTION                  SHOW CREATE PROCEDURE.
                                                               (line   6)
* SHOW CREATE PROCEDURE                 SHOW CREATE PROCEDURE.
                                                               (line   6)
* SHOW CREATE SCHEMA <1>                SHOW CREATE DATABASE.
                                                               (line   6)
* SHOW CREATE SCHEMA                    SHOW.                (line   6)
* SHOW CREATE TABLE <1>                 SHOW CREATE TABLE.   (line   6)
* SHOW CREATE TABLE                     SHOW.                (line   6)
* SHOW CREATE VIEW                      SHOW CREATE VIEW.    (line   6)
* SHOW DATABASES <1>                    SHOW DATABASES.      (line   6)
* SHOW DATABASES                        SHOW.                (line   6)
* SHOW ENGINES <1>                      SHOW ENGINES.        (line   6)
* SHOW ENGINES                          SHOW.                (line   6)
* SHOW ERRORS <1>                       SHOW ERRORS.         (line   6)
* SHOW ERRORS                           SHOW.                (line   6)
* SHOW extensions                       Extended SHOW.       (line   6)
* SHOW FIELDS                           SHOW.                (line   6)
* SHOW FUNCTION STATUS                  SHOW PROCEDURE STATUS.
                                                               (line   6)
* SHOW GRANTS <1>                       SHOW GRANTS.         (line   6)
* SHOW GRANTS                           SHOW.                (line   6)
* SHOW INDEX <1>                        SHOW INDEX.          (line   6)
* SHOW INDEX                            SHOW.                (line   6)
* SHOW INNODB STATUS                    SHOW.                (line   6)
* SHOW KEYS <1>                         SHOW INDEX.          (line   6)
* SHOW KEYS                             SHOW.                (line   6)
* SHOW MASTER LOGS <1>                  SHOW MASTER LOGS.    (line   6)
* SHOW MASTER LOGS                      SHOW.                (line  38)
* SHOW MASTER STATUS <1>                SHOW MASTER STATUS.  (line   6)
* SHOW MASTER STATUS                    SHOW.                (line  38)
* SHOW PRIVILEGES <1>                   SHOW PRIVILEGES.     (line   6)
* SHOW PRIVILEGES                       SHOW.                (line   6)
* SHOW PROCEDURE STATUS                 SHOW PROCEDURE STATUS.
                                                               (line   6)
* SHOW PROCESSLIST <1>                  SHOW PROCESSLIST.    (line   6)
* SHOW PROCESSLIST                      SHOW.                (line   6)
* SHOW SCHEMAS <1>                      SHOW DATABASES.      (line   6)
* SHOW SCHEMAS                          SHOW.                (line   6)
* SHOW SLAVE HOSTS <1>                  SHOW SLAVE HOSTS.    (line   6)
* SHOW SLAVE HOSTS                      SHOW.                (line  38)
* SHOW SLAVE STATUS <1>                 SHOW SLAVE STATUS.   (line   6)
* SHOW SLAVE STATUS                     SHOW.                (line  38)
* SHOW STATUS                           SHOW.                (line   6)
* SHOW STORAGE ENGINES                  SHOW ENGINES.        (line   6)
* SHOW TABLE STATUS                     SHOW.                (line   6)
* SHOW TABLE TYPES <1>                  SHOW ENGINES.        (line   6)
* SHOW TABLE TYPES                      SHOW.                (line   6)
* SHOW TABLES <1>                       SHOW TABLES.         (line   6)
* SHOW TABLES                           SHOW.                (line   6)
* SHOW VARIABLES                        SHOW.                (line   6)
* SHOW WARNINGS <1>                     SHOW WARNINGS.       (line   6)
* SHOW WARNINGS                         SHOW.                (line   6)
* SHOW with WHERE <1>                   Extended SHOW.       (line   6)
* SHOW with WHERE                       INFORMATION_SCHEMA.  (line   6)
* SIGN()                                Mathematical functions.
                                                               (line 292)
* SIN()                                 Mathematical functions.
                                                               (line 303)
* single quote (\')                     String syntax.       (line  33)
* SMALLINT                              Numeric type overview.
                                                               (line  35)
* SOUNDEX()                             String functions.    (line 436)
* SOUNDS LIKE                           String functions.    (line 456)
* SPACE()                               String functions.    (line 460)
* SQL_BIG_RESULT                        SELECT.              (line 344)
* SQL_BUFFER_RESULT                     SELECT.              (line 350)
* SQL_CACHE <1>                         SELECT.              (line 371)
* SQL_CACHE                             Query Cache in SELECT.
                                                               (line   9)
* SQL_CALC_FOUND_ROWS                   SELECT.              (line 361)
* SQL_NO_CACHE <1>                      SELECT.              (line 377)
* SQL_NO_CACHE                          Query Cache in SELECT.
                                                               (line   9)
* SQL_SMALL_RESULT                      SELECT.              (line 355)
* SQRT()                                Mathematical functions.
                                                               (line 309)
* SRID()                                General geometry property functions.
                                                               (line  48)
* START SLAVE                           START SLAVE.         (line   6)
* START TRANSACTION                     COMMIT.              (line   6)
* StartPoint()                          Linestring property functions.
                                                               (line  70)
* statements, GRANT                     Adding users.        (line   6)
* statements, INSERT                    Adding users.        (line  84)
* STATISTICS, INFORMATION_SCHEMA table  STATISTICS Table.    (line   6)
* STD()                                 GROUP-BY-Functions.  (line 142)
* STDDEV()                              GROUP-BY-Functions.  (line 142)
* STOP SLAVE                            STOP SLAVE.          (line   6)
* STR_TO_DATE()                         Date and time functions.
                                                               (line 589)
* STRAIGHT_JOIN <1>                     JOIN.                (line   6)
* STRAIGHT_JOIN                         SELECT.              (line 338)
* STRCMP()                              String comparison functions.
                                                               (line 132)
* string comparison functions           String comparison functions.
                                                               (line   6)
* string functions                      String functions.    (line   6)
* SUBDATE()                             Date and time functions.
                                                               (line 625)
* SUBSTRING()                           String functions.    (line 466)
* SUBSTRING_INDEX()                     String functions.    (line 485)
* SUBTIME()                             Date and time functions.
                                                               (line 643)
* subtraction (-)                       Arithmetic functions.
                                                               (line  18)
* SUM()                                 GROUP-BY-Functions.  (line 148)
* SymDifference()                       Spatial operators.   (line  28)
* SYSDATE()                             Date and time functions.
                                                               (line 656)
* SYSTEM_USER()                         Information functions.
                                                               (line 271)
* tab (\t)                              String syntax.       (line  38)
* table_cache                           Table cache.         (line   6)
* TABLE_PRIVILEGES, INFORMATION_SCHEMA table TABLE_PRIVILEGES Table.
                                                               (line   6)
* TABLES, INFORMATION_SCHEMA table      TABLES Table.        (line   6)
* TAN()                                 Mathematical functions.
                                                               (line 317)
* TEXT <1>                              BLOB.                (line   6)
* TEXT                                  String type overview.
                                                               (line 141)
* threads                               SHOW PROCESSLIST.    (line   6)
* TIME <1>                              TIME.                (line   6)
* TIME                                  Date and time type overview.
                                                               (line  52)
* TIME()                                Date and time functions.
                                                               (line 659)
* TIME_FORMAT()                         Date and time functions.
                                                               (line 729)
* TIME_TO_SEC()                         Date and time functions.
                                                               (line 743)
* TIMEDIFF()                            Date and time functions.
                                                               (line 669)
* TIMESTAMP <1>                         DATETIME.            (line   6)
* TIMESTAMP                             Date and time type overview.
                                                               (line  22)
* TIMESTAMP()                           Date and time functions.
                                                               (line 683)
* TIMESTAMPADD()                        Date and time functions.
                                                               (line 697)
* TIMESTAMPDIFF()                       Date and time functions.
                                                               (line 715)
* TINYBLOB                              String type overview.
                                                               (line 136)
* TINYINT                               Numeric type overview.
                                                               (line  21)
* TINYTEXT                              String type overview.
                                                               (line 136)
* TMPDIR environment variable <1>       Environment variables.
                                                               (line  18)
* TMPDIR environment variable           mysql_install_db.    (line  67)
* TO_DAYS()                             Date and time functions.
                                                               (line 751)
* Touches()                             Functions that test spatial relationships between geometries.
                                                               (line  67)
* trace DBI method                      Using gdb on mysqld. (line  86)
* TRIM()                                String functions.    (line 499)
* TRUE                                  Number syntax.       (line   6)
* TRUNCATE                              TRUNCATE.            (line   6)
* TRUNCATE()                            Mathematical functions.
                                                               (line 323)
* Types                                 Column types.        (line  45)
* TZ environment variable <1>           Environment variables.
                                                               (line  18)
* TZ environment variable               Timezone problems.   (line   6)
* UCASE()                               String functions.    (line 517)
* UDF functions                         CREATE FUNCTION.     (line   6)
* ulimit                                Not enough file handles.
                                                               (line  30)
* UMASK environment variable <1>        Environment variables.
                                                               (line  18)
* UMASK environment variable            File permissions.    (line   6)
* UMASK_DIR environment variable <1>    Environment variables.
                                                               (line  18)
* UMASK_DIR environment variable        File permissions.    (line  19)
* unary minus (-)                       Arithmetic functions.
                                                               (line  24)
* UNCOMPRESS()                          String functions.    (line 520)
* UNCOMPRESSED_LENGTH()                 String functions.    (line 534)
* UNHEX()                               String functions.    (line 542)
* UNION <1>                             UNION.               (line   6)
* UNION                                 Searching on two keys.
                                                               (line   6)
* Union()                               Spatial operators.   (line  32)
* UNIQUE                                ALTER TABLE.         (line 169)
* UNIX_TIMESTAMP()                      Date and time functions.
                                                               (line 775)
* UNLOCK TABLES                         LOCK TABLES.         (line   6)
* UNTIL                                 REPEAT Statement.    (line   6)
* UPDATE                                UPDATE.              (line   6)
* UPPER()                               String functions.    (line 559)
* USE                                   USE.                 (line   6)
* USE INDEX <1>                         JOIN.                (line  95)
* USE INDEX                             SELECT.              (line  75)
* USE KEY <1>                           JOIN.                (line 109)
* USE KEY                               SELECT.              (line  75)
* USER environment variable <1>         Environment variables.
                                                               (line  18)
* USER environment variable             Connecting.          (line  67)
* USER()                                Information functions.
                                                               (line 274)
* User-defined functions                CREATE FUNCTION.     (line   6)
* USER_PRIVILEGES, INFORMATION_SCHEMA table USER_PRIVILEGES Table.
                                                               (line   6)
* UTC_DATE()                            Date and time functions.
                                                               (line 801)
* UTC_TIME()                            Date and time functions.
                                                               (line 812)
* UTC_TIMESTAMP()                       Date and time functions.
                                                               (line 823)
* UUID()                                Miscellaneous functions.
                                                               (line 135)
* VARBINARY                             String type overview.
                                                               (line 130)
* VARCHAR <1>                           String types.        (line   6)
* VARCHAR                               String type overview.
                                                               (line  95)
* VARCHARACTER                          String type overview.
                                                               (line  95)
* VARIANCE()                            GROUP-BY-Functions.  (line 152)
* VERSION()                             Information functions.
                                                               (line 299)
* VIEWS, INFORMATION_SCHEMA table       VIEWS Table.         (line   6)
* WEEK()                                Date and time functions.
                                                               (line 834)
* WEEKDAY()                             Date and time functions.
                                                               (line 902)
* WEEKOFYEAR()                          Date and time functions.
                                                               (line 911)
* WHERE                                 Where optimizations. (line   6)
* WHERE, with SHOW <1>                  Extended SHOW.       (line   6)
* WHERE, with SHOW                      INFORMATION_SCHEMA.  (line   6)
* WHILE                                 WHILE Statement.     (line   6)
* Wildcard character (%)                String syntax.       (line  44)
* Wildcard character (_)                String syntax.       (line  45)
* Within()                              Functions that test spatial relationships between geometries.
                                                               (line  74)
* without-server option                 configure options.   (line   6)
* X()                                   Point property functions.
                                                               (line   9)
* XOR, bitwise                          Bit functions.       (line  25)
* XOR, logical                          Logical Operators.   (line  73)
* Y()                                   Point property functions.
                                                               (line  19)
* YEAR <1>                              YEAR.                (line   6)
* YEAR                                  Date and time type overview.
                                                               (line  57)
* YEAR()                                Date and time functions.
                                                               (line 921)
* YEARWEEK()                            Date and time functions.
                                                               (line 927)
* | (bitwise OR)                        Bit functions.       (line   9)
* || (logical OR)                       Logical Operators.   (line  54)
* ~                                     Bit functions.       (line  55)
 
Info Catalog (mysql.info.gz) MySQL FLOSS License Exception (mysql.info.gz) Top (mysql.info.gz) Concept Index
automatically generated byinfo2html