[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] table cache parameter table privileges granting table value EXPLAIN command tables ALTER TABLE statement BACKUP TABLE command 2nd 3rd Berkeley BD (DBD) BerkeleyDB (BDB) 2nd 3rd Boolean expression subqueries 2nd 3rd 4th 5th 6th checking and repairing CHECK TABLE command myisamchk program 2nd 3rd mysqlcheck program 2nd REPAIR TABLE command 2nd technqiues for columns date and time types 2nd 3rd 4th 5th numerical type 2nd 3rd 4th 5th 6th 7th selecting 2nd 3rd string and text types 2nd 3rd 4th 5th 6th 7th 8th 9th string and text typese unique creating CREATE TABLE SQL statement 2nd 3rd 4th 5th 6th 7th 8th 9th employee database example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th optimization options 2nd 3rd 4th database tables attributes tuples databases 2nd 3rd 4th deleting derived table subqueries 2nd 3rd DROP TABLE command FLUSH TABLES command heap HEAP limitations 2nd HEAPcreating indexes leftmost prefix multicolumn optimization 2nd 3rd 4th 5th single-column InnoDB 2nd consistent nonlocking licensing agreement row-level locking transactions with 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st Web site for ISAM limitations 2nd overview joining cross joins equijoin full joins LEFT joins 2nd 3rd multiple tables 2nd 3rd 4th RIGHT joins 2nd 3rd self joins 2nd 3rd 4th 5th 6th 7th two tables 2nd 3rd 4th 5th LOCK TABLES command locking merge MERGE 2nd 3rd 4th 5th FLUSH TABLES command MyISAM compressed compressing 2nd 3rd dynamic 2nd full-text searching 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th improvements to 2nd 3rd overview 2nd 3rd repairing static 2nd 3rd 4th privileges 2nd columns_priv tables 2nd 3rd db tables 2nd 3rd host tables 2nd 3rd tables_priv tables 2nd 3rd user tables 2nd 3rd 4th 5th reference information, viewing 2nd 3rd renaming RESTORE TABLE command 2nd 3rd rows deleting 2nd 3rd 4th 5th 6th 7th duplicates 2nd 3rd 4th 5th grouped 2nd 3rd 4th inserting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th replacing 2nd selecting 2nd 3rd 4th 5th 6th truncating 2nd updating 2nd 3rd 4th selecting 2nd 3rd 4th 5th 6th 7th 8th single-value subqueries 2nd 3rd structure of, altering 2nd 3rd 4th transaction safe 2nd types of 2nd uploading data 2nd 3rd 4th 5th 6th 7th 8th tables, database tables 2nd columns functional dependencies keys 2nd records rows tables_priv tables privileges column_priv columns grant columns scope columns TEMPORARY keyword testing backup procedures 2nd MySQL installation 2nd 3rd 4th text and string column types BLOB 2nd CHAR 2nd 3rd ENU SET TEXT 2nd VARCHAR TEXT column type 2nd third normal form (3NF) 2nd 3rd 4th 5th 6th threads terminating 2nd threads connected server value time and date functions 2nd 3rd 4th 5th 6th 7th time column type TIMESTAMP time column types 2nd TIMESTAMP column type Timestamp columns columns_priv tables timestamp() function TINYINT integer column type TO clause GRANT statement tools myisamchk Windows Administrative Services window transaction safe tables 2nd berkeleyDB (BDB) 2nd 3rd types of 2nd transactions defined 2nd 3rd 4th 5th 6th 7th 8th 9th 10th START TRANSACTION command with InnoDB tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th ACID compliance 2nd 3rd 4th autocommit mode 2nd 3rd 4th 5th 6th 7th 8th 9th transaction isolation 2nd 3rd 4th 5th 6th 7th transation safe tables InnoDB consistent nonlocking licensing agreement row-level locking Web site for trim() function TRUNCATE statement 2nd truncating rows 2nd tuples database tables, concepts and terminology type value EXPLAIN command |