[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] p() CGI.pm Perl module PACK KEYS option creating tables pack_isam utility 2nd 3rd 4th options list of 2nd 3rd 4th standard options supported packing data in BLOB columns 2nd pager command param() invoking CGI scripts with parameters Web input parameters parameter binding Perl DBI API 2nd parameters C API functions 2nd connection parameters. [See connection parameters] input parameters PHP API 2nd 3rd 4th 5th 6th invoking scripts with CGI.pm Perl module 2nd 3rd 4th 5th 6th PHP API functions 2nd parameters. [See variables]2nd [See also options] parentheses () grouping operators partitions raw partitions in InnoDB tablespace 2nd Password column (grant tables) password command PASSWORD option creating tables setting variables PASSWORD() function passwords changing 2nd encryption for login authentication. [See login authentication] for server connections 2nd load_default() function log file security on command line prompts for root password resetting 2nd setting for additional servers 2nd for anonymous accounts for root account 2nd 3rd pathnames for InnoDB tablespace specifying on Windows pattern matching PHP API query optimization 2nd Web-based applications searching example 2nd 3rd 4th when retrieving records 2nd 3rd pattern-matching operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th type conversion PEAR (PHP Extension and Add-on Repository) percent sign (%) modulo operator wild card character wildcard character 2nd 3rd performance data directory structure, effect of 2nd 3rd PHP 3 versus PHP 4 placeholders Perl DBI API selecting column types fixed-length versus variable-length types 2nd 3rd indexable types NULL versus NOT NULL types numeric versus string types 2nd smaller versus larger types 2nd selection criteria for APIs 2nd 3rd 4th 5th 6th 7th 8th performance tuning 2nd server variables InnoDB-related variables, list of 2nd list of 2nd 3rd setting 2nd 3rd performance. [See query optimization] PERIOD_ADD() function PERIOD_DIFF() function Perl DBI API 2nd 3rd 4th 5th 6th 7th 8th 9th 10th attributes 2nd database handle attributes 2nd 3rd 4th 5th dynamic attributes 2nd general handle attributes 2nd 3rd statement handle attributes 2nd 3rd 4th 5th 6th 7th 8th comments connection parameters 2nd 3rd 4th 5th 6th data validation 2nd database connections 2nd debugging with print statements 2nd 3rd with tracing 2nd 3rd 4th declaring variables 2nd directory listing example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th environment variables error handling 2nd 3rd 4th 5th 6th escaping quotation marks 2nd 3rd 4th 5th external support handles 2nd HTML document example 2nd 3rd 4th 5th member common interests example 2nd member entry editing example 2nd 3rd 4th 5th 6th 7th membership renewal example 2nd 3rd 4th 5th 6th 7th 8th memory management memory usage versus PHP methods 2nd 3rd 4th administrative methods 2nd 3rd class methods 2nd 3rd 4th 5th 6th 7th 8th 9th database handle methods 2nd 3rd 4th 5th 6th 7th 8th 9th fetching rows general handle methods 2nd statement handle methods 2nd 3rd 4th 5th 6th 7th utility functions 2nd objects operational overview 2nd 3rd 4th 5th 6th 7th 8th 9th parameter binding 2nd placeholders 2nd 3rd 4th 5th 6th portability 2nd predecessor of query execution 2nd query preparations 2nd query result processing testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th without result set 2nd references requirements result set metadata 2nd 3rd 4th 5th 6th result sets counting rows fetched fetching complete result sets 2nd 3rd 4th 5th fetching rows 2nd 3rd 4th 5th 6th 7th 8th 9th fetching single rows 2nd 3rd running scripts 2nd strengths of text manipulation transactions 2nd 3rd 4th variables Web-based applications 2nd 3rd Apache Web server setup 2nd 3rd CGI.pm Perl module 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th database browser example 2nd 3rd 4th 5th 6th MySQL server security 2nd 3rd 4th 5th score browser example 2nd 3rd 4th 5th searching example 2nd 3rd 4th 5th 6th 7th Perl modules installation on UNIX 2nd 3rd installation on Windows 2nd obtaining for installation 2nd 3rd perldoc command permissions for data directory persistent connections PHP API versus non-persistent connections PHP installation on UNIX 2nd 3rd installation on Windows obtaining for installation 2nd 3rd PHP 3 performance versus PHP 4 PHP 4 performance versus PHP 3 PHP API 2nd 3rd 4th 5th 6th 7th 8th comments in data retrieval example 2nd 3rd 4th database selections dynamic output 2nd error handling 2nd 3rd 4th 5th 6th 7th 8th 9th query failures 2nd 3rd escaping quotation marks 2nd 3rd external support file extensions functions connection management 2nd 3rd 4th 5th 6th deprecated 2nd error handling 2nd 3rd information gathering 2nd 3rd parameters 2nd queries 2nd 3rd 4th 5th 6th 7th 8th 9th result set processing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st row fetching global variables hidden fields 2nd 3rd 4th include files 2nd 3rd 4th 5th 6th 7th 8th include statement versus require statement input parameters 2nd 3rd 4th 5th 6th integer testing login authentication 2nd 3rd 4th 5th 6th 7th member entry editing example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th memory management memory usage versus Perl opening and closing tags 2nd 3rd 4th operational overview 2nd 3rd 4th 5th 6th 7th 8th 9th 10th operators === pattern matching portability 2nd predecessor of president quiz example 2nd 3rd 4th 5th 6th query result processing 2nd 3rd 4th testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th without result set 2nd register globals configuration setting server connections 2nd 3rd 4th 5th server queries 2nd standalone scripts 2nd strengths of student scores example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th switch statement syntax similarities with other languages text manipulation transactions variables 2nd PHP Extension and Add-on Repository (PEAR) PHP/FI phrase searches PI() function picking. [See selecting] PID (process ID) file in data directory pid_file variable ping command ping() Perl DBI database handle method pipe (|) bitwise OR operator placeholders Perl DBI API 2nd 3rd 4th 5th 6th plus sign (+) addition operator 2nd pointer variables. [See also handles] pointers. [See also references] port variable portability of tables 2nd selection criteria for APIs 2nd POSITION() function POSIX character classes regular expressions pound sign (#) Perl DBI comments POW() function POWER() function precedence of operators 2nd 3rd 4th PRECISION attribute Perl DBI API prefix lengths indexes prefixes indexes 2nd preg_match() PHP pattern matching prepare() Perl DBI database handle method Perl DBI queries 2nd prepare_cached() Perl DBI database handle method president quiz example PHP API 2nd 3rd 4th 5th 6th president table (U.S. Historical League example) creating 2nd 3rd preventive maintenance administration duties preventive maintenance schedules 2nd 3rd price selecting ISPs 2nd 3rd PRIMARY KEY clause PRIMARY KEY indexes 2nd PRIMARY KEY keyword creating tables PRIMARY keyword retrieving rows from tables print command print statements debugging Perl DBI API with 2nd 3rd print_error() 2nd PrintError attribute Perl DBI API Perl DBI error handling 2nd 3rd 4th 5th 6th printf() printing binary data printing binary data priorities. [See scheduling queries] privacy of user-specific option files privacy issues selecting ISPs 2nd privacy. [See security] privilege columns (grant tables) 2nd 3rd 4th 5th privileges administrative privileges (grant tables) list of 2nd 3rd avoiding risks 2nd 3rd database and table privileges (grant tables) list of 2nd displaying 2nd displaying available flushing 2nd 3rd granting 2nd 3rd 4th 5th 6th 7th allowing privilege administration 2nd hostname and username, specifying 2nd limiting resource consumption 2nd SSL connections, specifying 2nd of anonymous accounts record-level privileges lack of support for revoking 2nd 3rd 4th troubleshooting example of 2nd 3rd 4th types of 2nd 3rd 4th PRIVILEGES option flushing caches privileges. [See also grant tables] PROCEDURE ANALYSE() clause retrieving rows from tables PROCEDURE clause retrieving rows from tables PROCEDURE_ANALYSE() query optimization 2nd PROCEDURE_ANALYSE() function process ID (PID) file in data directory PROCESS privilege 2nd 3rd 4th avoiding risks process threads. [See threads] process_query() alternatives to 2nd processlist command programming MySQL APIs for 2nd 3rd C API 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 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th 99th 100th 101st 102nd 103rd 104th 105th 106th 107th 108th 109th 110th 111th 112th 113th 114th 115th 116th 117th 118th 119th 120th 121st 122nd 123rd 124th 125th 126th 127th 128th 129th 130th 131st 132nd 133rd 134th 135th 136th 137th 138th 139th 140th 141st 142nd 143rd 144th 145th 146th 147th 148th 149th 150th 151st 152nd 153rd 154th 155th 156th 157th 158th 159th 160th 161st 162nd 163rd 164th Perl DBI API 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 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th 99th 100th 101st 102nd 103rd 104th 105th 106th 107th 108th 109th 110th 111th 112th 113th 114th 115th 116th 117th 118th 119th 120th 121st 122nd 123rd 124th 125th 126th 127th 128th 129th 130th 131st 132nd 133rd 134th 135th 136th 137th 138th 139th 140th 141st 142nd 143rd 144th 145th 146th 147th 148th 149th 150th 151st 152nd 153rd 154th 155th 156th 157th APIS for Perl DBI API APIs for Perl DBI API 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 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd PHP API 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 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th APIs FOR PHP API APIs for PHP API 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 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th selection criteria 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th reasons for 2nd 3rd 4th 5th 6th 7th 8th programs list of 2nd options 2nd boolean option syntax 2nd environment variables 2nd option files 2nd 3rd 4th 5th 6th 7th SSL options, list of 2nd standard options, list of 2nd 3rd variables setting 2nd programs. [See also names of specific programs] prompt for mysql command changing 2nd PROMPT command 2nd prompt command prompts for mysql program 2nd mysql program escape sequences, list of 2nd pronunciation of MySQL pronunciation of SQL protocol_version variable ps command (UNIX) data directory location PURGE MASTER LOGS statement 2nd 3rd PURGE MASTER statement putc() printing binary data |