Installing a MySQL Binary Distribution
======================================

* Menu:

* Linux-RPM::                   Linux RPM files
* Building clients::            Building client programs

You need the following tools to install a MySQL binary distribution:

   * GNU `gunzip' to uncompress the distribution.

   * A reasonable `tar' to unpack the distribution. GNU `tar' is known
     to work.  Sun `tar' is known to have problems.

An alternative installation method under Linux is to use RPM (RedHat
Package Manager) distributions.  *Note Linux-RPM::.

If you run into problems, *PLEASE ALWAYS USE* `mysqlbug' when posting
questions to <mysql@lists.mysql.com>.  Even if the problem isn't a bug,
`mysqlbug' gathers system information that will help others solve your
problem.  By not using `mysqlbug', you lessen the likelihood of getting
a solution to your problem!  You will find `mysqlbug' in the `bin'
directory after you unpack the distribution.  *Note Bug reports::.

The basic commands you must execute to install and use a MySQL binary
distribution are:

     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
     shell> ln -s mysql-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db
     shell> chown -R root  /usr/local/mysql
     shell> chown -R mysql /usr/local/mysql/data
     shell> chgrp -R mysql /usr/local/mysql
     shell> chown -R root /usr/local/mysql/bin
     shell> bin/safe_mysqld --user=mysql &

You can add new users using the `bin/mysql_setpermission' script if you
install the `DBI' and `Msql-Mysql-modules' Perl modules.

A more detailed description follows.

To install a binary distribution, follow the steps below, then proceed
to *Note Post-installation::, for post-installation setup and testing:

  1. Pick the directory under which you want to unpack the
     distribution, and move into it.  In the example below, we unpack
     the distribution under `/usr/local' and create a directory
     `/usr/local/mysql' into which MySQL is installed.  (The following
     instructions therefore assume you have permission to create files
     in `/usr/local'.  If that directory is protected, you will need to
     perform the installation as `root'.)

  2. Obtain a distribution file from one of the sites listed in *Note
     Getting MySQL: Getting MySQL.

     MySQL binary distributions are provided as compressed `tar'
     archives and have names like `mysql-VERSION-OS.tar.gz', where
     `VERSION' is a number (for example, `3.21.15'), and `OS' indicates
     the type of operating system for which the distribution is intended
     (for example, `pc-linux-gnu-i586').

  3. If you see a binary distribution marked with the `-max' prefix,
     this means that the binary has support for transaction-safe tables
     and other features. *Note `mysqld-max': mysqld-max.  Note that all
     binaries are built from the same MySQL source distribution.

  4. Add a user and group for `mysqld' to run as:

          shell> groupadd mysql
          shell> useradd -g mysql mysql

     These commands add the `mysql' group and the `mysql' user.  The
     syntax for `useradd' and `groupadd' may differ slightly on
     different versions of Unix.  They may also be called `adduser' and
     `addgroup'.  You may wish to call the user and group something
     else instead of `mysql'.

  5. Change into the intended installation directory:

          shell> cd /usr/local

  6. Unpack the distribution and create the installation directory:

          shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
          shell> ln -s mysql-VERSION-OS mysql

     The first command creates a directory named `mysql-VERSION-OS'.
     The second command makes a symbolic link to that directory.  This
     lets you refer more easily to the installation directory as
     `/usr/local/mysql'.

  7. Change into the installation directory:

          shell> cd mysql

     You will find several files and subdirectories in the `mysql'
     directory.  The most important for installation purposes are the
     `bin' and `scripts' subdirectories.

    `bin'
          This directory contains client programs and the server You
          should add the full pathname of this directory to your `PATH'
          environment variable so that your shell finds the MySQL
          programs properly. *Note Environment variables::.

    `scripts'
          This directory contains the `mysql_install_db' script used to
          initialize the `mysql' database containing the grant tables
          that store the server access permissions.

  8. If you would like to use `mysqlaccess' and have the MySQL
     distribution in some non-standard place, you must change the
     location where `mysqlaccess' expects to find the `mysql' client.
     Edit the `bin/mysqlaccess' script at approximately line 18.
     Search for a line that looks like this:

          $MYSQL     = '/usr/local/bin/mysql';    # path to mysql executable

     Change the path to reflect the location where `mysql' actually is
     stored on your system.  If you do not do this, you will get a
     `Broken pipe' error when you run `mysqlaccess'.

  9. Create the MySQL grant tables (necessary only if you haven't
     installed MySQL before):
          shell> scripts/mysql_install_db

     Note that MySQL versions older than Version 3.22.10 started the
     MySQL server when you run `mysql_install_db'.  This is no longer
     true!

 10. Change ownership of binaries to `root' and ownership of the data
     directory to the user that you will run `mysqld' as:

          shell> chown -R root  /usr/local/mysql
          shell> chown -R mysql /usr/local/mysql/data
          shell> chgrp -R mysql /usr/local/mysql

     The first command changes the `owner' attribute of the files to the
     `root' user, the second one changes the `owner' attribute of the
     data directory to the `mysql' user, and the third one changes the
     `group' attribute to the `mysql' group.

 11. If you want to install support for the Perl `DBI'/`DBD' interface,
     see *Note Perl support::.

 12. If you would like MySQL to start automatically when you boot your
     machine, you can copy `support-files/mysql.server' to the location
     where your system has its startup files.  More information can be
     found in the `support-files/mysql.server' script itself and in
     *Note Automatic start::.


After everything has been unpacked and installed, you should initialize
and test your distribution.

You can start the MySQL server with the following command:

     shell> bin/safe_mysqld --user=mysql &

*Note `safe_mysqld': safe_mysqld.

*Note Post-installation::.


Perl Installation Comments
==========================

* Menu:

* Perl installation::           Installing Perl on Unix
* ActiveState Perl::            Installing ActiveState Perl on Windows
* Windows Perl::                Installing the MySQL Perl distribution on Windows
* Perl support problems::       Problems using the Perl `DBI'/`DBD' interface


Installing Perl on Unix
-----------------------

Perl support for MySQL is provided by means of the `DBI'/`DBD' client
interface.  *Note Perl::.  The Perl `DBD'/`DBI' client code requires
Perl Version 5.004 or later.  The interface *will not work* if you have
an older version of Perl.

MySQL Perl support also requires that you've installed MySQL client
programming support.  If you installed MySQL from RPM files, client
programs are in the client RPM, but client programming support is in
the developer RPM.  Make sure you've installed the latter RPM.

As of Version 3.22.8, Perl support is distributed separately from the
main MySQL distribution.  If you want to install Perl support, the files
you will need can be obtained from
`http://www.mysql.com/Downloads/Contrib/'.

The Perl distributions are provided as compressed `tar' archives and
have names like `MODULE-VERSION.tar.gz', where `MODULE' is the module
name and `VERSION' is the version number.  You should get the
`Data-Dumper', `DBI', and `Msql-Mysql-modules' distributions and
install them in that order.  The installation procedure is shown below.
The example shown is for the `Data-Dumper' module, but the procedure is
the same for all three distributions:

  1. Unpack the distribution into the current directory:
          shell> gunzip < Data-Dumper-VERSION.tar.gz | tar xvf -
     This command creates a directory named `Data-Dumper-VERSION'.

  2. Change into the top-level directory of the unpacked distribution:
          shell> cd Data-Dumper-VERSION

  3. Build the distribution and compile everything:
          shell> perl Makefile.PL
          shell> make
          shell> make test
          shell> make install

The `make test' command is important because it verifies that the
module is working.  Note that when you run that command during the
`Msql-Mysql-modules' installation to exercise the interface code, the
MySQL server must be running or the test will fail.

It is a good idea to rebuild and reinstall the `Msql-Mysql-modules'
distribution whenever you install a new release of MySQL, particularly
if you notice symptoms such as all your `DBI' scripts dumping core
after you upgrade MySQL.

If you don't have the right to install Perl modules in the system
directory or if you to install local Perl modules, the following
reference may help you:

     `http://www.iserver.com/support/contrib/perl5/modules.html'

Look under the heading `Installing New Modules that Require Locally
Installed Modules'.


Installing ActiveState Perl on Windows
--------------------------------------

To install the MySQL `DBD' module with ActiveState Perl on Windows, you
should do the following:

   * Get ActiveState Perl from
     `http://www.activestate.com/Products/ActivePerl/index.html' and
     install it.

   * Open a DOS shell.

   * If required, set the HTTP_proxy variable. For example, you might
     try:

          set HTTP_proxy=my.proxy.com:3128

   * Start the PPM program:

          C:\> c:\perl\bin\ppm.pl

   * If you have not already done so, install `DBI':

          ppm> install DBI

   * If this succeeds, run the following command:

          install ftp://ftp.de.uu.net/pub/CPAN/authors/id/JWIED/DBD-mysql-1.2212.x86.ppd

The above should work at least with ActiveState Perl Version 5.6.

If you can't get the above to work, you should instead install the
*MyODBC* driver and connect to MySQL server through ODBC:

     use DBI;
     $dbh= DBI->connect("DBI:ODBC:$dsn","$user","$password") ||
       die "Got error $DBI::errstr when connecting to $dsn\n";


Installing the MySQL Perl Distribution on Windows
-------------------------------------------------

The MySQL Perl distribution contains `DBI', `DBD:MySQL' and `DBD:ODBC'.

   * Get the Perl distribution for Windows from
     `http://www.mysql.com/download.html'.

   * Unzip the distribution in `C:' so that you get a `C:\PERL'
     directory.

   * Add the directory `C:\PERL\BIN' to your path.

   * Add the directory `C:\PERL\BIN\MSWIN32-x86-thread' or
     `C:\PERL\BIN\MSWIN32-x86' to your path.

   * Test that `perl' works by executing `perl -v' in a DOS shell.


Problems Using the Perl `DBI'/`DBD' Interface
---------------------------------------------

If Perl reports that it can't find the `../mysql/mysql.so' module, then
the problem is probably that Perl can't locate the shared library
`libmysqlclient.so'.

You can fix this by any of the following methods:

   * Compile the `Msql-Mysql-modules' distribution with `perl
     Makefile.PL -static -config' rather than `perl Makefile.PL'.

   * Copy `libmysqlclient.so' to the directory where your other shared
     libraries are located (probably `/usr/lib' or `/lib').

   * On Linux you can add the pathname of the directory where
     `libmysqlclient.so' is located to the `/etc/ld.so.conf' file.

   * Add the pathname of the directory where `libmysqlclient.so' is
     located to the `LD_RUN_PATH' environment variable.

If you get the following errors from `DBD-mysql', you are probably
using `gcc' (or using an old binary compiled with `gcc'):

     /usr/bin/perl: can't resolve symbol '__moddi3'
     /usr/bin/perl: can't resolve symbol '__divdi3'

Add `-L/usr/lib/gcc-lib/... -lgcc' to the link command when the
`mysql.so' library gets built (check the output from `make' for
`mysql.so' when you compile the Perl client).  The `-L' option should
specify the pathname of the directory where `libgcc.a' is located on
your system.

Another cause of this problem may be that Perl and MySQL aren't both
compiled with `gcc'.  In this case, you can solve the mismatch by
compiling both with `gcc'.

If you get the following error from `Msql-Mysql-modules' when you run
the tests:

     t/00base............install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i586-linux/DynaLoader.pm line 169.

it means that you need to include the compression library, -lz, to the
link line. This can be doing the following change in the file
`lib/DBD/mysql/Install.pm':

     $sysliblist .= " -lm";
     
     to
     
     $sysliblist .= " -lm -lz";

After this, you MUST run 'make realclean' and then proceed with the
installation from the beginning.

If you want to use the Perl module on a system that doesn't support
dynamic linking (like SCO) you can generate a static version of Perl
that includes `DBI' and `DBD-mysql'.  The way this works is that you
generate a version of Perl with the `DBI' code linked in and install it
on top of your current Perl.  Then you use that to build a version of
Perl that additionally has the `DBD' code linked in, and install that.

On SCO, you must have the following environment variables set:

     shell> LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:/usr/progressive/lib
     or
     shell> LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib
     shell> LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib
     shell> MANPATH=scohelp:/usr/man:/usr/local1/man:/usr/local/man:/usr/skunk/man:

First, create a Perl that includes a statically linked `DBI' by running
these commands in the directory where your `DBI' distribution is
located:

     shell> perl Makefile.PL -static -config
     shell> make
     shell> make install
     shell> make perl

Then you must install the new Perl. The output of `make perl' will
indicate the exact `make' command you will need to execute to perform
the installation.  On SCO, this is `make -f Makefile.aperl inst_perl
MAP_TARGET=perl'.

Next, use the just-created Perl to create another Perl that also
includes a statically-linked `DBD::mysql' by running these commands in
the directory where your `Msql-Mysql-modules' distribution is located:

     shell> perl Makefile.PL -static -config
     shell> make
     shell> make install
     shell> make perl

Finally, you should install this new Perl.  Again, the output of `make
perl' indicates the command to use.


Functions for Use with `GROUP BY' Clauses
=========================================

If you use a group function in a statement containing no `GROUP BY'
clause, it is equivalent to grouping on all rows.

`COUNT(expr)'
     Returns a count of the number of non-`NULL' values in the rows
     retrieved by a `SELECT' statement:

          mysql> select student.student_name,COUNT(*)
                     from student,course
                     where student.student_id=course.student_id
                     GROUP BY student_name;

     `COUNT(*)' is somewhat different in that it returns a count of the
     number of rows retrieved, whether or not they contain `NULL'
     values.

     `COUNT(*)' is optimized to return very quickly if the `SELECT'
     retrieves from one table, no other columns are retrieved, and
     there is no `WHERE' clause.  For example:

          mysql> select COUNT(*) from student;

`COUNT(DISTINCT expr,[expr...])'
     Returns a count of the number of different non-`NULL' values:

          mysql> select COUNT(DISTINCT results) from student;

     In MySQL you can get the number of distinct expression
     combinations that don't contain NULL by giving a list of
     expressions.  In ANSI SQL you would have to do a concatenation of
     all expressions inside `CODE(DISTINCT ..)'.

`AVG(expr)'
     Returns the average value of `expr':

          mysql> select student_name, AVG(test_score)
                     from student
                     GROUP BY student_name;

