[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] qq{} construct Perl DBI API 2nd 3rd qualifiers naming conventions for database elements 2nd qualifying column references QUARTER() function queries 2nd 3rd 4th 5th access verification 2nd batch mode 2nd 3rd canceling copying and pasting 2nd creating tables from 2nd 3rd 4th handling in client programs 2nd calculations on result sets 2nd escape characters 2nd 3rd general purpose example 2nd 3rd image data 2nd interactive query program example 2nd mysql_store_result() versus mysql_use_result() 2nd 3rd process_query() alternatives 2nd result set metadata 2nd 3rd 4th 5th table information with result set 2nd 3rd 4th without result set 2nd input line editing 2nd 3rd limiting results 2nd 3rd log files binary update log 2nd 3rd general query log 2nd 3rd slow-query log 2nd 3rd update log 2nd 3rd Perl DBI API executing 2nd preparing 2nd processing results (Perl DBI API) testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th without result set 2nd processing results (PHP API) 2nd 3rd 4th testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th without result set 2nd reading from file reasons for failure scheduling optimization 2nd 3rd semicolon in 2nd sorting results 2nd 3rd 4th terminology 2nd vertical output display queries. [See also result sets]2nd [See server queries] query cache query optimization 2nd QUERY CACHE option flushing caches resetting cache query cache status variables displaying 2nd QUERY CACHE TYPE option setting variables query caching query functions C API 2nd 3rd 4th 5th PHP API 2nd 3rd 4th 5th 6th 7th 8th 9th query optimization 2nd administrator duties 2nd 3rd hardware configuration 2nd query cache 2nd column types 2nd 3rd indexes 2nd advantages of 2nd 3rd 4th disadvantages of 2nd tips for setting up 2nd 3rd loading data 2nd 3rd 4th 5th 6th 7th 8th 9th 10th locking tables 2nd MySQL query optimizer 2nd overriding 2nd tips for using 2nd 3rd 4th scheduling queries 2nd 3rd query_cache_limit variable 2nd query_cache_size variable 2nd query_cache_type variable 2nd question mark (?) help command QUICK clause deleting table rows QUICK option error checking tables 2nd repairing tables 2nd quit command quotas selecting ISPs 2nd quotation marks ("©") escaping in strings quotation marks ("") escaping in strings Perl DBI API escaping 2nd 3rd 4th 5th PHP API escaping 2nd 3rd quote() Perl DBI API 2nd Perl DBI database handle method 2nd QUOTE() function quotes (") around hostname and username |