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]

data     analyzing

     capturing

     changing 2nd     copying between tables     deleting 2nd     exporting     grouping 2nd

     importing 2nd 3rd 4th     inserting     limiting 2nd     manipulating

     optimizing in tables

     ordering 2nd     searching 2nd     selecting 2nd

     SQL statements for

     temporarily storing results Data Source Name (DSN)

--data-file-length option (myisamchk) data_sources( ) function (Perl DBI) Database attribute (Perl DBI)

database handles, attributes for

--database option (mysqlbinlog)

DATABASE( ) function

databases     backing up

     copying

     creating 2nd 3rd     creating tables within

     deleting     displaying 2nd     dropping views from

     listing

     mailing lists

     moving tables to

     ROLLBACK statement and

     SQL statements 2nd

     views

--databases option

     mysqlcheck utility 2nd

     mysqldump utility 2nd

--datadir option

     mysqld daemon

     mysqld_safe program

datatypes

     accurate numeric 2nd

     approximate numeric 2nd

     C API 2nd     date/time

     numeric

     string 2nd     temporalDATE datatype     CAST( ) function     CONVERT( ) function

     format     GET_FORMAT( ) and     overview 2nd date functions 2nd

DATE( ) function

DATE_ADD( ) function 2nd DATE_FORMAT( ) function 2nd DATE_SUB( ) function 2nd

DATEDIFF( ) function

DATETIME datatype     CAST( ) function

     CONVERT( ) function     DATE( ) function     format

     GET_FORMAT( ) and

     mysqlbinlog utility

     overview

DAY interval     DATE_ADD function

     TIMESTAMPADD function

DAY( ) function DAY_HOUR increment (DATE_ADD)

DAY_MINUTE increment (DATE_ADD) DAY_SECOND increment (DATE_ADD) DAYNAME( ) function

DAYOFMONTH( ) function 2nd

DAYOFWEEK( ) function

DAYOFYEAR( ) function

--db option (mysqlaccess)

DBI module

DBI_DRIVER environment variable

DBI_TRACE environment variable

DBI_USER environment variable

--debug option

     myisamchk utility

     myisampack utility

     mysql utility

     mysqlaccess utility

     mysqladmin utility 2nd

     mysqlcheck utility

     mysqld daemon     mysqldump utility

     mysqlhotcopy utility

     mysqlimport utility     mysqlshow utility --debug-info option (mysql) DEC datatype DECIMAL datatype 2nd 3rd

DECODE( ) function 2nd decryption 2nd 3rdDEFAULT keyword     ALTER DATABASE statement

     CREATE TABLE statement 2nd

     INSERT statement--default-character-set option     mysqlcheck utility

     mysqld daemon

     mysqldump utility     mysqlimport utility

     mysqlshow utility --default-collation option (mysqld) --default-storage-engine option (mysqld)

--default-table-type option (mysqld) 2nd

--default-time-zone option (mysqld)

--defaults-extra-file option

     mysqld_safe program     mysqlimport utility

--defaults-file option

     mysqld_safe program     mysqlimport utility

DEGREES( ) function --delay-key-write option (mysqld) 2nd --delay-key-write-for-all-tables option (mysqld)

DELAYED flag

     INSERT statement 2nd

     REPLACE statement

--delayed option (mysqldump)

--delete option (mysqlimport)

DELETE privilege (GRANT/REVOKE) 2nd

DELETE statement

     deleting rows

     deleting users

     FLUSH PRIVILEGES statement

     functionality 2nd

     granting privileges for

     JOIN clause

     mysql_affected_rows( ) and 2nd

     mysql_autocommit( ) and

     mysql_commit( ) and     rows( ) and

     syntax

     TRUNCATE TABLE statement --delete-master-logs option (mysqldump) DES algorithm 2nd DES encryption files --des-key-file option (mysqld)

DES_DECRYPT( ) function 2nd 3rd DES_ENCRYPT( ) function 2nd 3rdDESC flag     CREATE INDEX statement

     CREATE TABLE statement 2nd

     GROUP_CONCAT( ) function     ORDER BY clause     SELECT statement 2nd 3rd

DESCRIBE statement 2nd 3rd

--description option (myisamchk) 2nd --disable-keys option (mysqldump)

--disable-log-bin option (mysqlbinlog) disconnect( ) function (Perl DBI) 2nd 3rd 4thDISTINCT flag

     GROUP_CONCAT( ) function

     SELECT statement 2nd

DISTINCTROW flag (SELECT)

distribution     choosing 2nd

     Linux RPM format 2nd

     Mac OS X environment     Novell NetWare environment

     Unix environment     Windows environment 2nd DIV operator

DO statement 2nd

do( ) function (Perl DBI)

documentation, online 2nd

dot (.)

DOUBLE datatype

DOUBLE PRECISION datatype 2nd 3rd

Driver attribute (Perl DBI)

DROP clause (ALTER TABLE) 2nd

drop command (mysqladmin)

DROP DATABASE statement

     C API functions and

     commits and

     mysql_query( ) and

     mysqladmin utility

     syntax

DROP INDEX statement 2nd 3rd 4th DROP privilege (GRANT/REVOKE) 2nd 3rd

DROP statement

DROP TABLE statement 2nd 3rd 4th 5th DROP USER statement DROP VIEW statement 2nd 3rd --dryrun option (mysqlhotcopy) DSN (Data Source Name)

dump_results( ) function (Perl DBI)