MySQL Cookbook

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] [X] [Y]

-p (password) option 2nd

     option files and

<p> HTML paragraph tag

p( ) CGI.pm method (Perl)

page accesses, logging

page scope (JSP)

pageContext object (JSP)

PAGER environment variable

pager option

PageTemplate 2nd

     list generation

     paragraph generation

     table generation

paragraph text, displaying query results as

param( ) function (Perl)

parameters

     connection

     mixing command-line and option file

     option files, getting

parent-child relationships for tables

parentheses (( )), matching patterns 2nd

parsers (XML)

--password option

password parameter (Java)

passwords

     option files and

     option syntax forms for

     parameters from the command line, getting

     setting up

     starting and stopping mysql

path <Context> attribute

PATH environment variable 2nd

     finding mysql 2nd

     writing shell scripts

pathnames

     datafile locations, specifying

     finding pathnames

     specifying in option files

pattern constructor (/.../) (Perl)

pattern matching

     broad content types

     case-sensitivity, controlling

     FULLTEXT searches and

     regular expressions and

     validating data and

PEAR (PHP Extension and Add-on Repository) 2nd 3rd

     transactions and

PEAR DB connect( ) method

PEAR::isError( ) method (PHP) 2nd

per-group descriptive statistics

percent sign (%), as a format specifier

Perl

     checkboxes, creating

     command-line arguments

     connecting, selecting and disconnecting to databases

     Content-Type: header, producing

     converting to different formats

     CPAN

     duplicate-finding queries

     error checking

     executing scripts

     export programs and

     exporting XML

     forms, generating

     generating unique table names

     hyperlinks, displaying from query results

     input parameters

     median calculation and

     modules

     nested lists (HTML), generating from query results

     NULL values and

     obtaining the number of rows affected by statements

     option files and

     ordered lists (HTML), generating from query results

     PERL5LIB environment variable and

     result set metadata, obtaining

     retrieving sequence values and

     sending/retrieving results

     sessions

     special characters and NULL values, handling

     special characters, encoding

     specifying column delimiters with

     SQL pattern characters, escaping

     transactions

     uploads

     web scripts

PERL5LIB environment variable 2nd

perldoc warnings command

perror program

PHP 2nd

     connecting, selecting and disconnecting to databases

     definition lists, generating

     error checking

     executing scripts

     forms, generating 2nd

     generating unique table names

     HTML and

     input parameters and

     library files

         installing

     NULL values and

     obtaining the number of rows affected by statements

     option files

     ordered lists, displaying query results

     paragraph text, encoding

     result set metadata, obtaining

     retrieving sequence values

    sessions

         opening/closing

     sessions manager

     Smarty template package

     special characters and NULL values, handling

     special characters, encoding

     SQL pattern characters, escaping

     statements, sending and retrieving

     transactions

     uploads

PHP Extension and Add-on Repository (PEAR)

PHP variables

     $_GET

     $_HTTP_GET_VARS

     $_POST

     $_SERVER

     $_SESSION

     $HTTP_SERVER_VARS

     $HTTP_SESSION_VARS

     include_path 2nd 3rd

     magic_quotes_gpc

     register_globals 2nd

     track_vars 2nd

php.ini file 2nd

phpMyAdmin

phrase searches (FULLTEXT)

PID (Process ID) values

pipe (|)

     alternation, pattern matching

     copying tables/databases to different servers

     output, sending to files/programs

     reading statements from other programs

placeholders 2nd

     Perl DBI scripts and

     Ruby DBI and

plus sign (+), matching patterns

     Perl

.pm extension (Perl modules)

point-and-click interface

pop-up menus (HTML)

popup_menu( ) function (JSP)

POSIX character classes

POST requests 2nd

PostgreSQL

ppm utility

PRECISION attribute

precision Ruby member name

prefix values (Tomcat)

prepare( ) method

     Perl 2nd

         result set metadata, obtaining

     PHP

prepare( ) method (Perl)

prepareStatement( ) method (Java)

"previous-page" links, generating

PRIMARY KEY index 2nd

     preventing duplicates in tables

primary Ruby member name

PrintError attribute (Perl) 2nd

printErrorMessage( ) method (Java)

privileges for stored routines

Process ID (PID) values

protocol designator

--protocol=tcp option

Python

     command-line arguments

     connecting, selecting and disconnecting to database

     error checking

     executing scripts

     forms, generating 2nd

     generating unique table names

     hyperlinks, displaying from query results

     library files

     NULL values and

     obtaining the number of rows affected by statements

     option files and

     paragraphs, encoding query results with

     result set metadata, obtaining

     retrieving sequence values

     special characters and NULL values, handling

     SQL pattern characters, escaping

     statements, sending and retrieving

     transactions

     uploads

     web scripts

PYTHONPATH environment variable 2nd 3rd