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] tables [See also queries.] adding data to AUTO_INCREMENT columns data from other tables date/time INSERT command INSERT...SELECT command LOAD DATA INFILE command multiple rows optimization tips aliases body book table candidate keys cardinality columns 2nd adding aliases AUTO_INCREMENT columns average values, finding DECIMAL-type defining definitions, changing deleting identifiers minimum/maximum values, finding naming renaming updating components of copying corrupted data creating book table candidate keys columns CREATE TABLE command loan table person table primary keys table design degree DELAY_KEY_WRITE option deleting designing foreign keys how they work indexes creating 2nd deleting joins 2nd creating inner joins JOIN keyword outer joins table aliases listing all tables tables in other databases loan table map of person table populating primary keys 2nd renaming rows adding to tables assigning numbers to copying between tables deleting duplicate rows, ignoring limiting number of rows returned sample tables structure of table definition viewing information about technical support testing queries inside transactions text editors text files importing data from loading commands from text, pattern matching times adding to tables finding TO keyword (GRANT command) Too many connections (error message) transactions, testing queries within troubleshooting [See also backups.] corrupted table data error messages Access denied Can't connect to MySQL server Got error from table handler MySQL server has gone away server crashes technical support/help Too many connections |