`MIN(expr)'
`MAX(expr)'
     Returns the minimum or maximum value of `expr'.  `MIN()' and
     `MAX()' may take a string argument; in such cases they return the
     minimum or maximum string value. *Note MySQL indexes::.

          mysql> select student_name, MIN(test_score), MAX(test_score)
                     from student
                     GROUP BY student_name;

`SUM(expr)'
     Returns the sum of `expr'.  Note that if the return set has no
     rows, it returns NULL!

`STD(expr)'
`STDDEV(expr)'
     Returns the standard deviation of `expr'. This is an extension to
     ANSI SQL. The `STDDEV()' form of this function is provided for
     Oracle compatibility.

`BIT_OR(expr)'
     Returns the bitwise `OR' of all bits in `expr'. The calculation is
     performed with 64-bit (`BIGINT') precision.

`BIT_AND(expr)'
     Returns the bitwise `AND' of all bits in `expr'. The calculation is
     performed with 64-bit (`BIGINT') precision.

MySQL has extended the use of `GROUP BY'. You can use columns or
calculations in the `SELECT' expressions that don't appear in the
`GROUP BY' part. This stands for _any possible value for this group_.
You can use this to get better performance by avoiding sorting and
grouping on unnecessary items.  For example, you don't need to group on
`customer.name' in the following query:

     mysql> select order.custid,customer.name,max(payments)
            from order,customer
            where order.custid = customer.custid
            GROUP BY order.custid;

In ANSI SQL, you would have to add `customer.name' to the `GROUP BY'
clause.  In MySQL, the name is redundant if you don't run in ANSI mode.

*Don't use this feature* if the columns you omit from the `GROUP BY'
part aren't unique in the group!  You will get unpredictable results.

In some cases, you can use `MIN()' and `MAX()' to obtain a specific
column value even if it isn't unique. The following gives the value of
`column' from the row containing the smallest value in the `sort'
column:

     substr(MIN(concat(rpad(sort,6,' '),column)),7)

*Note example-Maximum-column-group-row::.

Note that if you are using MySQL Version 3.22 (or earlier) or if you
are trying to follow ANSI SQL, you can't use expressions in `GROUP BY'
or `ORDER BY' clauses.  You can work around this limitation by using an
alias for the expression:

     mysql> SELECT id,FLOOR(value/100) AS val FROM tbl_name
                GROUP BY id,val ORDER BY val;

In MySQL Version 3.23 you can do:

     mysql> SELECT id,FLOOR(value/100) FROM tbl_name ORDER BY RAND();


SQL command, type and function index
************************************

* Menu:

* ! (logical NOT):                       Logical Operators.
* != (not equal):                        Comparison Operators.
* ":                                     Legal names.
* % (modulo):                            Mathematical functions.
* % (wild card character):               String syntax.
* & (bitwise AND):                       Bit functions.
* && (logical AND):                      Logical Operators.
* () (parentheses):                      Parenthesis.
* (Control-Z) \z:                        String syntax.
* * (multiplication):                    Arithmetic functions.
* + (addition):                          Arithmetic functions.
* - (subtraction):                       Arithmetic functions.
* - (unary minus):                       Mathematical functions.
* -p option:                             Password security.
* -password option:                      Password security.
* .my.cnf file <1>:                      Password security.
* .my.cnf file <2>:                      Access denied.
* .my.cnf file <3>:                      Connecting.
* .my.cnf file <4>:                      Multiple servers.
* .my.cnf file <5>:                      Option files.
* .my.cnf file:                          Windows vs Unix.
* .mysql_history file <1>:               Client-Side Overview.
* .mysql_history file:                   Server-Side Overview.
* .pid (process ID) file:                Maintenance regimen.
* / (division):                          Arithmetic functions.
* /etc/passwd <1>:                       SELECT.
* /etc/passwd:                           Security.
* < (less than):                         Comparison Operators.
* <<:                                    Calculating days.
* << (left shift):                       Bit functions.
* <= (less than or equal):               Comparison Operators.
* <=> (Equal to):                        Comparison Operators.
* <> (not equal):                        Comparison Operators.
* = (equal):                             Comparison Operators.
* > (greater than):                      Comparison Operators.
* >= (greater than or equal):            Comparison Operators.
* >> (right shift):                      Bit functions.
* \" (double quote):                     String syntax.
* \' (single quote):                     String syntax.
* \0 (ASCII 0):                          String syntax.
* \\ (escape):                           String syntax.
* \b (backspace):                        String syntax.
* \n (newline):                          String syntax.
* \r (carriage return):                  String syntax.
* \t (tab):                              String syntax.
* \z (Control-Z) ASCII(26):              String syntax.
* _ (wild card character):               String syntax.
* `:                                     Legal names.
* ABS():                                 Mathematical functions.
* ACOS():                                Mathematical functions.
* ADDDATE():                             Date and time functions.
* addition (+):                          Arithmetic functions.
* alias:                                 Problems with alias.
* ALTER COLUMN:                          ALTER TABLE.
* ALTER TABLE <1>:                       ALTER TABLE problems.
* ALTER TABLE:                           ALTER TABLE.
* ANALYZE TABLE:                         ANALYZE TABLE.
* AND, bitwise:                          Bit functions.
* AND, logical:                          Logical Operators.
* arithmetic functions:                  Bit functions.
* ASCII():                               String functions.
* ASIN():                                Mathematical functions.
* ATAN():                                Mathematical functions.
* ATAN2():                               Mathematical functions.
* AUTO_INCREMENT, using with DBI:        Perl DBI Class.
* AVG():                                 Group by functions.
* backspace (\b):                        String syntax.
* BACKUP TABLE:                          BACKUP TABLE.
* BEGIN:                                 COMMIT.
* BENCHMARK():                           Miscellaneous functions.
* BETWEEN ... AND:                       Comparison Operators.
* BIGINT:                                Column types.
* BIN():                                 String functions.
* BINARY:                                Case Sensitivity Operators.
* bit functions:                         Bit functions.
* BIT_AND():                             Group by functions.
* BIT_COUNT:                             Calculating days.
* BIT_COUNT():                           Bit functions.
* BIT_OR:                                Calculating days.
* BIT_OR():                              Group by functions.
* BLOB <1>:                              BLOB.
* BLOB:                                  Column types.
* carriage return (\r):                  String syntax.
* CASE:                                  Control flow functions.
* casts:                                 Case Sensitivity Operators.
* CC environment variable <1>:           Environment variables.
* CC environment variable <2>:           Compilation problems.
* CC environment variable:               configure options.
* CCX environment variable:              Environment variables.
* CEILING():                             Mathematical functions.
* CFLAGS environment variable <1>:       Environment variables.
* CFLAGS environment variable:           Compilation problems.
* CHAR <1>:                              String types.
* CHAR:                                  Column types.
* CHAR VARYING:                          Column types.
* CHAR():                                String functions.
* CHAR_LENGTH():                         String functions.
* CHARACTER:                             Column types.
* CHARACTER VARYING:                     Column types.
* CHARACTER_LENGTH():                    String functions.
* CHECK TABLE:                           CHECK TABLE.
* ChopBlanks DBI method:                 Perl DBI Class.
* COALESCE():                            Comparison Operators.
* command-line options:                  Command-line options.
* Comment syntax:                        Comments.
* COMMIT <1>:                            COMMIT.
* COMMIT:                                Commit-rollback.
* comparison operators:                  Comparison Operators.
* CONCAT():                              String functions.
* CONCAT_WS():                           String functions.
* configure option, --with-charset:      configure options.
* configure option, --with-extra-charset: configure options.
* connect() DBI method:                  Perl DBI Class.
* CONNECTION_ID():                       Miscellaneous functions.
* control flow functions:                Control flow functions.
* CONV():                                String functions.
* COS():                                 Mathematical functions.
* COT():                                 Mathematical functions.
* COUNT():                               Group by functions.
* COUNT(DISTINCT):                       Group by functions.
* CREATE DATABASE:                       CREATE DATABASE.
* CREATE FUNCTION:                       CREATE FUNCTION.
* CREATE INDEX:                          CREATE INDEX.
* CREATE TABLE:                          CREATE TABLE.
* CROSS JOIN:                            JOIN.
* CURDATE():                             Date and time functions.
* CURRENT_DATE:                          Date and time functions.
* CURRENT_TIME:                          Date and time functions.
* CURRENT_TIMESTAMP:                     Date and time functions.
* CURTIME():                             Date and time functions.
* CXX environment variable <1>:          Compilation problems.
* CXX environment variable:              configure options.
* CXXFLAGS environment variable <1>:     Environment variables.
* CXXFLAGS environment variable <2>:     Compilation problems.
* CXXFLAGS environment variable:         configure options.
* data_sources() DBI method:             Perl DBI Class.
* DATABASE():                            Miscellaneous functions.
* DATE <1>:                              Using DATE.
* DATE <2>:                              DATETIME.
* DATE:                                  Column types.
* date and time functions:               Date and time functions.
* DATE_ADD():                            Date and time functions.
* DATE_FORMAT():                         Date and time functions.
* DATE_SUB():                            Date and time functions.
* DATETIME <1>:                          DATETIME.
* DATETIME:                              Column types.
* DAYNAME():                             Date and time functions.
* DAYOFMONTH():                          Date and time functions.
* DAYOFWEEK():                           Date and time functions.
* DAYOFYEAR():                           Date and time functions.
* DBI->connect():                        Perl DBI Class.
* DBI->data_sources():                   Perl DBI Class.
* DBI->disconnect:                       Perl DBI Class.
* DBI->do():                             Perl DBI Class.
* DBI->execute:                          Perl DBI Class.
* DBI->fetchall_arrayref:                Perl DBI Class.
* DBI->fetchrow_array:                   Perl DBI Class.
* DBI->fetchrow_arrayref:                Perl DBI Class.
* DBI->fetchrow_hashref:                 Perl DBI Class.
* DBI->finish:                           Perl DBI Class.
* DBI->prepare():                        Perl DBI Class.
* DBI->quote:                            String syntax.
* DBI->quote():                          Perl DBI Class.
* DBI->rows:                             Perl DBI Class.
* DBI->trace <1>:                        Using gdb on mysqld.
* DBI->trace:                            Perl DBI Class.
* DBI->{ChopBlanks}:                     Perl DBI Class.
* DBI->{insertid}:                       Perl DBI Class.
* DBI->{is_blob}:                        Perl DBI Class.
* DBI->{is_key}:                         Perl DBI Class.
* DBI->{is_not_null}:                    Perl DBI Class.
* DBI->{is_num}:                         Perl DBI Class.
* DBI->{is_pri_key}:                     Perl DBI Class.
* DBI->{length}:                         Perl DBI Class.
* DBI->{max_length}:                     Perl DBI Class.
* DBI->{NAME}:                           Perl DBI Class.
* DBI->{NULLABLE}:                       Perl DBI Class.
* DBI->{NUM_OF_FIELDS}:                  Perl DBI Class.
* DBI->{table}:                          Perl DBI Class.
* DBI->{type}:                           Perl DBI Class.
* DBI_TRACE environment variable <1>:    Environment variables.
* DBI_TRACE environment variable <2>:    Using gdb on mysqld.
* DBI_TRACE environment variable:        Perl DBI Class.
* DBI_USER environment variable:         Environment variables.
* DECIMAL:                               Column types.
* DECODE():                              Miscellaneous functions.
* DEGREES():                             Mathematical functions.
* DELAYED:                               INSERT DELAYED.
* DELETE:                                DELETE.
* DESC:                                  DESCRIBE.
* DESCRIBE <1>:                          DESCRIBE.
* DESCRIBE:                              Getting information.
* disconnect DBI method:                 Perl DBI Class.
* DISTINCT <1>:                          Group by functions.
* DISTINCT <2>:                          DISTINCT optimization.
* DISTINCT:                              Selecting columns.
* division (/):                          Arithmetic functions.
* do() DBI method:                       Perl DBI Class.
* DOUBLE:                                Column types.
* DOUBLE PRECISION:                      Column types.
* double quote (\"):                     String syntax.
* DROP DATABASE:                         DROP DATABASE.
* DROP FUNCTION:                         CREATE FUNCTION.
* DROP INDEX <1>:                        DROP INDEX.
* DROP INDEX:                            ALTER TABLE.
* DROP PRIMARY KEY:                      ALTER TABLE.
* DROP TABLE:                            DROP TABLE.
* DUMPFILE:                              SELECT.
* ELT():                                 String functions.
* ENCODE():                              Miscellaneous functions.
* ENCRYPT():                             Miscellaneous functions.
* ENUM <1>:                              ENUM.
* ENUM:                                  Column types.
* Environment variable, CC:              Environment variables.
* environment variable, CC <1>:          Compilation problems.
* environment variable, CC:              configure options.
* Environment variable, CCX:             Environment variables.
* Environment variable, CFLAGS:          Environment variables.
* environment variable, CFLAGS:          Compilation problems.
* environment variable, CXX:             Compilation problems.
* Environment variable, CXX:             Compilation problems.
* environment variable, CXX:             configure options.
* Environment variable, CXXFLAGS:        Environment variables.
* environment variable, CXXFLAGS <1>:    Compilation problems.
* environment variable, CXXFLAGS:        configure options.
* Environment variable, DBI_TRACE <1>:   Environment variables.
* Environment variable, DBI_TRACE:       Using gdb on mysqld.
* environment variable, DBI_TRACE:       Perl DBI Class.
* Environment variable, DBI_USER:        Environment variables.
* Environment variable, HOME:            Environment variables.
* environment variable, HOME <1>:        Client-Side Overview.
* environment variable, HOME:            Server-Side Overview.
* Environment variable, LD_RUN_PATH <1>: Perl support problems.
* Environment variable, LD_RUN_PATH <2>: Environment variables.
* Environment variable, LD_RUN_PATH:     Solaris.
* environment variable, LD_RUN_PATH:     Linux.
* Environment variable, MYSQL_DEBUG <1>: Environment variables.
* Environment variable, MYSQL_DEBUG:     Debugging client.
* environment variable, MYSQL_DEBUG <1>: Client-Side Overview.
* environment variable, MYSQL_DEBUG:     Server-Side Overview.
* Environment variable, MYSQL_HISTFILE:  Environment variables.
* environment variable, MYSQL_HISTFILE <1>: Client-Side Overview.
* environment variable, MYSQL_HISTFILE:  Server-Side Overview.
* Environment variable, MYSQL_HOST:      Environment variables.
* environment variable, MYSQL_HOST:      Connecting.
* Environment variable, MYSQL_PWD:       Environment variables.
* environment variable, MYSQL_PWD <1>:   Client-Side Overview.
* environment variable, MYSQL_PWD <2>:   Server-Side Overview.
* environment variable, MYSQL_PWD:       Connecting.
* Environment variable, MYSQL_TCP_PORT:  Environment variables.
* environment variable, MYSQL_TCP_PORT <1>: Client-Side Overview.
* environment variable, MYSQL_TCP_PORT <2>: Server-Side Overview.
* environment variable, MYSQL_TCP_PORT <3>: Multiple servers.
* environment variable, MYSQL_TCP_PORT:  Installing many servers.
* Environment variable, MYSQL_UNIX_PORT: Environment variables.
* environment variable, MYSQL_UNIX_PORT <1>: Client-Side Overview.
* environment variable, MYSQL_UNIX_PORT <2>: Server-Side Overview.
* environment variable, MYSQL_UNIX_PORT <3>: Multiple servers.
* environment variable, MYSQL_UNIX_PORT: Installing many servers.
* Environment variable, MYSQL_UNIX_PORT: mysql_install_db.
* environment variable, PATH:            Installing binary.
* Environment variable, PATH:            Environment variables.
* Environment variable, TMPDIR <1>:      Environment variables.
* Environment variable, TMPDIR:          mysql_install_db.
* Environment variable, TZ <1>:          Environment variables.
* Environment variable, TZ:              Timezone problems.
* Environment variable, UMASK <1>:       Environment variables.
* Environment variable, UMASK:           File permissions.
* Environment variable, UMASK_DIR <1>:   Environment variables.
* Environment variable, UMASK_DIR:       File permissions.
* Environment variable, USER:            Environment variables.
* environment variable, USER:            Connecting.
* Environment variables, CXX:            Compilation problems.
* equal (=):                             Comparison Operators.
* escape (\\):                           String syntax.
* execute DBI method:                    Perl DBI Class.
* EXP():                                 Mathematical functions.
* EXPLAIN:                               EXPLAIN.
* EXPORT_SET():                          String functions.
* EXTRACT():                             Date and time functions.
* fetchall_arrayref DBI method:          Perl DBI Class.
* fetchrow_array DBI method:             Perl DBI Class.
* fetchrow_arrayref DBI method:          Perl DBI Class.
* fetchrow_hashref DBI method:           Perl DBI Class.
* FIELD():                               String functions.
* FILE:                                  String functions.
* FIND_IN_SET():                         String functions.
* finish DBI method:                     Perl DBI Class.
* FLOAT:                                 Column types.
* FLOAT(M,D):                            Column types.
* FLOAT(precision):                      Column types.
* FLOOR():                               Mathematical functions.
* FLUSH:                                 FLUSH.
* FORMAT():                              Miscellaneous functions.
* FROM_DAYS():                           Date and time functions.
* FROM_UNIXTIME():                       Date and time functions.
* functions, arithmetic:                 Bit functions.
* functions, bit:                        Bit functions.
* functions, control flow:               Control flow functions.
* functions, date and time:              Date and time functions.
* functions, GROUP BY:                   Group by functions.
* Functions, logical:                    Logical Operators.
* functions, mathematical:               Mathematical functions.
* functions, miscellaneous:              Miscellaneous functions.
* functions, string:                     String functions.
* functions, string comparison:          String comparison functions.
* Functions, user-defined:               CREATE FUNCTION.
* GET_LOCK():                            Miscellaneous functions.
* GRANT:                                 GRANT.
* GRANT statement:                       Adding users.
* greater than (>):                      Comparison Operators.
* greater than or equal (>=):            Comparison Operators.
* GREATEST():                            Mathematical functions.
* GROUP BY functions:                    Group by functions.
* HEX():                                 String functions.
* hexadecimal values:                    Hexadecimal values.
* HOME environment variable <1>:         Environment variables.
* HOME environment variable <2>:         Client-Side Overview.
* HOME environment variable:             Server-Side Overview.
* host.frm, problems finding:            Post-installation.
* HOUR():                                Date and time functions.
* identifiers, quoting:                  Legal names.
* IF():                                  Control flow functions.
* IFNULL():                              Control flow functions.
* IN:                                    Comparison Operators.
* INET_ATON():                           Miscellaneous functions.
* INET_NTOA():                           Miscellaneous functions.
* INNER JOIN:                            JOIN.
* INSERT <1>:                            INSERT.
* INSERT:                                Insert speed.
* INSERT ... SELECT:                     INSERT.
* INSERT DELAYED:                        INSERT DELAYED.
* INSERT statement, grant privileges:    Adding users.
* INSERT():                              String functions.
* insertid DBI method:                   Perl DBI Class.
* INSTR():                               String functions.
* INT:                                   Column types.
* INTEGER:                               Column types.
* INTERVAL():                            Comparison Operators.
* IS NOT NULL:                           Comparison Operators.
* IS NULL:                               Comparison Operators.
* IS NULL, and indexes:                  MySQL indexes.
* is_blob DBI method:                    Perl DBI Class.
* is_key DBI method:                     Perl DBI Class.
* is_not_null DBI method:                Perl DBI Class.
* is_num DBI method:                     Perl DBI Class.
* is_pri_key DBI method:                 Perl DBI Class.
* ISNULL():                              Comparison Operators.
* ISOLATION LEVEL:                       SET TRANSACTION.
* JOIN:                                  JOIN.
* KILL:                                  KILL.
* LAST_INSERT_ID():                      Commit-rollback.
* LAST_INSERT_ID([expr]):                Miscellaneous functions.
* LCASE():                               String functions.
* LD_RUN_PATH environment variable <1>:  Perl support problems.
* LD_RUN_PATH environment variable <2>:  Environment variables.
* LD_RUN_PATH environment variable <3>:  Solaris.
* LD_RUN_PATH environment variable:      Linux.
* LEAST():                               Mathematical functions.
* LEFT JOIN <1>:                         JOIN.
* LEFT JOIN:                             LEFT JOIN optimization.
* LEFT OUTER JOIN:                       JOIN.
* LEFT():                                String functions.
* length DBI method:                     Perl DBI Class.
* LENGTH():                              String functions.
* less than (<):                         Comparison Operators.
* less than or equal (<=):               Comparison Operators.
* LIKE:                                  String comparison functions.
* LIKE, and indexes:                     MySQL indexes.
* LIKE, and wildcards:                   MySQL indexes.
* LIMIT:                                 LIMIT optimization.
* LOAD DATA INFILE <1>:                  Problems with NULL.
* LOAD DATA INFILE:                      LOAD DATA.
* LOAD_FILE():                           String functions.
* LOCATE():                              String functions.
* LOCK TABLES:                           LOCK TABLES.
* LOG():                                 Mathematical functions.
* LOG10():                               Mathematical functions.
* Logical functions:                     Logical Operators.
* LONGBLOB:                              Column types.
* LONGTEXT:                              Column types.
* LOWER():                               String functions.
* LPAD():                                String functions.
* LTRIM():                               String functions.
* MAKE_SET():                            String functions.
* MASTER_POS_WAIT():                     Miscellaneous functions.
* MATCH ... AGAINST():                   String comparison functions.
* mathematical functions:                Mathematical functions.
* MAX():                                 Group by functions.
* max_length DBI method:                 Perl DBI Class.
* MD5():                                 Miscellaneous functions.
* MEDIUMBLOB:                            Column types.
* MEDIUMINT:                             Column types.
* MEDIUMTEXT:                            Column types.
* MID():                                 String functions.
* MIN():                                 Group by functions.
* minus, unary (-):                      Mathematical functions.
* MINUTE():                              Date and time functions.
* miscellaneous functions:               Miscellaneous functions.
* MOD():                                 Mathematical functions.
* modulo (%):                            Mathematical functions.
* MONTH():                               Date and time functions.
* MONTHNAME():                           Date and time functions.
* multiplication (*):                    Arithmetic functions.
* my_init():                             my_init.
* my_thread_end():                       my_thread_end().
* my_thread_init():                      my_thread_init().
* my_ulonglong C type:                   C API datatypes.
* my_ulonglong values, printing:         C API datatypes.
* MYSQL C type:                          C API datatypes.
* mysql_affected_rows():                 mysql_affected_rows.
* mysql_change_user():                   mysql_change_user.
* mysql_character_set_name():            mysql_character_set_name.
* mysql_close():                         mysql_close.
* mysql_connect():                       mysql_connect.
* mysql_create_db():                     mysql_create_db.
* mysql_data_seek():                     mysql_data_seek.
* MYSQL_DEBUG environment variable <1>:  Environment variables.
* MYSQL_DEBUG environment variable <2>:  Debugging client.
* MYSQL_DEBUG environment variable <3>:  Client-Side Overview.
* MYSQL_DEBUG environment variable:      Server-Side Overview.
* mysql_debug():                         mysql_debug.
* mysql_drop_db():                       mysql_drop_db.
* mysql_dump_debug_info():               mysql_dump_debug_info.
* mysql_eof():                           mysql_eof.
* mysql_errno():                         mysql_errno.
* mysql_error():                         mysql_error.
* mysql_escape_string() <1>:             mysql_escape_string.
* mysql_escape_string():                 String syntax.
* mysql_fetch_field():                   mysql_fetch_field.
* mysql_fetch_field_direct():            mysql_fetch_field_direct.
* mysql_fetch_fields():                  mysql_fetch_fields.
* mysql_fetch_lengths():                 mysql_fetch_lengths.
* mysql_fetch_row():                     mysql_fetch_row.
* MYSQL_FIELD C type:                    C API datatypes.
* mysql_field_count() <1>:               mysql_num_fields.
* mysql_field_count():                   mysql_field_count.
* MYSQL_FIELD_OFFSET C type:             C API datatypes.
* mysql_field_seek():                    mysql_field_seek.
* mysql_field_tell():                    mysql_field_tell.
* mysql_free_result():                   mysql_free_result.
* mysql_get_client_info():               mysql_get_client_info.
* mysql_get_host_info():                 mysql_get_host_info.
* mysql_get_proto_info():                mysql_get_proto_info.
* mysql_get_server_info():               mysql_get_server_info.
* MYSQL_HISTFILE environment variable <1>: Environment variables.
* MYSQL_HISTFILE environment variable <2>: Client-Side Overview.
* MYSQL_HISTFILE environment variable:   Server-Side Overview.
* MYSQL_HOST environment variable <1>:   Environment variables.
* MYSQL_HOST environment variable:       Connecting.
* mysql_info() <1>:                      mysql_info.
* mysql_info() <2>:                      ALTER TABLE.
* mysql_info() <3>:                      LOAD DATA.
* mysql_info() <4>:                      UPDATE.
* mysql_info():                          INSERT.
* mysql_init():                          mysql_init.
* mysql_insert_id() <1>:                 mysql_insert_id.
* mysql_insert_id():                     Commit-rollback.
* mysql_kill():                          mysql_kill.
* mysql_list_dbs():                      mysql_list_dbs.
* mysql_list_fields():                   mysql_list_fields.
* mysql_list_processes():                mysql_list_processes.
* mysql_list_tables():                   mysql_list_tables.
* mysql_num_fields():                    mysql_num_fields.
* mysql_num_rows():                      mysql_num_rows.
* mysql_options():                       mysql_options.
* mysql_ping():                          mysql_ping.
* MYSQL_PWD environment variable <1>:    Environment variables.
* MYSQL_PWD environment variable <2>:    Client-Side Overview.
* MYSQL_PWD environment variable <3>:    Server-Side Overview.
* MYSQL_PWD environment variable:        Connecting.
* mysql_query() <1>:                     C API problems.
* mysql_query():                         mysql_query.
* mysql_real_connect():                  mysql_real_connect.
* mysql_real_escape_string():            mysql_real_escape_string.
* mysql_real_query():                    mysql_real_query.
* mysql_reload():                        mysql_reload.
* MYSQL_RES C type:                      C API datatypes.
* MYSQL_ROW C type:                      C API datatypes.
* mysql_row_seek():                      mysql_row_seek.
* mysql_row_tell():                      mysql_row_tell.
* mysql_select_db():                     mysql_select_db.
* mysql_shutdown():                      mysql_shutdown.
* mysql_stat():                          mysql_stat.
* mysql_store_result() <1>:              C API problems.
* mysql_store_result():                  mysql_store_result.
* MYSQL_TCP_PORT environment variable <1>: Environment variables.
* MYSQL_TCP_PORT environment variable <2>: Client-Side Overview.
* MYSQL_TCP_PORT environment variable <3>: Server-Side Overview.
* MYSQL_TCP_PORT environment variable <4>: Multiple servers.
* MYSQL_TCP_PORT environment variable:   Installing many servers.
* mysql_thread_id():                     mysql_thread_id.
* MYSQL_UNIX_PORT environment variable <1>: Environment variables.
* MYSQL_UNIX_PORT environment variable <2>: Client-Side Overview.
* MYSQL_UNIX_PORT environment variable <3>: Server-Side Overview.
* MYSQL_UNIX_PORT environment variable <4>: Multiple servers.
* MYSQL_UNIX_PORT environment variable <5>: Installing many servers.
* MYSQL_UNIX_PORT environment variable:  mysql_install_db.
* mysql_use_result():                    mysql_use_result.
* NAME DBI method:                       Perl DBI Class.
* NATIONAL CHAR:                         Column types.
* NATURAL LEFT JOIN:                     JOIN.
* NATURAL LEFT OUTER JOIN:               JOIN.
* NATURAL RIGHT JOIN:                    JOIN.
* NATURAL RIGHT OUTER JOIN:              JOIN.
* NCHAR:                                 Column types.
* newline (\n):                          String syntax.
* not equal (!=):                        Comparison Operators.
* not equal (<>):                        Comparison Operators.
* NOT IN:                                Comparison Operators.
* NOT LIKE:                              String comparison functions.
* NOT REGEXP:                            String comparison functions.
* NOT, logical:                          Logical Operators.
* NOW():                                 Date and time functions.
* NUL:                                   String syntax.
* NULL <1>:                              Problems with NULL.
* NULL:                                  Working with NULL.
* NULL value:                            NULL values.
* NULLABLE DBI method:                   Perl DBI Class.
* NULLIF():                              Control flow functions.
* NUM_OF_FIELDS DBI method:              Perl DBI Class.
* NUMERIC:                               Column types.
* OCT():                                 String functions.
* OCTET_LENGTH():                        String functions.
* OPTIMIZE TABLE:                        OPTIMIZE TABLE.
* OR, bitwise:                           Bit functions.
* OR, logical:                           Logical Operators.
* ORD():                                 String functions.
* ORDER BY:                              ALTER TABLE.
* parentheses ( and ):                   Parenthesis.
* PASSWORD() <1>:                        Ignoring user.
* PASSWORD() <2>:                        Miscellaneous functions.
* PASSWORD() <3>:                        Passwords.
* PASSWORD():                            Connection access.
* PATH environment variable <1>:         Installing binary.
* PATH environment variable:             Environment variables.
* PERIOD_ADD():                          Date and time functions.
* PERIOD_DIFF():                         Date and time functions.
* PI():                                  Mathematical functions.
* POSITION():                            String functions.
* POW():                                 Mathematical functions.
* POWER():                               Mathematical functions.
* prepare() DBI method:                  Perl DBI Class.
* PRIMARY KEY <1>:                       ALTER TABLE.
* PRIMARY KEY:                           CREATE TABLE.
* PROCESSLIST:                           SHOW PROCESSLIST.
* QUARTER():                             Date and time functions.
* quote() DBI method:                    Perl DBI Class.
* quoting of identifiers:                Legal names.
* RADIANS():                             Mathematical functions.
* RAND():                                Mathematical functions.
* REAL:                                  Column types.
* REGEXP:                                String comparison functions.
* RELEASE_LOCK():                        Miscellaneous functions.
* RENAME TABLE:                          RENAME TABLE.
* REPAIR TABLE:                          REPAIR TABLE.
* REPEAT():                              String functions.
* REPLACE:                               REPLACE.
* REPLACE ... SELECT:                    INSERT.
* REPLACE():                             String functions.
* RESTORE TABLE:                         RESTORE TABLE.
* return (\r):                           String syntax.
* REVERSE():                             String functions.
* REVOKE:                                GRANT.
* RIGHT JOIN:                            JOIN.
* RIGHT OUTER JOIN:                      JOIN.
* RIGHT():                               String functions.
* RLIKE:                                 String comparison functions.
* ROLLBACK <1>:                          COMMIT.
* ROLLBACK:                              Commit-rollback.
* ROUND():                               Mathematical functions.
* rows DBI method:                       Perl DBI Class.
* RPAD():                                String functions.
* RTRIM():                               String functions.
* SEC_TO_TIME():                         Date and time functions.
* SECOND():                              Date and time functions.
* SELECT:                                SELECT.
* SELECT INTO TABLE:                     Missing SELECT INTO TABLE.
* SELECT speed:                          SELECT speed.
* SELECT, optimizing:                    EXPLAIN.
* SESSION_USER():                        Miscellaneous functions.
* SET <1>:                               SET.
* SET:                                   Column types.
* SET OPTION:                            SET OPTION.
* SET PASSWORD statement:                Passwords.
* SHOW COLUMNS:                          SHOW.
* SHOW CREATE TABLE:                     SHOW.
* SHOW DATABASE INFO:                    SHOW.
* SHOW DATABASES:                        SHOW.
* SHOW FIELDS:                           SHOW.
* SHOW GRANTS:                           SHOW.
* SHOW INDEX:                            SHOW.
* SHOW KEYS:                             SHOW.
* SHOW MASTER LOGS:                      SHOW.
* SHOW MASTER STATUS:                    SHOW.
* SHOW PROCESSLIST:                      SHOW.
* SHOW SLAVE STATUS:                     SHOW.
* SHOW STATUS:                           SHOW.
* SHOW TABLE STATUS:                     SHOW.
* SHOW TABLES:                           SHOW.
* SHOW VARIABLES:                        SHOW.
* SIGN():                                Mathematical functions.
* SIN():                                 Mathematical functions.
* single quote (\'):                     String syntax.
* SMALLINT:                              Column types.
* SOUNDEX():                             String functions.
* SPACE():                               String functions.
* SQRT():                                Mathematical functions.
* statements, GRANT:                     Adding users.
* statements, INSERT:                    Adding users.
* STD():                                 Group by functions.
* STDDEV():                              Group by functions.
* STRAIGHT_JOIN:                         JOIN.
* STRCMP():                              String comparison functions.
* string comparison functions:           String comparison functions.
* string functions:                      String functions.
* SUBDATE():                             Date and time functions.
* SUBSTRING():                           String functions.
* SUBSTRING_INDEX():                     String functions.
* subtraction (-):                       Arithmetic functions.
* SUM():                                 Group by functions.
* SYSDATE():                             Date and time functions.
* SYSTEM_USER():                         Miscellaneous functions.
* tab (\t):                              String syntax.
* table DBI method:                      Perl DBI Class.
* table_cache:                           Table cache.
* TAN():                                 Mathematical functions.
* TEXT <1>:                              BLOB.
* TEXT:                                  Column types.
* threads:                               SHOW PROCESSLIST.
* TIME <1>:                              TIME.
* TIME:                                  Column types.
* TIME_FORMAT():                         Date and time functions.
* TIME_TO_SEC():                         Date and time functions.
* TIMESTAMP <1>:                         DATETIME.
* TIMESTAMP:                             Column types.
* TINYBLOB:                              Column types.
* TINYINT:                               Column types.
* TINYTEXT:                              Column types.
* TMPDIR environment variable <1>:       Environment variables.
* TMPDIR environment variable:           mysql_install_db.
* TO_DAYS():                             Date and time functions.
* trace DBI method <1>:                  Using gdb on mysqld.
* trace DBI method:                      Perl DBI Class.
* TRIM():                                String functions.
* TRUNCATE:                              TRUNCATE.
* TRUNCATE():                            Mathematical functions.
* type DBI method:                       Perl DBI Class.
* Types:                                 Column types.
* TZ environment variable <1>:           Environment variables.
* TZ environment variable:               Timezone problems.
* UCASE():                               String functions.
* UDF functions:                         CREATE FUNCTION.
* ulimit:                                Not enough file handles.
* UMASK environment variable <1>:        Environment variables.
* UMASK environment variable:            File permissions.
* UMASK_DIR environment variable <1>:    Environment variables.
* UMASK_DIR environment variable:        File permissions.
* unary minus (-):                       Mathematical functions.
* UNION:                                 Searching on two keys.
* UNIQUE:                                ALTER TABLE.
* UNIX_TIMESTAMP():                      Date and time functions.
* UNLOCK TABLES:                         LOCK TABLES.
* UPDATE:                                UPDATE.
* UPPER():                               String functions.
* USE:                                   USE.
* USER environment variable <1>:         Environment variables.
* USER environment variable:             Connecting.
* USER():                                Miscellaneous functions.
* User-defined functions:                CREATE FUNCTION.
* VARCHAR <1>:                           String types.
* VARCHAR:                               Column types.
* VERSION():                             Miscellaneous functions.
* WEEK():                                Date and time functions.
* WEEKDAY():                             Date and time functions.
* WHERE:                                 Where optimizations.
* Wild card character (%):               String syntax.
* Wild card character (_):               String syntax.
* without-server option:                 configure options.
* YEAR <1>:                              YEAR.
* YEAR:                                  Column types.
* YEAR():                                Date and time functions.
* | (bitwise OR):                        Bit functions.
* || (logical OR):                       Logical Operators.
* ~:                                     Bit functions.


Concept Index
*************

* Menu:

* aborted clients:                       Communication errors.
* aborted connection:                    Communication errors.
* access control:                        Connection access.
* access denied errors:                  Error Access denied.
* access privileges:                     Privilege system.
* Access program:                        MyODBC clients.
* ACLs:                                  Privilege system.
* ActiveState Perl:                      ActiveState Perl.
* adding, character sets:                Adding character set.
* adding, native functions:              Adding native function.
* adding, new functions:                 Adding functions.
* adding, new user privileges:           Adding users.
* adding, new users:                     Installing binary.
* adding, procedures:                    Adding procedures.
* adding, user-definable functions:      Adding UDF.
* administration, server:                mysqladmin.
* ADO program:                           MyODBC clients.
* advertising, contact information:      Contact information.
* age, calculating:                      Date calculations.
* alias names, case sensitivity:         Name case sensitivity.
* aliases, for expressions:              Group by functions.
* aliases, for tables:                   SELECT.
* aliases, in GROUP BY clauses:          Group by functions.
* aliases, in ORDER BY clauses:          Group by functions.
* aliases, names:                        Legal names.
* aliases, on expressions:               SELECT.
* anonymous user <1>:                    Default privileges.
* anonymous user <2>:                    Request access.
* anonymous user:                        Connection access.
* ANSI mode, running:                    ANSI mode.
* ANSI SQL, differences from:            GRANT.
* ANSI SQL92, extensions to:             Compatibility.
* answering questions, etiquette:        Answering questions.
* Apache:                                Apache.
* APIs:                                  Clients.
* APIs, Perl:                            Perl.
* applying, patches:                     Applying patches.
* argument processing:                   UDF arguments.
* arithmetic expressions:                Arithmetic functions.
* authentication tools:                  Contrib.
* AUTO-INCREMENT, ODBC:                  ODBC and last_insert_id.
* AUTO_INCREMENT, and NULL values:       Problems with NULL.
* backing up, databases <1>:             mysqlhotcopy.
* backing up, databases:                 mysqldump.
* backslash, escape character:           Literals.
* backups:                               Backup.
* backups, database:                     BACKUP TABLE.
* batch mode:                            Batch mode.
* batch, mysql option:                   mysql.
* BDB table type:                        Table types.
* BDB tables:                            Commit-rollback.
* benchmark suite:                       MySQL Benchmarks.
* benchmarking, tools:                   Contrib.
* benchmarks:                            Custom Benchmarks.
* Berkeley_db table type:                Table types.
* Big5 Chinese character encoding:       Case sensitivity.
* binary distributions:                  MySQL binaries.
* binary distributions, installing:      Installing binary.
* binary distributions, on HP-UX:        Binary notes-HP-UX.
* binary distributions, on Linux:        Binary notes-Linux.
* binary log:                            Binary log.
* Binlog_Dump:                           Replication FAQ.
* bit_functions, example:                Calculating days.
* BitKeeper tree:                        Installing source tree.
* BLOB columns, default values:          BLOB.
* BLOB columns, indexing:                CREATE TABLE.
* BLOB, inserting binary data:           String syntax.
* BLOB, size:                            Storage requirements.
* books, about MySQL:                    MySQL Information Sources.
* Borland Builder 4 program:             MyODBC clients.
* Borland C++ compiler:                  Borland C++.
* brackets, square:                      Column types.
* buffer sizes, client:                  Clients.
* buffer sizes, mysqld server:           Server parameters.
* bug reports, criteria for:             Bug reports.
* bug reports, email address:            Bug reports.
* bugs, known:                           Bugs.
* bugs, reporting:                       Bug reports.
* building, client programs:             Building clients.
* C API, datatypes:                      C.
* C API, functions:                      C API function overview.
* C API, linking problems:               C API linking problems.
* C++:                                   Contrib.
* C++ APIs:                              Cplusplus.
* C++ Builder:                           MyODBC clients.
* C++ compiler cannot create executables: Compilation problems.
* C++ compiler, gcc:                     configure options.
* caches, clearing:                      FLUSH.
* calculating, dates:                    Date calculations.
* calling sequences, UDF:                UDF calling sequences.
* can't create/write to file:            Cannot create.
* case sensitivity, in access checking:  Privileges.
* case sensitivity, in searches:         Case sensitivity.
* case sensitivity, in string comparisons: String comparison functions.
* case sensitivity, of database names:   Extensions to ANSI.
* case sensitivity, of table names:      Extensions to ANSI.
* case-sensitivity, in names:            Name case sensitivity.
* cast operators:                        Case Sensitivity Operators.
* casts:                                 Comparison Operators.
* cc1plus problems:                      Compilation problems.
* ChangeLog:                             News.
* changes to privileges:                 Request access.
* changes, log:                          News.
* changes, version 3.19:                 News-3.19.x.
* changes, version 3.20:                 News-3.20.x.
* changes, version 3.21:                 News-3.21.x.
* changes, version 3.22:                 News-3.22.x.
* changes, version 3.23:                 News-3.23.x.
* changes, version 4.0:                  News-4.0.0.
* changing socket location:              configure options.
* changing, column order:                Change column order.
* character sets <1>:                    Character sets.
* character sets:                        configure options.
* character sets, adding:                Adding character set.
* character-sets-dir, mysql option:      mysql.
* characters, multi-byte:                Multi-byte characters.
* check options, myisamchk:              myisamchk check options.
* checking, tables for errors:           Check.
* checksum errors:                       Solaris.
* Chinese:                               Case sensitivity.
* choosing types:                        Choosing types.
* choosing, a MySQL version:             Which version.
* clearing, caches:                      FLUSH.
* client programs, building:             Building clients.
* client tools:                          Clients.
* clients, debugging:                    Debugging client.
* clients, threaded:                     Threaded clients.
* closing, tables:                       Table cache.
* ColdFusion program:                    MyODBC clients.
* collating, strings:                    String collating.
* column names, case sensitivity:        Name case sensitivity.
* columns, changing:                     Change column order.
* columns, displaying:                   mysqlshow.
* columns, indexes:                      Indexes.
* columns, names:                        Legal names.
* columns, other types:                  Other-vendor column types.
* columns, selecting:                    Selecting columns.
* columns, storage requirements:         Storage requirements.
* columns, types:                        Column types.
* command line history <1>:              Client-Side Overview.
* command line history:                  Server-Side Overview.
* command line options, mysql:           mysql.
* command line tool:                     mysql.
* command syntax:                        Manual conventions.
* commands out of sync:                  Commands out of sync.
* commands, for binary distribution:     Installing binary.
* commands, list of:                     mysql.
* commands, replication:                 Replication SQL.
* comments, adding:                      Comments.
* comments, starting:                    Missing comments.
* commercial support, types:             Support.
* communications protocols:              Protocol differences.
* comparisons, MySQL vs. others:         Comparisons.
* compatibility, between MySQL versions <1>: Upgrading-from-3.21.
* compatibility, between MySQL versions: Upgrading-from-3.22.
* compatibility, with ANSI SQL:          Compatibility.
* compatibility, with mSQL:              String comparison functions.
* compatibility, with ODBC <1>:          News-3.21.15.
* compatibility, with ODBC <2>:          CREATE TABLE.
* compatibility, with ODBC <3>:          JOIN.
* compatibility, with ODBC <4>:          Comparison Operators.
* compatibility, with ODBC <5>:          Column types.
* compatibility, with ODBC:              Legal names.
* compatibility, with Oracle <1>:        Group by functions.
* compatibility, with Oracle <2>:        DESCRIBE.
* compatibility, with Oracle:            Extensions to ANSI.
* compatibility, with PostgreSQL:        Extensions to ANSI.
* compatibility, with Sybase:            USE.
* compiler, C++ gcc:                     configure options.
* compiling, on Windows:                 Windows compiling.
* compiling, optimizing:                 System.
* compiling, problems:                   Compilation problems.
* compiling, speed:                      Compile and link options.
* compiling, statically:                 configure options.
* compiling, user-defined functions:     UDF compiling.
* compliance, Y2K:                       Year 2000 compliance.
* compress, mysql option:                mysql.
* compressed tables:                     myisampack.
* config-file option:                    mysqld_multi.
* config.cache:                          Compilation problems.
* config.cache file:                     Compilation problems.
* configuration files:                   Access denied.
* configuration options:                 configure options.
* configure option, -with-low-memory:    Compilation problems.
* configure script:                      configure options.
* configure, running after prior invocation: Compilation problems.
* connect_timeout variable:              mysql.
* connecting, remotely with SSH:         Windows and SSH.
* connecting, to the server <1>:         Connecting.
* connecting, to the server:             Connecting-disconnecting.
* connecting, verification:              Connection access.
* connection, aborted:                   Communication errors.
* constant table <1>:                    Where optimizations.
* constant table:                        EXPLAIN.
* consultants, list of:                  Users.
* contact information:                   Contact information.
* Contrib directory:                     Useful Links.
* contributed programs:                  Contrib.
* contributing companies, list of:       Supporters.
* contributors, list of:                 Contributors.
* control access:                        Connection access.
* conventions, typographical:            Manual conventions.
* converters:                            Contrib.
* converting, tools:                     Using mSQL tools.
* copyrights:                            Copyright.
* costs, licensing and support:          Cost.
* counting, table rows:                  Counting rows.
* crackers, security against:            Security.
* crash:                                 Debugging server.
* crash, recovery:                       Crash recovery.
* crash, repeated:                       Crashing.
* crash-me:                              MySQL Benchmarks.
* crash-me program <1>:                  MySQL Benchmarks.
* crash-me program:                      Portability.
* creating, bug reports:                 Bug reports.
* creating, databases:                   Database use.
* creating, default startup options:     Option files.
* creating, tables:                      Creating tables.
* customer support, mailing address:     Bug reports.
* customers, of MySQL:                   Internal use.
* cvs tree:                              Installing source tree.
* data, character sets:                  Character sets.
* data, importing:                       mysqlimport.
* data, ISAM table handler:              Stability.
* data, loading into tables:             Loading tables.
* data, retrieving:                      Retrieving data.
* data, size:                            Data size.
* database design:                       Design.
* database names, case sensitivity <1>:  Name case sensitivity.
* database names, case sensitivity:      Extensions to ANSI.
* database, mysql option:                mysql.
* databases, backups:                    Backup.
* databases, creating:                   Database use.
* databases, defined:                    What-is.
* databases, displaying:                 mysqlshow.
* databases, dumping <1>:                mysqlhotcopy.
* databases, dumping:                    mysqldump.
* databases, information about:          Getting information.
* databases, MySQL vs. others:           Comparisons.
* databases, names:                      Legal names.
* databases, replicating:                Replication.
* databases, selecting:                  Creating database.
* databases, symbolic links <1>:         Symbolic links to tables.
* databases, symbolic links:             Symbolic links.
* databases, using:                      Database use.
* DataJunction:                          MyODBC clients.
* datatypes, C API:                      C.
* Date and Time types:                   Date and time types.
* date calculations:                     Date calculations.
* DATE columns, problems:                Using DATE.
* date functions, Y2K compliance:        Year 2000 compliance.
* date types:                            Storage requirements.
* date types, Y2K issues:                Y2K issues.
* date values, problems:                 DATETIME.
* db table, sorting:                     Request access.
* DBI interface:                         DBI with DBD.
* DBI Perl module:                       Perl DBI Class.
* DBI/DBD:                               DBI-info.
* dbServ:                                Useful Links.
* DBUG package:                          The DBUG package.
* debug, mysql option:                   mysql.
* debug-info, mysql option:              mysql.
* debugging, client:                     Debugging client.
* debugging, server:                     Debugging server.
* decimal point:                         Column types.
* default hostname:                      Connecting.
* default installation location:         Installation layouts.
* default options:                       Option files.
* default values, BLOB and TEXT columns: BLOB.
* default values, suppression:           configure options.
* default, privileges:                   Default privileges.
* default-character-set, mysql option:   mysql.
* delayed_insert_limit:                  INSERT DELAYED.
* deleting, rows:                        Deleting from related tables.
* deletion, mysql.sock:                  Problems with mysql.sock.
* Delphi:                                Contrib.
* Delphi program:                        MyODBC clients.
* design, choices:                       Design.
* design, issues:                        Bugs.
* design, limitations:                   Design Limitations.
* developers, list of:                   Credits.
* development source tree:               Installing source tree.
* digits:                                Column types.
* directory structure, default:          Installation layouts.
* disconnecting, from the server:        Connecting-disconnecting.
* disk full:                             Full disk.
* disk issues:                           Disk issues.
* disks, splitting data across:          Windows symbolic links.
* display size:                          Column types.
* displaying, database information:      mysqlshow.
* displaying, information, SHOW:         SHOW DATABASE INFO.
* displaying, table status:              SHOW TABLE STATUS.
* DNS:                                   DNS.
* downgrading:                           Upgrade.
* downloading:                           Getting MySQL.
* dumping, databases <1>:                mysqlhotcopy.
* dumping, databases:                    mysqldump.
* dynamic table characteristics:         Dynamic format.
* Eiffel Wrapper:                        Eiffel.
* email lists:                           Mailing-list.
* email, technical support:              Basic email support.
* employment with MySQL:                 Contact information.
* employment, contact information:       Contact information.
* enable-named-commands, mysql option:   mysql.
* entering, queries:                     Entering queries.
* ENUM, size:                            Storage requirements.
* environment variables <1>:             Client-Side Overview.
* environment variables <2>:             Server-Side Overview.
* environment variables <3>:             Access denied.
* environment variables:                 Option files.
* environment variables, list of:        Environment variables.
* error mesaages, can't find file:       File permissions.
* error messages, displaying:            perror.
* error messages, languages:             Languages.
* errors, access denied:                 Error Access denied.
* errors, checking tables for:           Check.
* errors, common:                        Problems.
* errors, directory checksum:            Solaris.
* errors, handling for UDFs:             UDF return values.
* errors, known:                         Bugs.
* errors, linking:                       Link errors.
* errors, list of:                       Common errors.
* errors, reporting <1>:                 Bug reports.
* errors, reporting:                     Introduction.
* escape characters:                     Literals.
* estimating, query performance:         Estimating performance.
* example option:                        mysqld_multi.
* examples, compressed tables:           myisampack.
* examples, myisamchk output:            Table-info.
* examples, queries:                     Examples.
* Excel:                                 MyODBC clients.
* execute, mysql option:                 mysql.
* expression aliases <1>:                Group by functions.
* expression aliases:                    SELECT.
* expressions, extended:                 Pattern matching.
* extended email support:                Extended email support.
* extensions, to ANSI SQL:               Compatibility.
* extracting, dates:                     Date calculations.
* fatal signal 11:                       Compilation problems.
* features of MySQL:                     Features.
* files, binary log:                     Binary log.
* files, config.cache:                   Compilation problems.
* files, error messages:                 Languages.
* files, log <1>:                        Log file maintenance.
* files, log:                            configure options.
* files, not found message:              File permissions.
* files, permissions:                    File permissions.
* files, query log:                      Query log.
* files, repairing:                      myisamchk repair options.
* files, script:                         Batch mode.
* files, size limits:                    Table size.
* files, slow query log:                 Slow query log.
* files, text:                           mysqlimport.
* files, tmp:                            mysql_install_db.
* files, update log:                     Update log.
* files,my.cnf:                          Replication Features.
* floating-point number:                 Column types.
* floats:                                Number syntax.
* flush tables:                          mysqladmin.
* force, mysql option:                   mysql.
* foreign keys <1>:                      ALTER TABLE.
* foreign keys <2>:                      example-Foreign keys.
* foreign keys:                          Missing Foreign Keys.
* foreign keys, reasons not to use:      Broken Foreign KEY.
* forums, Tek-Tips:                      Useful Links.
* free licensing:                        Copyright.
* FreeBSD troubleshooting:               Compilation problems.
* full disk:                             Full disk.
* full-text search:                      Fulltext Search.
* FULLTEXT:                              Fulltext Search.
* functionality, missing:                Missing functions.
* functions for SELECT and WHERE clauses: Functions.
* functions, C API:                      C API function overview.
* functions, grouping:                   Parenthesis.
* functions, native, adding:             Adding native function.
* functions, new:                        Adding functions.
* functions, useful:                     Contrib.
* functions, user-definable, adding:     Adding UDF.
* functions, user-defined:               Adding functions.
* gcc:                                   configure options.
* gdb, using:                            Using gdb on mysqld.
* general information:                   Introduction.
* General Public License:                What-is.
* General Public License, MySQL:         Licensing policy.
* getting MySQL:                         Getting MySQL.
* global privileges:                     GRANT.
* goals of MySQL:                        What-is.
* GPL, General Public License:           GPL license.
* GPL, GNU General Public License:       GPL license.
* grant tables:                          Request access.
* grant tables, re-creating:             Default privileges.
* grant tables, sorting <1>:             Request access.
* grant tables, sorting:                 Connection access.
* granting, privleges:                   GRANT.
* GROUP BY, aliases in:                  Group by functions.
* GROUP BY, extensions to ANSI SQL <1>:  Group by functions.
* GROUP BY, extensions to ANSI SQL:      SELECT.
* grouping, expressions:                 Parenthesis.
* handling, errors:                      UDF return values.
* HEAP table type:                       Table types.
* help option:                           mysqld_multi.
* help, mysql option:                    mysql.
* history file <1>:                      Client-Side Overview.
* history file:                          Server-Side Overview.
* history of MySQL:                      History.
* host table:                            Request access.
* host table, sorting:                   Request access.
* host, mysql option:                    mysql.
* hostname caching:                      DNS.
* hostname, default:                     Connecting.
* HP-UX, binary distribution:            Binary notes-HP-UX.
* html, mysql option:                    mysql.
* ID, unique:                            Getting unique ID.
* ignore-space, mysql option:            mysql.
* importing, data:                       mysqlimport.
* increasing, performance:               Replication FAQ.
* increasing, speed:                     Replication.
* indexes:                               CREATE INDEX.
* indexes, and BLOB columns:             CREATE TABLE.
* indexes, and IS NULL:                  MySQL indexes.
* indexes, and LIKE:                     MySQL indexes.
* indexes, and NULL values:              CREATE TABLE.
* indexes, and TEXT columns:             CREATE TABLE.
* indexes, block size:                   SHOW VARIABLES.
* indexes, columns:                      Indexes.
* indexes, leftmost prefix of:           MySQL indexes.
* indexes, multi-column:                 Multiple-column indexes.
* indexes, multi-part:                   CREATE INDEX.
* indexes, names:                        Legal names.
* indexes, use of:                       MySQL indexes.
* InnoDB table type:                     Table types.
* InnoDB tables:                         Commit-rollback.
* INSERT DELAYED:                        INSERT DELAYED.
* inserting, speed of:                   Insert speed.
* installation layouts:                  Installation layouts.
* installation overview:                 Installing source.
* Installing many servers:               Installing many servers.
* installing, binary distribution:       Installing binary.
* installing, overview:                  Installing.
* installing, Perl:                      Perl support.
* installing, Perl on Windows:           ActiveState Perl.
* installing, source distribution:       Installing source.
* installing, user-defined functions:    UDF compiling.
* integers:                              Number syntax.
* interface builder:                     Unireg.
* internal compiler errors:              Compilation problems.
* internal locking:                      Internal locking.
* internals:                             MySQL internals.
* Internet Service Providers:            ISP.
* ISAM table handler:                    Stability.
* ISAM table type:                       Table types.
* ISP services:                          ISP.
* Java connectivity:                     Java.
* JDBC <1>:                              Contrib.
* JDBC:                                  Java.
* jobs at MySQL:                         Contact information.
* key space, MyISAM:                     Key space.
* keys:                                  Indexes.
* keys, foreign <1>:                     example-Foreign keys.
* keys, foreign:                         Missing Foreign Keys.
* keys, multi-column:                    Multiple-column indexes.
* keys, searching on two:                Searching on two keys.
* keywords:                              Reserved words.
* known errors:                          Bugs.
* language support:                      Languages.
* last row, unique ID:                   Getting unique ID.
* layout of installation:                Installation layouts.
* leftmost prefix of indexes:            MySQL indexes.
* legal names:                           Legal names.
* LGPL, GNU Library General Public License: LGPL license.
* LGPL, Lesser General Public License:   LGPL license.
* library, mysqlclient:                  Clients.
* licensing costs:                       Cost.
* licensing policy:                      Licensing policy.
* licensing terms:                       Licensing and Support.
* licensing, contact information:        Contact information.
* licensing, examples:                   Licensing examples.
* licensing, free:                       Copyright.
* limitations, design:                   Design Limitations.
* limits, file size:                     Table size.
* linking:                               Building clients.
* linking, errors:                       Link errors.
* linking, problems:                     C API linking problems.
* linking, speed:                        Compile and link options.
* links, symbolic:                       Symbolic links.
* Linux, binary distribution:            Binary notes-Linux.
* literals:                              Literals.
* loading, tables:                       Loading tables.
* locking:                               System.
* locking methods:                       Locking methods.
* locking, tables:                       Internal locking.
* Log files:                             Log Files.
* log files:                             configure options.
* log files, maintaining:                Log file maintenance.
* log files, names:                      Backup.
* log option:                            mysqld_multi.
* log, changes:                          News.
* login support:                         Login support.
* magazines, online:                     Users.
* mailing address, for customer support: Bug reports.
* mailing list address:                  Introduction.
* mailing lists:                         Mailing-list.
* mailing lists, archive location:       Asking questions.
* mailing lists, guidelines:             Answering questions.
* main features of MySQL:                Features.
* maintaining, log files:                Log file maintenance.
* maintaining, tables:                   Maintenance regimen.
* make_binary_distribution <1>:          Client-Side Overview.
* make_binary_distribution:              Server-Side Overview.
* manual, available formats:             Manual-info.
* manual, online location:               Introduction.
* manual, typographical conventions:     Manual conventions.
* manuals, about MySQL:                  MySQL Information Sources.
* master-slave setup:                    Replication Implementation.
* matching, patterns:                    Pattern matching.
* max memory used:                       mysqladmin.
* max_allowed_packet:                    mysql.
* max_join_size:                         mysql.
* memory usage, myisamchk:               myisamchk memory.
* memory use <1>:                        Memory use.
* memory use:                            mysqladmin.
* MERGE table type:                      Table types.
* MERGE tables, defined:                 MERGE.
* messages, languages:                   Languages.
* methods, locking:                      Locking methods.
* mirror sites:                          Getting MySQL.
* missing functionality:                 Missing functions.
* MIT-pthreads:                          MIT-pthreads.
* modes, batch:                          Batch mode.
* modules, list of:                      Stability.
* monitor, terminal:                     Tutorial.
* mSQL compatibility:                    String comparison functions.
* mSQL vs. MySQL:                        Protocol differences.
* msql2mysql <1>:                        Client-Side Overview.
* msql2mysql:                            Server-Side Overview.
* multi mysqld:                          mysqld_multi.
* multi-byte characters:                 Multi-byte characters.
* multi-column indexes:                  Multiple-column indexes.
* multi-part index:                      CREATE INDEX.
* multibyte character sets:              Cannot initialize character set.
* multiple servers:                      Multiple servers.
* My, derivation:                        History.
* my.cnf file:                           Replication Features.
* MyISAM table type:                     Table types.
* MyISAM, compressed tables:             myisampack.
* myisamchk <1>:                         Client-Side Overview.
* myisamchk <2>:                         Server-Side Overview.
* myisamchk:                             configure options.
* myisamchk, example output:             Table-info.
* myisamchk, options:                    myisamchk general options.
* myisampack <1>:                        Silent column changes.
* myisampack:                            myisampack.
* MyODBC:                                ODBC.
* MyODBC, reporting problems:            MyODBC bug report.
* mysladmn:                              mysqladmin.
* mysql:                                 mysql.
* MySQL AB, defined:                     What is MySQL AB.
* MySQL binary distribution:             Which version.
* mysql command line options:            mysql.
* MySQL history:                         History.
* MySQL mailing lists:                   Questions.
* MySQL name:                            History.
* MySQL source distribution:             Which version.
* MySQL table types:                     Table types.
* MySQL tools, conversion:               Using mSQL tools.
* MySQL usage:                           MySQL customer usage.
* MySQL version:                         Getting MySQL.
* MySQL, defined:                        What-is.
* MySQL, introduction:                   What-is.
* MySQL, pronunciation:                  What-is.
* mysql.sock, changing location of:      configure options.
* mysql.sock, protection:                Problems with mysql.sock.
* mysql_fix_privilege_tables:            Access denied.
* mysql_install_db <1>:                  Client-Side Overview.
* mysql_install_db:                      Server-Side Overview.
* mysql_install_db script:               mysql_install_db.
* mysqlaccess <1>:                       Client-Side Overview.
* mysqlaccess:                           Server-Side Overview.
* mysqladmin <1>:                        DROP DATABASE.
* mysqladmin <2>:                        CREATE DATABASE.
* mysqladmin <3>:                        Client-Side Overview.
* mysqladmin <4>:                        Server-Side Overview.
* mysqladmin <5>:                        SHOW STATUS.
* mysqladmin <6>:                        KILL.
* mysqladmin:                            FLUSH.
* mysqladmin option:                     mysqld_multi.
* mysqlbug <1>:                          Client-Side Overview.
* mysqlbug:                              Server-Side Overview.
* mysqlbug script:                       Bug reports.
* mysqlbug script, location:             Introduction.
* mysqlclient library:                   Clients.
* mysqld <1>:                            Client-Side Overview.
* mysqld:                                Server-Side Overview.
* mysqld option:                         mysqld_multi.
* mysqld options <1>:                    Server parameters.
* mysqld options:                        Command-line options.
* mysqld server, buffer sizes:           Server parameters.
* mysqld, starting:                      Changing MySQL user.
* mysqld-max:                            mysqld-max.
* mysqld_multi:                          mysqld_multi.
* mysqldump <1>:                         mysqldump.
* mysqldump <2>:                         Client-Side Overview.
* mysqldump <3>:                         Server-Side Overview.
* mysqldump:                             Upgrading-to-arch.
* mysqlimport <1>:                       LOAD DATA.
* mysqlimport <2>:                       mysqlimport.
* mysqlimport <3>:                       Client-Side Overview.
* mysqlimport <4>:                       Server-Side Overview.
* mysqlimport:                           Upgrading-to-arch.
* mysqlshow <1>:                         Client-Side Overview.
* mysqlshow:                             Server-Side Overview.
* mysqltest, MySQL Test Suite:           MySQL test suite.
* named pipes:                           Windows running.
* names:                                 Legal names.
* names, case-sensitivity:               Name case sensitivity.
* names, variables:                      Variables.
* naming, releases of MySQL:             Which version.
* native functions, adding:              Adding native function.
* native thread support:                 Which OS.
* negative values:                       Number syntax.
* net etiquette <1>:                     Answering questions.
* net etiquette:                         Asking questions.
* net_buffer_length:                     mysql.
* netmask notation, in mysql.user table: Connection access.
* new procedures, adding:                Adding procedures.
* new users, adding:                     Installing binary.
* news sites:                            Users.
* no matching rows:                      No matching rows.
* no-auto-rehash, mysql option:          mysql.
* no-log option:                         mysqld_multi.
* no-named-commands, mysql option:       mysql.
* no-pager, mysql option:                mysql.
* no-tee, mysql option:                  mysql.
* non-delimited strings:                 DATETIME.
* Non-transactional tables:              Non-transactional tables.
* NULL value:                            Working with NULL.
* NULL values, and AUTO_INCREMENT columns: Problems with NULL.
* NULL values, and indexes:              CREATE TABLE.
* NULL values, and TIMESTAMP columns:    Problems with NULL.
* NULL values, vs. empty values:         Problems with NULL.
* NULL, testing for null <1>:            Control flow functions.
* NULL, testing for null:                Comparison Operators.
* numbers:                               Number syntax.
* numeric types:                         Storage requirements.
* ODBC:                                  ODBC.
* ODBC compatibility <1>:                News-3.21.15.
* ODBC compatibility <2>:                CREATE TABLE.
* ODBC compatibility <3>:                JOIN.
* ODBC compatibility <4>:                Comparison Operators.
* ODBC compatibility <5>:                Column types.
* ODBC compatibility:                    Legal names.
* ODBC, administrator:                   ODBC administrator.
* odbcadmin program:                     MyODBC clients.
* Old Photo Album:                       Useful Links.
* OLEDB:                                 Contrib.
* one-database, mysql option:            mysql.
* online location of manual:             Introduction.
* online magazines:                      Users.
* open source, defined:                  What-is.
* open tables <1>:                       Open tables.
* open tables:                           mysqladmin.
* opening, tables:                       Table cache.
* opens:                                 mysqladmin.
* operating systems, file size limits:   Table size.
* operating systems, supported:          Which OS.
* operating systems, Windows versus Unix: Windows vs Unix.
* operations, arithmetic:                Arithmetic functions.
* operators, cast:                       Case Sensitivity Operators.
* optimization, tips:                    Tips.
* optimizations:                         Where optimizations.
* optimizing, DISTINCT:                  DISTINCT optimization.
* optimizing, LEFT JOIN:                 LEFT JOIN optimization.
* optimizing, LIMIT:                     LIMIT optimization.
* optimizing, tables:                    Optimization.
* option files:                          Option files.
* options, command line, mysql:          mysql.
* options, command-line:                 Command-line options.
* options, configure:                    configure options.
* options, myisamchk:                    myisamchk general options.
* options, provided by MySQL:            Tutorial.
* options, replication:                  Replication Features.
* Oracle compatibility <1>:              Group by functions.
* Oracle compatibility <2>:              DESCRIBE.
* Oracle compatibility:                  Extensions to ANSI.
* ORDER BY, aliases in:                  Group by functions.
* overview:                              Introduction.
* pack_isam:                             myisampack.
* pager, mysql option:                   mysql.
* parameters, server:                    Server parameters.
* partnering with MySQL:                 Contact information.
* password encryption, reversibility of: Miscellaneous functions.
* password option:                       mysqld_multi.
* password, mysql option:                mysql.
* password, root user:                   Default privileges.
* passwords, for users:                  User names.
* passwords, forgotten:                  Resetting permissions.
* passwords, resetting:                  Resetting permissions.
* passwords, security:                   What Privileges.
* passwords, setting <1>:                SET OPTION.
* passwords, setting <2>:                Passwords.
* passwords, setting:                    GRANT.
* patches, applying:                     Applying patches.
* pattern matching:                      Pattern matching.
* payment information:                   Payment information.
* performance, benchmarks:               Custom Benchmarks.
* performance, disk issues:              Disk issues.
* performance, estimating:               Estimating performance.
* performance, improving <1>:            Data size.
* performance, improving:                Replication FAQ.
* Perl API:                              Perl.
* Perl DBI/DBD, installation problems:   Perl support problems.
* Perl, installing:                      Perl support.
* Perl, installing on Windows:           ActiveState Perl.
* Perl, modules:                         Contrib.
* permission checks, effect on speed:    Query Speed.
* perror:                                perror.
* PhoneSweep:                            Useful Links.
* PHP API:                               PHP.
* PHP, web sites:                        Users.
* Pluribus:                              Useful Links.
* port, mysql option:                    mysql.
* portability:                           Portability.
* portability, types:                    Other-vendor column types.
* porting, to other systems:             Porting.
* post-install, many servers:            Installing many servers.
* post-installation, setup and testing:  Post-installation.
* PostgreSQL compatibility:              Extensions to ANSI.
* PostgreSQL vs. MySQL, benchmarks:      MySQL-PostgreSQL benchmarks.
* PostgreSQL vs. MySQL, overview:        Compare PostgreSQL.
* PostgreSQL/MySQL, features:            MySQL-PostgreSQL features.
* PostgreSQL/MySQL, strategies:          Compare PostgreSQL.
* prices, licensing and support:         Cost.
* privilege information, location:       Privileges provided.
* privilege system:                      What Privileges.
* privilege system, described:           Privileges.
* privilege, changes:                    Request access.
* privileges, access:                    Privilege system.
* privileges, adding:                    Adding users.
* privileges, default:                   Default privileges.
* privileges, display:                   SHOW GRANTS.
* privileges, granting:                  GRANT.
* privileges, revoking:                  GRANT.
* problems, access denied errors:        Error Access denied.
* problems, common errors:               Problems.
* problems, compiling:                   Compilation problems.
* problems, DATE columns:                Using DATE.
* problems, date values:                 DATETIME.
* problems, installing on IBM-AIX:       IBM-AIX.
* problems, installing on Solaris:       Solaris.
* problems, installing Perl:             Perl support problems.
* problems, linking:                     Link errors.
* problems, ODBC:                        MyODBC bug report.
* problems, reporting:                   Bug reports.
* problems, starting the server:         Starting server.
* problems, table locking:               Table locking.
* problems, timezone:                    Timezone problems.
* procedures, adding:                    Adding procedures.
* procedures, stored:                    Missing Triggers.
* process support:                       Which OS.
* processes, display:                    SHOW PROCESSLIST.
* processing, arguments:                 UDF arguments.
* products, selling:                     Licensing examples.
* programs, client:                      Building clients.
* programs, contributed:                 Contrib.
* programs, crash-me:                    Portability.
* programs, list of <1>:                 Client-Side Overview.
* programs, list of:                     Server-Side Overview.
* prompts, meanings:                     Entering queries.
* pronunciation, MySQL:                  What-is.
* Protocol mismatch:                     Upgrading-from-3.20.
* pwPage:                                Useful Links.
* Python APIs:                           Python.
* queries, C API results:                NULL mysql_store_result.
* queries, entering:                     Entering queries.
* queries, estimating performance:       Estimating performance.
* queries, examples:                     Examples.
* queries, speed of:                     Query Speed.
* queries, Twin Studeis project:         Twin.
* query log:                             Query log.
* questions:                             mysqladmin.
* questions, answering:                  Answering questions.
* quick, mysql option:                   mysql.
* quotes, in strings:                    String syntax.
* quoting:                               String syntax.
* quoting binary data:                   String syntax.
* quoting strings:                       Perl DBI Class.
* raw, mysql option:                     mysql.
* re-creating, grant tables:             Default privileges.
* reconfiguring:                         Compilation problems.
* recovery, from crash:                  Crash recovery.
* RedHat Package Manager <1>:            Installing binary.
* RedHat Package Manager:                Linux-RPM.
* reducing, data size:                   Data size.
* references:                            ALTER TABLE.
* regex:                                 Regexp.
* regular expression syntax, described:  Regexp.
* related information URLs:              Useful Links.
* relational databases, defined:         What-is.
* release numbers:                       Which version.
* releases, naming scheme:               Which version.
* releases, testing:                     Which version.
* releases, updating:                    Many versions.
* reordering, columns:                   Change column order.
* repair options, myisamchk:             myisamchk repair options.
* repairing, tables:                     Repair.
* replace <1>:                           Client-Side Overview.
* replace:                               Server-Side Overview.
* replication:                           Replication.
* replication, commands:                 Replication SQL.
* replication, two-way:                  Replication FAQ.
* reporting, bugs:                       Bug reports.
* reporting, errors <1>:                 Questions.
* reporting, errors:                     Introduction.
* reporting, MyODBC problems:            MyODBC bug report.
* reserved words, exceptions:            Reserved words.
* restarting, the server:                Post-installation.
* retrieving, data:                      Stability.
* retrieving, data from tables:          Retrieving data.
* return values, UDFs:                   UDF return values.
* revoking, privleges:                   GRANT.
* root password:                         Default privileges.
* root user, password resetting:         Resetting permissions.
* rounding errors <1>:                   Mathematical functions.
* rounding errors:                       Column types.
* rows, counting:                        Counting rows.
* rows, deleting:                        Deleting from related tables.
* rows, locking:                         Commit-rollback.
* rows, matching problems:               No matching rows.
* rows, selecting:                       Selecting rows.
* rows, sorting:                         Sorting rows.
* RPM file:                              Linux-RPM.
* RPM, defined:                          Installing binary.
* RPMs, for common tools:                Contrib.
* RTS-threads:                           RTS-threads.
* running configure after prior invocation: Compilation problems.
* running, a web server:                 Web server.
* running, ANSI mode:                    ANSI mode.
* running, batch mode:                   Batch mode.
* running, multiple servers:             Multiple servers.
* running, queries:                      Entering queries.
* safe-mode command:                     mysql.
* safe-updates, mysql option:            mysql.
* safe_mysqld:                           safe_mysqld.
* SCMDB:                                 Useful Links.
* script files:                          Batch mode.
* scripts <1>:                           mysql.
* scripts <2>:                           mysqld_multi.
* scripts:                               safe_mysqld.
* scripts, mysql_install_db:             mysql_install_db.
* scripts, mysqlbug:                     Bug reports.
* search engines, web:                   Users.
* searching, and case-sensitivity:       Case sensitivity.
* searching, full-text:                  Fulltext Search.
* searching, MySQL webpages:             Asking questions.
* searching, two keys:                   Searching on two keys.
* security system:                       Privilege system.
* security, against crackers:            Security.
* select_limit:                          mysql.
* selecting, databases:                  Creating database.
* selling products:                      Licensing examples.
* sequence emulation:                    Miscellaneous functions.
* server administration:                 mysqladmin.
* server, connecting <1>:                Connecting.
* server, connecting:                    Connecting-disconnecting.
* server, debugging:                     Debugging server.
* server, disconnecting:                 Connecting-disconnecting.
* server, restart:                       Post-installation.
* server, shutdown:                      Post-installation.
* server, starting:                      Post-installation.
* server, starting and stopping:         Automatic start.
* server, starting problems:             Starting server.
* servers, multiple:                     Multiple servers.
* services:                              Users.
* services, ISP:                         ISP.
* services, web:                         ISP.
* SET, size:                             Storage requirements.
* set-variable, mysql option:            mysql.
* setting, passwords:                    Passwords.
* setup, post-installation:              Post-installation.
* shell syntax:                          Manual conventions.
* showing, database information:         mysqlshow.
* shutting down, the server:             Post-installation.
* silent column changes:                 Silent column changes.
* silent, mysql option:                  mysql.
* size of tables:                        Table size.
* sizes, display:                        Column types.
* skip-column-names, mysql option:       mysql.
* skip-line-numbers, mysql option:       mysql.
* slow queries:                          mysqladmin.
* slow query log:                        Slow query log.
* socket location, changing:             configure options.
* socket, mysql option:                  mysql.
* Solaris installation problems:         Solaris.
* Solaris troubleshooting:               Compilation problems.
* sorting, character sets:               Character sets.
* sorting, data:                         Sorting rows.
* sorting, grant tables <1>:             Request access.
* sorting, grant tables:                 Connection access.
* sorting, table rows:                   Sorting rows.
* source distribution, installing:       Installing source.
* speed, compiling:                      Compile and link options.
* speed, increasing:                     Replication.
* speed, inserting:                      Insert speed.
* speed, linking:                        Compile and link options.
* speed, of queries <1>:                 SELECT speed.
* speed, of queries:                     Query Speed.
* SQL commands, replication:             Replication SQL.
* SQL, defined:                          What-is.
* sql_yacc.cc problems:                  Compilation problems.
* square brackets:                       Column types.
* SSH:                                   Windows and SSH.
* stability:                             Stability.
* standards compatibility:               Compatibility.
* Starting many servers:                 Installing many servers.
* starting, comments:                    Missing comments.
* starting, mysqld:                      Changing MySQL user.
* starting, the server:                  Post-installation.
* starting, the server automatically:    Automatic start.
* startup options, default:              Option files.
* startup parameters:                    Server parameters.
* startup parameters, mysql:             mysql.
* startup parameters, tuning:            System.
* statically, compiling:                 configure options.
* status command:                        mysql.
* status command, results:               mysqladmin.
* status, tables:                        SHOW TABLE STATUS.
* stopping, the server:                  Automatic start.
* storage of data:                       Design.
* storage requirements, column type:     Storage requirements.
* storage space, minimizing:             Data size.
* stored procedures and triggers, defined: Missing Triggers.
* storing, data:                         Stability.
* string collating:                      String collating.
* string comparisons, case sensitivity:  String comparison functions.
* string types:                          String types.
* strings, defined:                      Literals.
* strings, escaping characters:          Literals.
* strings, non-delimited:                DATETIME.
* strings, quoting:                      Perl DBI Class.
* striping, defined:                     Disk issues.
* sub-selects:                           Missing Sub-selects.
* superuser:                             Default privileges.
* support costs:                         Cost.
* support terms:                         Licensing and Support.
* support, BDB Tables:                   Table handler support.
* support, for operating systems:        Which OS.
* support, InnoDB Tables:                Table handler support.
* support, licensing:                    Licensing policy.
* support, mailing address:              Bug reports.
* support, types:                        Support.
* suppression, default values:           configure options.
* Sybase compatibility:                  USE.
* symbolic links <1>:                    Symbolic links.
* symbolic links:                        Windows symbolic links.
* syntax, regular expression:            Regexp.
* system optimization:                   System.
* system table:                          EXPLAIN.
* system, privilege:                     What Privileges.
* system, security:                      Privilege system.
* table aliases:                         SELECT.
* table cache:                           Table cache.
* table is full <1>:                     Full table.
* table is full:                         SET OPTION.
* table names, case sensitivity <1>:     Name case sensitivity.
* table names, case sensitivity:         Extensions to ANSI.
* table types, choosing:                 Table types.
* table, mysql option:                   mysql.
* tables, BDB:                           BDB.
* tables, Berkeley DB:                   BDB.
* tables, changing column order:         Change column order.
* tables, checking:                      myisamchk check options.
* tables, closing:                       Table cache.
* tables, compressed:                    myisampack.
* tables, compressed format:             Compressed format.
* tables, constant <1>:                  Where optimizations.
* tables, constant:                      EXPLAIN.
* tables, counting rows:                 Counting rows.
* tables, creating:                      Creating tables.
* tables, defragment <1>:                Dynamic format.
* tables, defragment:                    Maintenance regimen.
* tables, defragmenting:                 OPTIMIZE TABLE.
* tables, deleting rows:                 Deleting from related tables.
* tables, displaying:                    mysqlshow.
* tables, displaying status:             SHOW TABLE STATUS.
* tables, dumping <1>:                   mysqlhotcopy.
* tables, dumping:                       mysqldump.
* tables, dynamic:                       Dynamic format.
* tables, error checking:                Check.
* tables, flush:                         mysqladmin.
* tables, fragmentation:                 OPTIMIZE TABLE.
* tables, grant:                         Request access.
* tables, HEAP:                          HEAP.
* tables, host:                          Request access.
* tables, improving performance:         Data size.
* tables, information:                   Table-info.
* tables, information about:             Getting information.
* tables, ISAM:                          ISAM.
* tables, loading data:                  Loading tables.
* tables, locking:                       Internal locking.
* tables, maintenance regimen:           Maintenance regimen.
* tables, maximum size:                  Table size.
* tables, merging:                       MERGE.
* tables, multiple:                      Multiple tables.
* tables, names:                         Legal names.
* tables, open:                          Open tables.
* tables, opening:                       Table cache.
* tables, optimizing:                    Optimization.
* tables, repairing:                     Repair.
* tables, retrieving data:               Retrieving data.
* tables, selecting columns:             Selecting columns.
* tables, selecting rows:                Selecting rows.
* tables, sorting rows:                  Sorting rows.
* tables, system:                        EXPLAIN.
* tables, too many:                      Creating many tables.
* tables, unique ID for last row:        Getting unique ID.
* tables, updating:                      Commit-rollback.
* tar, problems on Solaris:              Solaris.
* Tcl APIs:                              Tcl.
* tcp-ip option:                         mysqld_multi.
* TCP/IP:                                Windows running.
* technical support, by email:           Basic email support.
* technical support, licensing:          Licensing policy.
* technical support, mailing address:    Bug reports.
* tee, mysql option:                     mysql.
* Tek-Tips forums:                       Useful Links.
* temporary file, write access:          mysql_install_db.
* temporary tables, problems:            Temporary table problems.
* terminal monitor, defined:             Tutorial.
* testing mysqld, mysqltest:             MySQL test suite.
* testing, connection to the server:     Connection access.
* testing, installation:                 Post-installation.
* testing, of MySQL releases:            Which version.
* testing, post-installation:            Post-installation.
* testing, the server:                   Post-installation.
* Texinfo:                               Manual-info.
* TEXT columns, default values:          BLOB.
* TEXT columns, indexing:                CREATE TABLE.
* text files, importing:                 mysqlimport.
* TEXT, size:                            Storage requirements.
* thread packages, differences between:  Thread packages.
* thread support:                        Which OS.
* thread support, non-native:            MIT-pthreads.
* threaded clients:                      Threaded clients.
* threads <1>:                           MySQL internals.
* threads:                               mysqladmin.
* threads, display:                      SHOW PROCESSLIST.
* threads, RTS:                          RTS-threads.
* time types:                            Storage requirements.
* timeout <1>:                           INSERT DELAYED.
* timeout <2>:                           Miscellaneous functions.
* timeout:                               SHOW VARIABLES.
* timeout, connect_timeout variable:     mysql.
* TIMESTAMP, and NULL values:            Problems with NULL.
* timezone problems:                     Timezone problems.
* tips, optimization:                    Tips.
* ToDo list for MySQL:                   TODO.
* TODO, symlinks:                        Symbolic links to tables.
* tools, authentication:                 Contrib.
* tools, benchmarking:                   Contrib.
* tools, command line:                   mysql.
* tools, converting:                     Using mSQL tools.
* tools, mysqld_multi:                   mysqld_multi.
* tools, RPMs for:                       Contrib.
* tools, safe_mysqld:                    safe_mysqld.
* tools, useful:                         Contrib.
* tools,, web:                           Contrib.
* transaction-safe tables:               Commit-rollback.
* transactions, support:                 Missing Transactions.
* triggers, stored:                      Missing Triggers.
* troubleshooting, FreeBSD:              Compilation problems.
* troubleshooting, Solaris:              Compilation problems.
* tutorial:                              Tutorial.
* Twin Studies, queries:                 Twin.
* type conversions:                      Comparison Operators.
* types, columns <1>:                    Choosing types.
* types, columns:                        Column types.
* types, date:                           Storage requirements.
* types, Date and Time:                  Date and time types.
* types, numeric:                        Storage requirements.
* types, of support:                     Support.
* types, of tables:                      Table types.
* types, portability:                    Other-vendor column types.
* types, strings:                        String types.
* types, time:                           Storage requirements.
* typographical conventions:             Manual conventions.
* UDFs, compiling:                       UDF compiling.
* UDFs, defined:                         Adding functions.
* UDFs, return values:                   UDF return values.
* unbuffered, mysql option:              mysql.
* unique ID:                             Getting unique ID.
* Unireg, described:                     Unireg.
* unloading, tables:                     Retrieving data.
* update log:                            Update log.
* updating, releases of MySQL:           Many versions.
* updating, tables:                      Commit-rollback.
* upgrading:                             Upgrade.
* upgrading, 3.20 to 3.21:               Upgrading-from-3.20.
* upgrading, 3.21 to 3.22:               Upgrading-from-3.21.
* upgrading, 3.22 to 3.23:               Upgrading-from-3.22.
* upgrading, different architecture:     Upgrading-to-arch.
* uptime:                                mysqladmin.
* URLS for downloading MySQL:            Getting MySQL.
* URLs to MySQL information:             Useful Links.
* user names, and passwords:             User names.
* user option:                           mysqld_multi.
* user privileges, adding:               Adding users.
* user table, sorting:                   Connection access.
* user variables:                        Variables.
* user, mysql option:                    mysql.
* user-defined functions, adding <1>:    Adding UDF.
* user-defined functions, adding:        Adding functions.
* users, adding:                         Installing binary.
* users, of MySQL:                       Users.
* users, root:                           Default privileges.
* uses, of MySQL:                        Internal use.
* using multiple disks to start data:    Windows symbolic links.
* valid numbers, examples:               Number syntax.
* VARCHAR, size:                         Storage requirements.
* variables, mysqld:                     Server parameters.
* variables, status:                     SHOW STATUS.
* variables, user:                       Variables.
* variables, values:                     SHOW VARIABLES.
* verbose, mysql option:                 mysql.
* version option:                        mysqld_multi.
* version, choosing:                     Which version.
* version, latest:                       Getting MySQL.
* version, mysql option:                 mysql.
* vertical, mysql option:                mysql.
* views:                                 Missing Views.
* virtual memory, problems while compiling: Compilation problems.
* Visual Basic:                          MyODBC clients.
* wait, mysql option:                    mysql.
* Web clients:                           Contrib.
* web pages, miscellaneous:              Users.
* web search engines:                    Users.
* web server, running:                   Web server.
* web sites:                             Users.
* web tools:                             Contrib.
* Web+:                                  Useful Links.
* Webmerger:                             Useful Links.
* wild cards, in mysql.columns_priv table: Request access.
* wild cards, in mysql.db table:         Request access.
* wild cards, in mysql.host table:       Request access.
* wild cards, in mysql.tables_priv table: Request access.
* wildcards, and LIKE:                   MySQL indexes.
* wildcards, in mysql.user table:        Connection access.
* Windows:                               ODBC.
* Windows, compiling on:                 Windows compiling.
* Windows, open issues:                  Windows vs Unix.
* Windows, versus Unix:                  Windows vs Unix.
* Word program:                          MyODBC clients.
* wrappers, Eiffel:                      Eiffel.
* write access, tmp:                     mysql_install_db.
* Year 2000 compliance:                  Year 2000 compliance.
* Year 2000 issues:                      Y2K issues.


Tag Table:
Node: Top166
Node: Introduction1802
Node: MySQL and MySQL AB5046
Node: What-is5730
Node: What is MySQL AB9306
Node: Manual-info13095
Node: Manual conventions13810
Node: History17422
Node: Features18285
Node: Stability23512
Node: Table size30114
Node: Year 2000 compliance32208
Node: MySQL Information Sources36461
Node: MySQL-Books36885
Node: General-SQL51000
Node: Useful Links51774
Node: Questions70143
Node: Mailing-list70664
Node: Asking questions76853
Node: Bug reports77799
Node: Answering questions92653
Node: Licensing and Support93456
Node: Licensing policy94292
Node: Copyright97699
Node: Copyright changes99261
Node: Licensing examples99501
Node: Products that use MySQL100233
Node: ISP102116
Node: Web server103095
Node: Cost103579
Node: Payment information107072
Node: Contact information108291
Node: Support109661
Node: Basic email support110946
Node: Extended email support114174
Node: Login support115667
Node: Extended login support117303
Node: Telephone support118663
Node: Table handler support119204
Node: Compatibility120063
Node: Extensions to ANSI121029
Node: Differences from ANSI127937
Node: ANSI mode128940
Node: Missing functions129830
Node: Missing Sub-selects130745
Node: Missing SELECT INTO TABLE132991
Node: Missing Transactions133602
Node: Missing Triggers139875
Node: Missing Foreign Keys141079
Node: Broken Foreign KEY142923
Node: Missing Views145251
Node: Missing comments146125
Node: Standards147822
Node: Commit-rollback148036
Node: Bugs153147
Node: Comparisons162712
Node: Compare mSQL163490
Node: Using mSQL tools170921
Node: Protocol differences172362
Node: Syntax differences173611
Node: Compare PostgreSQL178505
Node: MySQL-PostgreSQL goals180021
Node: MySQL-PostgreSQL features182327
Node: MySQL-PostgreSQL benchmarks192619
Node: TODO204723
Node: TODO MySQL 4.0205662
Node: TODO future209197
Node: TODO sometime219545
Node: TODO unplanned223141
Node: Installing223388
Node: Quick Standard Installation225155
Node: Linux-RPM225486
Node: Windows installation227783
Node: General Installation Issues230782
Node: Getting MySQL231348
Node: Which OS238366
Node: Which version243880
Node: Installation layouts250900
Node: Many versions252989
Node: MySQL binaries255339
Node: Installing source258542
Node: Quick install261420
Node: Applying patches267005
Node: configure options268395
Node: Installing source tree275971
Node: Compilation problems279670
Node: MIT-pthreads286239
Node: Post-installation289563
Node: mysql_install_db299329
Node: Starting server303265
Node: Automatic start308937
Node: Upgrade311450
Node: Upgrading-from-3.22313624
Node: Upgrading-from-3.21318188
Node: Upgrading-from-3.20319655
Node: Upgrading-to-arch322230
Node: Operating System Specific Notes325587
Node: Linux326189
Node: Binary notes-Linux339013
Node: Linux-x86342129
Node: Linux-SPARC344311
Node: Linux-Alpha345055
Node: Linux-PowerPC347032
Node: Linux-MIPS347257
Node: Linux-IA64347591
Node: Windows348775
Node: Win95 start349574
Node: NT start351479
Node: Windows running354325
Node: Windows and SSH357577
Node: Windows symbolic links359247
Node: Windows compiling360802
Node: Windows vs Unix361495
Node: Solaris368199
Node: Solaris 2.7373973
Node: Solaris x86376217
Node: BSD Notes376996
Node: FreeBSD377589
Node: NetBSD380093
Node: OpenBSD380326
Node: OpenBSD 2.5380552
Node: OpenBSD 2.8380850
Node: BSDI381292
Node: BSDI2381559
Node: BSDI3382422
Node: BSDI4383811
Node: Mac OS X384960
Node: Mac OS X Public Beta385220
Node: Mac OS X Server385491
Node: Other Unix Notes386284
Node: Binary notes-HP-UX386984
Node: HP-UX 10.20388855
Node: HP-UX 11.x390025
Node: IBM-AIX394070
Node: SunOS398106
Node: Alpha-DEC-UNIX398755
Node: Alpha-DEC-OSF1401466
Node: SGI-Irix404785
Node: SCO407461
Node: SCO Unixware412729
Node: OS/2413283
Node: BeOS415277
Node: Novell Netware415835
Node: Tutorial416261
Node: Connecting-disconnecting418272
Node: Entering queries420104
Node: Database use428145
Node: Creating database431173
Node: Creating tables432953
Node: Loading tables437142
Node: Retrieving data440203
Node: Selecting all441370
Node: Selecting rows443853
Node: Selecting columns447082
Node: Sorting rows449222
Node: Date calculations451628
Node: Working with NULL459299
Node: Pattern matching460777
Node: Counting rows468521
Node: Multiple tables472593
Node: Getting information477020
Node: Examples479325
Node: example-Maximum-column481360
Node: example-Maximum-row481707
Node: example-Maximum-column-group482790
Node: example-Maximum-column-group-row483316
Node: example-user-variables485404
Node: example-Foreign keys486155
Node: Searching on two keys488774
Node: Calculating days489971
Node: Batch mode490892
Node: Twin493431
Node: Twin pool494817
Node: Twin event499852
Node: Apache500824
Node: MySQL Database Administration501569
Node: Configuring MySQL502422
Node: Command-line options502885
Node: Option files513194
Node: Installing many servers519170
Node: Multiple servers521347
Node: Privilege system526277
Node: General security527334
Node: Security535221
Node: Privileges options540278
Node: What Privileges542097
Node: Privileges542673
Node: Privileges provided551464
Node: Connecting557173
Node: Connection access559486
Node: Request access567606
Node: Access denied575673
Node: User Account Management589454
Node: GRANT590100
Node: User names599448
Node: Privilege changes602041
Node: Default privileges603320
Node: Adding users606947
Node: Passwords614966
Node: Password security617562
Node: Disaster Prevention620688
Node: Backup621406
Node: BACKUP TABLE624598
Node: RESTORE TABLE625741
Node: CHECK TABLE626638
Node: REPAIR TABLE631182
Node: Table maintenance632805
Node: myisamchk syntax634989
Node: myisamchk general options638269
Node: myisamchk check options640988
Node: myisamchk repair options642858
Node: myisamchk other options645913
Node: myisamchk memory647343
Node: Crash recovery649461
Node: Check652358
Node: Repair653943
Node: Optimization660329
Node: Maintenance regimen661246
Node: Table-info664049
Node: Database Administration676566
Node: OPTIMIZE TABLE677050
Node: ANALYZE TABLE678523
Node: FLUSH679575
Node: KILL682031
Node: SHOW683881
Node: SHOW DATABASE INFO685179
Node: SHOW TABLE STATUS688407
Node: SHOW STATUS689912
Node: SHOW VARIABLES700271
Node: SHOW LOGS723972
Node: SHOW PROCESSLIST724521
Node: SHOW GRANTS725359
Node: SHOW CREATE TABLE726025
Node: Localization726648
Node: Character sets727258
Node: Languages729761
Node: Adding character set730848
Node: Character arrays734349
Node: String collating736174
Node: Multi-byte characters736893
Node: Server-Side Scripts737620
Node: Server-Side Overview738248
Node: safe_mysqld741843
Node: mysqld_multi746113
Node: myisampack754263
Node: mysqld-max768472
Node: Client-Side Scripts772017
Node: Client-Side Overview772980
Node: mysql776569
Node: mysqladmin789564
Node: Using mysqlcheck792900
Node: mysqldump797602
Node: mysqlhotcopy804702
Node: mysqlimport806896
Node: mysqlshow811673
Node: perror812909
Node: Batch Commands813547
Node: Log Files814299
Node: Error log815736
Node: Query log816594
Node: Update log817599
Node: Binary log819935
Node: Slow query log823790
Node: Log file maintenance824968
Node: Replication826751
Node: Replication Intro827696
Node: Replication Implementation829064
Node: Replication HOWTO830923
Node: Replication Features835574
Node: Replication Options842472
Node: Replication SQL852229
Node: Replication FAQ857830
Node: Replication Problems868492
Node: MySQL Optimization874236
Node: Optimize Overview875249
Node: Design Limitations877102
Node: Portability877817
Node: Internal use881172
Node: MySQL Benchmarks884402
Node: Custom Benchmarks887632
Node: Query Speed889362
Node: EXPLAIN891247
Node: Estimating performance905402
Node: SELECT speed907036
Node: Where optimizations908562
Node: DISTINCT optimization912900
Node: LEFT JOIN optimization913695
Node: LIMIT optimization915800
Node: Insert speed917125
Node: Update speed921637
Node: Delete speed922475
Node: Tips922913
Node: Locking Issues931637
Node: Internal locking931912
Node: Table locking934001
Node: Optimizing Database Structure938224
Node: Design938925
Node: Data size940455
Node: MySQL indexes943320
Node: Indexes950194
Node: Multiple-column indexes951670
Node: Table cache953815
Node: Creating many tables956270
Node: Open tables956877
Node: Optimizing the Server957601
Node: System958174
Node: Server parameters960485
Node: Compile and link options965426
Node: Memory use969328
Node: DNS974140
Node: SET OPTION975472
Node: Disk issues981827
Node: Symbolic links985893
Node: Symbolic links to databases986600
Node: Symbolic links to tables988010
Node: Reference990945
Node: Language Structure991992
Node: Literals992519
Node: String syntax993100
Node: Number syntax996724
Node: Hexadecimal values997270
Node: NULL values997795
Node: Legal names998251
Node: Name case sensitivity1001954
Node: Variables1003670
Node: Comments1005884
Node: Reserved words1007525
Node: Column types1012498
Node: Numeric types1023954
Node: Date and time types1030552
Node: Y2K issues1034139
Node: DATETIME1035504
Node: TIME1046054
Node: YEAR1049030
Node: String types1050356
Node: CHAR1050909
Node: BLOB1053526
Node: ENUM1056742
Node: SET1059570
Node: Choosing types1062615
Node: Other-vendor column types1063493
Node: Storage requirements1064761
Node: Functions1068769
Node: Non-typed Operators1070438
Node: Parenthesis1070842
Node: Comparison Operators1071177
Node: Logical Operators1077175
Node: Control flow functions1078394
Node: String functions1081872
Node: String comparison functions1097508
Node: Case Sensitivity Operators1102011
Node: Numeric Functions1102997
Node: Arithmetic functions1103272
Node: Mathematical functions1104550
Node: Date and time functions1113958
Node: Other Functions1130941
Node: Bit functions1131178
Node: Miscellaneous functions1132056
Node: Data Manipulation1141348
Node: SELECT1141984
Node: JOIN1151894
Node: INSERT1156367
Node: INSERT SELECT1161232
Node: INSERT DELAYED1162571
Node: UPDATE1168039
Node: DELETE1169882
Node: TRUNCATE1171714
Node: REPLACE1172486
Node: LOAD DATA1173682
Node: Data Definition1191523
Node: CREATE DATABASE1192165
Node: DROP DATABASE1192944
Node: CREATE TABLE1194524
Node: Silent column changes1213630
Node: ALTER TABLE1215642
Node: RENAME TABLE1225140
Node: DROP TABLE1226450
Node: CREATE INDEX1227139
Node: DROP INDEX1229070
Node: Basic User Commands1229509
Node: USE1229834
Node: DESCRIBE1230858
Node: Transactional Commands1231627
Node: COMMIT1232026
Node: LOCK TABLES1234018
Node: SET TRANSACTION1239866
Node: Fulltext Search1240663
Node: Fulltext restrictions1247514
Node: Fulltext Fine-tuning1247870
Node: Fulltext Features to Appear in MySQL 4.01249276
Node: Fulltext TODO1250693
Node: Table types1251635
Node: MyISAM1254405
Node: Key space1262174
Node: MyISAM table formats1263309
Node: Static format1263882
Node: Dynamic format1265352
Node: Compressed format1268004
Node: MyISAM table problems1269614
Node: Corrupted MyISAM tables1270068
Node: MyISAM table close1271690
Node: MERGE1273819
Node: ISAM1279757
Node: HEAP1281155
Node: BDB1283921
Node: BDB overview1284514
Node: BDB install1285937
Node: BDB start1286815
Node: BDB characteristic1289231
Node: BDB TODO1293039
Node: BDB portability1293702
Node: BDB errors1294591
Node: InnoDB1295801
Node: InnoDB overview1296787
Node: InnoDB start1299146
Node: InnoDB init1307778
Node: Error creating InnoDB1310482
Node: Using InnoDB tables1311045
Node: Adding and removing1314600
Node: Backing up1315747
Node: InnoDB checkpoints1319539
Node: Moving1321156
Node: InnoDB transaction model1322240
Node: InnoDB consistent read1323975
Node: InnoDB locking reads1325326
Node: InnoDB Next-key locking1327748
Node: InnoDB Locks set1330209
Node: InnoDB Deadlock detection1332640
Node: InnoDB Consistent read example1333676
Node: Implementation1343460
Node: Table and index1346001
Node: InnoDB physical structure1347605
Node: InnoDB Insert buffering1348408
Node: InnoDB Adaptive hash1349808
Node: InnoDB Physical record1350947
Node: File space management1353482
Node: InnoDB Disk i/o1353822
Node: InnoDB File space1356456
Node: InnoDB File Defragmenting1358847
Node: Error handling1359893
Node: InnoDB restrictions1361135
Node: InnoDB contact information1363984
Node: Clients1364460
Node: PHP1365253
Node: PHP problems1365798
Node: Perl1366798
Node: DBI with DBD1367283
Node: Perl DBI Class1368210
Node: DBI-info1382144
Node: ODBC1382629
Node: Installing MyODBC1383487
Node: ODBC administrator1386709
Node: MyODBC connect parameters1388211
Node: ODBC Problems1391713
Node: MyODBC clients1392897
Node: ODBC and last_insert_id1404453
Node: MyODBC bug report1405369
Node: C1407751
Node: C API datatypes1410460
Node: C API function overview1416564
Node: C API functions1427380
Node: mysql_affected_rows1431402
Node: mysql_close1432961
Node: mysql_connect1433423
Node: mysql_change_user1434658
Node: mysql_character_set_name1436529
Node: mysql_create_db1436933
Node: mysql_data_seek1437930
Node: mysql_debug1438566
Node: mysql_drop_db1439231
Node: mysql_dump_debug_info1440188
Node: mysql_eof1440940
Node: mysql_errno1443546
Node: mysql_error1444323
Node: mysql_escape_string1445280
Node: mysql_fetch_field1445776
Node: mysql_fetch_fields1447279
Node: mysql_fetch_field_direct1448095
Node: mysql_fetch_lengths1449099
Node: mysql_fetch_row1450751
Node: mysql_field_count1452599
Node: mysql_field_seek1454950
Node: mysql_field_tell1455604
Node: mysql_free_result1456086
Node: mysql_get_client_info1456606
Node: mysql_get_host_info1457030
Node: mysql_get_proto_info1457498
Node: mysql_get_server_info1457950
Node: mysql_info1458368
Node: mysql_init1459715
Node: mysql_insert_id1460479
Node: mysql_kill1461616
Node: mysql_list_dbs1462251
Node: mysql_list_fields1463306
Node: mysql_list_processes1464477
Node: mysql_list_tables1465340
Node: mysql_num_fields1466381
Node: mysql_num_rows1468818
Node: mysql_options1469539
Node: mysql_ping1473441
Node: mysql_query1474214
Node: mysql_real_connect1475407
Node: mysql_real_escape_string1481455
Node: mysql_real_query1483523
Node: mysql_reload1484835
Node: mysql_row_seek1485632
Node: mysql_row_tell1486549
Node: mysql_select_db1487114
Node: mysql_shutdown1488071
Node: mysql_stat1488735
Node: mysql_store_result1489545
Node: mysql_thread_id1492044
Node: mysql_use_result1492693
Node: C Thread functions1495121
Node: my_init1495463
Node: my_thread_init()1495982
Node: my_thread_end()1496357
Node: C API problems1496739
Node: NULL mysql_store_result1497310
Node: Query results1498847
Node: Getting unique ID1500356
Node: C API linking problems1501857
Node: Building clients1502518
Node: Threaded clients1503263
Node: Cplusplus1507874
Node: Borland C++1508132
Node: Java1508950
Node: Python1509495
Node: Tcl1509853
Node: Eiffel1510145
Node: Extending MySQL1510447
Node: Adding functions1510750
Node: CREATE FUNCTION1512314
Node: Adding UDF1513775
Node: UDF calling sequences1517370
Node: UDF arguments1520094
Node: UDF return values1523866
Node: UDF compiling1525819
Node: Adding native function1529949
Node: Adding procedures1533797
Node: procedure analyse1534577
Node: Writing a procedure1535353
Node: MySQL internals1535739
Node: MySQL threads1536465
Node: MySQL test suite1537983
Node: running mysqltest1539456
Node: extending mysqltest1540772
Node: Reporting mysqltest bugs1544233
Node: Problems1546954
Node: What is crashing1547716
Node: Common errors1551792
Node: Error Access denied1553175
Node: Gone away1553388
Node: Can not connect to server1555324
Node: Blocked host1560880
Node: Too many connections1562051
Node: Non-transactional tables1563148
Node: Out of memory1564333
Node: Packet too large1565182
Node: Communication errors1566377
Node: Full table1568594
Node: Cannot create1569406
Node: Commands out of sync1570241
Node: Ignoring user1570859
Node: Cannot find table1572265
Node: Cannot initialize character set1573003
Node: Not enough file handles1574449
Node: Installation Issues1576824
Node: Link errors1577219
Node: Changing MySQL user1579864
Node: File permissions1582683
Node: Administration Issues1583935
Node: Crashing1584517
Node: Resetting permissions1591804
Node: Full disk1593052
Node: Temporary files1594669
Node: Problems with mysql.sock1596194
Node: Timezone problems1596949
Node: Query Issues1597407
Node: Case sensitivity1597954
Node: Using DATE1599311
Node: Problems with NULL1601981
Node: Problems with alias1604695
Node: Deleting from related tables1605706
Node: No matching rows1606776
Node: Table Definition Issues1608672
Node: ALTER TABLE problems1609031
Node: Change column order1610523
Node: Temporary table problems1611798
Node: Users1612477
Node: MySQL customer usage1625221
Node: Contrib1626715
Node: Credits1667010
Node: Developers1667388
Node: Contributors1671370
Node: Supporters1681632
Node: News1682342
Node: News-4.0.x1683211
Node: News-4.0.01683673
Node: News-3.23.x1685102
Node: News-3.23.421689269
Node: News-3.23.411691299
Node: News-3.23.401692762
Node: News-3.23.391694702
Node: News-3.23.381696113
Node: News-3.23.371697732
Node: News-3.23.361700347
Node: News-3.23.351701862
Node: News-3.23.34a1702379
Node: News-3.23.341702631
Node: News-3.23.331705202
Node: News-3.23.321708386
Node: News-3.23.311709715
Node: News-3.23.301711552
Node: News-3.23.291713458
Node: News-3.23.281717920
Node: News-3.23.271722584
Node: News-3.23.261723143
Node: News-3.23.251725849
Node: News-3.23.241728718
Node: News-3.23.231729600
Node: News-3.23.221733832
Node: News-3.23.211735224
Node: News-3.23.201736647
Node: News-3.23.191736910
Node: News-3.23.181738318
Node: News-3.23.171738998
Node: News-3.23.161740972
Node: News-3.23.151741952
Node: News-3.23.141744587
Node: News-3.23.131746316
Node: News-3.23.121747250
Node: News-3.23.111748990
Node: News-3.23.101750537
Node: News-3.23.91750784
Node: News-3.23.81753274
Node: News-3.23.71754541
Node: News-3.23.61756623
Node: News-3.23.51758406
Node: News-3.23.41760340
Node: News-3.23.31761500
Node: News-3.23.21762602
Node: News-3.23.11764944
Node: News-3.23.01765134
Node: News-3.22.x1770172
Node: News-3.22.351772782
Node: News-3.22.341773181
Node: News-3.22.331773581
Node: News-3.22.321773856
Node: News-3.22.311774556
Node: News-3.22.301774761
Node: News-3.22.291775323
Node: News-3.22.281776257
Node: News-3.22.271776677
Node: News-3.22.261777081
Node: News-3.22.251777974
Node: News-3.22.241778185
Node: News-3.22.231778706
Node: News-3.22.221779528
Node: News-3.22.211780247
Node: News-3.22.201780989
Node: News-3.22.191781340
Node: News-3.22.181781682
Node: News-3.22.171782238
Node: News-3.22.161782658
Node: News-3.22.151783366
Node: News-3.22.141784706
Node: News-3.22.131785609
Node: News-3.22.121786147
Node: News-3.22.111787478
Node: News-3.22.101788893
Node: News-3.22.91791151
Node: News-3.22.81792260
Node: News-3.22.71793747
Node: News-3.22.61795534
Node: News-3.22.51796160
Node: News-3.22.41800660
Node: News-3.22.31802321
Node: News-3.22.21802740
Node: News-3.22.11804183
Node: News-3.22.01805614
Node: News-3.21.x1810259
Node: News-3.21.331812600
Node: News-3.21.321813206
Node: News-3.21.311814455
Node: News-3.21.301815088
Node: News-3.21.291816673
Node: News-3.21.281817416
Node: News-3.21.271817787
Node: News-3.21.261819021
Node: News-3.21.251819948
Node: News-3.21.241820528
Node: News-3.21.231821431
Node: News-3.21.221822876
Node: News-3.21.21a1824573
Node: News-3.21.211824784
Node: News-3.21.201825159
Node: News-3.21.191825823
Node: News-3.21.181826259
Node: News-3.21.171827053
Node: News-3.21.161828247
Node: News-3.21.151828951
Node: News-3.21.14b1831437
Node: News-3.21.14a1831667
Node: News-3.21.131833277
Node: News-3.21.121834205
Node: News-3.21.111836395
Node: News-3.21.101837453
Node: News-3.21.91838480
Node: News-3.21.81838998
Node: News-3.21.71840400
Node: News-3.21.61841138
Node: News-3.21.51841459
Node: News-3.21.41842098
Node: News-3.21.31842562
Node: News-3.21.21844717
Node: News-3.21.01846839
Node: News-3.20.x1849484
Node: News-3.20.181850762
Node: News-3.20.171852352
Node: News-3.20.161854427
Node: News-3.20.151855356
Node: News-3.20.141856107
Node: News-3.20.131857406
Node: News-3.20.111858736
Node: News-3.20.101859666
Node: News-3.20.91860363
Node: News-3.20.81860787
Node: News-3.20.71860994
Node: News-3.20.61862102
Node: News-3.20.31865042
Node: News-3.20.01867475
Node: News-3.19.x1869105
Node: News-3.19.51869541
Node: News-3.19.41870245
Node: News-3.19.31871010
Node: Porting1871658
Node: Debugging server1874465
Node: Compiling for debugging1876566
Node: Making trace files1879141
Node: Using gdb on mysqld1880826
Node: Using stack trace1883274
Node: Using log files1885513
Node: Reproduceable test case1888142
Node: Debugging client1890019
Node: The DBUG package1891195
Node: Locking methods1895235
Node: RTS-threads1899186
Node: Thread packages1902191
Node: Environment variables1904662
Node: Regexp1906786
Node: Unireg1913826
Node: GPL license1916043
Node: LGPL license1935235
Node: Placeholder1963337
Node: Installing binary1963710
Node: Perl support1970601
Node: Perl installation1971065
Node: ActiveState Perl1973670
Node: Windows Perl1974847
Node: Perl support problems1975534
Node: Group by functions1979570
Node: Function Index1983719
Node: Concept Index2024330
End Tag Table
