MYSQL in a Nutshell (In a Nutshell (OReilly))

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

C API     datatypes 2nd

     functions

     msql2mysql utility and     overview     Windows environment and CACHE INDEX statement CachedKids attribute (Perl DBI) 2nd

can( ) function (Perl DBI) carriage return (\\\\r) 2ndCASCADE flag     CREATE TABLE statement

     DROP TABLE statement

     DROP VIEW statementcase sensitivity     BINARY function

     GREATEST( ) function

     LEAST( ) function     MySQL and

     statements and     string datatypes CASE( ) function 2nd 3rd

CAST( ) function

CC environment variable

cd command 2nd 3rd

CEIL( ) function 2nd CEILING( ) function 2nd 3rd

CFLAGS environment variable

CHANGE clause (ALTER TABLE) CHANGE MASTER statement

CHANGE MASTER TO statement 2nd CHANGED function (CHECK TABLE) CHAR BINARY datatype

CHAR datatype 2nd 3rd 4th 5th 6th

CHAR( ) function

CHAR_LENGTH( ) function 2nd 3rd

CHARACTER SET option

     ALTER DATABASE statement

     CREATE DATABASE statement

character sets 2nd 3rd

character sets, displaying 2nd

--character-set-server option (mysqld) 2nd

--character-sets-dir option

     myisamchk utility 2nd

     mysqladmin utility

     mysqlcheck utility

     mysqld daemon

     mysqldump utility

     mysqlimport utility     mysqlshow utility

CHARACTER_LENGTH( ) function 2nd

CHARSET( ) function CHECK clause (CREATE TABLE)--check option     myisamchk utility 2nd 3rd     mysqlcheck utility 2nd

CHECK TABLE statement 2nd--check-only-changed option     myisamchk utility     mysqlcheck utility

--checkpoint option (mysqlhotcopy)

CHECKSUM TABLE statement chgrp command 2nd chkconfig command 2nd

chmod command 2nd

ChopBlanks attribute (Perl DBI) chown command 2nd

--chroot option (mysqld) chroot( ) function clone( ) function (Perl DBI)

COALESCE( ) function

COERCIBILITY( ) function

COLLATE option

     ALTER DATABASE statement     CREATE DATABASE statement

COLLATION( ) function

collation, displaying 2nd --collation-server option (mysqld) 2nd

COLUMN keyword (ALTER TABLE) 2nd column_info( ) function (Perl DBI)columns

     adding 2nd

     changing

     changing definitions

     comments about

     CREATE TABLE statement and

     creating aliases for

     datatypes and

     displaying 2nd

     formatting

     ignoring unwanted

     indexes and

     manipulating

     naming

     ordering

     removing

     restricting access     selecting

     setting default values

     sorting     specifying maximum size     unique --columns option (mysqlimport) columns, displaying

comma (,)     ALTER TABLE statement 2nd     GROUP_CONCAT( ) function     INSERT statement 2nd

     REPLACE statement

     SELECT statement and command-line interface command-line utilities

COMMENT keyword (CREATE TABLE)

--comments option (mysqldump) --commit option (mysqlaccess)

COMMIT statement 2nd 3rd 4th 5th 6th commit( ) function (Perl DBI) 2nd 3rd comp_err utility

--compatible option (mysqldump)

CompatMode attribute (Perl DBI)

--complete-insert option (mysqldump)

--compress option     mysqladmin utility

     mysqlcheck utility

     mysqldump utility     mysqlimport utility

     mysqlshow utility COMPRESS( ) function 2nd 3rd CONCAT( ) function 2nd 3rd

CONCAT_WS( ) function

CONCURRENT flag (LOAD DATA INFILE)

--config-file option (mysqld_multi)

configuration

     MySQL Server Instance Configuration Wizard

     mysqld options and

     options for

     postinstallation adjustments 2nd

connect( ) function (Perl DBI) 2nd

connect_cached( ) function (Perl DBI) 2nd

--connect_timeout option (mysqladmin)

CONNECTION flag (KILL)

CONNECTION_ID( ) function

--console option (mysqld)

CONV( ) function

conversion     IP addresses 2nd

     numbers in base systems

     RGB values     time zones CONVERT( ) function 2nd CONVERT( ) USING function CONVERT_TZ( ) function

--copy option (mysqlaccess) copyrights --core-file option (mysqld)--core-file-size option

     mysqld daemon

     mysqld_safe program --correct-checksum option (myisamchk) COS( ) function

cosine 2nd

COT( ) function cotangent

COUNT clause     SHOW ERRORS statement     SHOW WARNINGS statement

--count option (mysqladmin) 2nd

COUNT( ) function 2nd

cp command 2nd

CRC32( ) function create command (mysqladmin)

CREATE DATABASE statement

     example     mysql_create_db( ) and

     mysql_query( ) and     mysqldump utility     syntax

CREATE INDEX statement

     commits and

     creating indexes

     defining indexes

     granting privileges for

     syntax

CREATE privilege (GRANT/REVOKE) 2nd 3rd

CREATE TABLE statement

     adding indexes

     character sets used

     column default value

     example

     granting privileges for

     mysqldump utility

     mysqldump utility and

     ROLLBACK statement and     syntax

CREATE TEMPORARY TABLES privilege (GRANT/REVOKE)

CREATE VIEW privilege (GRANT/REVOKE) CREATE VIEW statement 2nd 3rd --create-options option (mysqldump) 2nd CROSS keyword (JOIN clause) CURDATE( ) function 2nd 3rd

CURRENT_DATE( ) function 2nd CURRENT_TIME( ) function CURRENT_TIMESTAMP( ) function CURRENT_USER( ) function 2nd

CursorName attribute (Perl DBI)

CURTIME( ) function 2nd CXX environment variable CXXFLAGS environment variable

cyclic redundancy check