[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] id option EXPLAIN command IDENTIFIED BY clause GRANT statement identifiers case sensitivity 2nd character lengths quote characters reseverd words IF function IF NOT EXISTS clause IGNORE clause LOAD DATA INFILE statement UPDATE statement IN keyword INDEX DIRECTORY option table optimization INDEX keyword INDEX privilege index value EXPLAIN command indexes creating 2nd 3rd database optimization 2nd 3rd 4th 5th deleting leftmost prefix multicolumn optimization considerations 2nd query optimization single-column INGORE clause INSERT statement InnoDB configuration options MySQL configuration 2nd 3rd 4th InnoDB tables 2nd consistent nonlocking licensing agreement row-level locking transactions with 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 tranactions isolation 2nd 3rd 4th 5th 6th 7th Web site for INSERT METHOD option table optimization INSERT privilege INSERT statement 2nd 3rd clauses 2nd 3rd general form of 2nd 3rd listing 2nd 3rd 4th output example inserting rows into tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th insertion nomalies 2nd 3rd installation files securing access and privileges 2nd 3rd application-level error checking 2nd do's and don'ts filtered data 2nd physical security 2nd SSL (Secure Sockets Layer) 2nd installing MySQL 2nd accounts, creating for basic use 2nd anonymous accounts, deleting on Linux 2nd on OS X 2nd 3rd on Windows 2nd 3rd 4th 5th root password, setting 2nd system configuration 2nd 3rd 4th 5th 6th testing 2nd 3rd 4th Integer column type interfaces MySQL Control Center 2nd MySQL monitor 2nd 3rd 4th 5th 6th 7th phpMyAdmin 2nd internationalization configuration MySQL configuration 2nd ISAM tables limitations 2nd overview isolation transactions isolation levels (transactions) dirty read phantom reads read committed read uncommitted repeatable read serializable |