MySQL, Second Edition

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] [Z]

-p option 2nd 3rd 4th

pagination

parameters

     configuration

     IN 2nd

     InnoDB

     MyISAM

     optional

     OUT

PASSWORD() function 2nd 3rd

passwords

     case sensitivity 2nd

     changing 2nd 3rd

     encryption and 2nd

     forgetting/misplacing

     guidelines for

     Java

     length of

     old vs. new algorithm

     Perl and

     problems with

     resetting

     root user 2nd 3rd 4th 5th 6th

     root user, Windows 2nd

     users 2nd 3rd

pathnames 2nd

Pearl Package Manager (PPM) 2nd

performance

     column selection

     improving

     indexes and

     normalization and

     storage engines

Perl

     database connections 2nd

     errors 2nd 3rd

     Mac OS support for

     passwords

     permissions 2nd 3rd

     prepared statements

     resources 2nd

     retrieving insert ID

     retrieving query results

     security 2nd

     simple queries

     testing

     transactions in

     Unix support for

     versions 2nd 3rd

     Web sites 2nd

     Windows support for

perl -v command 2nd

Perl home page

Perl scripts 2nd

permissions [See also privileges.]

     Java

     Linux systems

     Perl 2nd 3rd

     scripts

     stored routines and

     users 2nd 3rd

PHP

     connector package

     database connections

     error handling

     executing queries

     forms

     Magic Quotes

     mysqli_insert_id() function

     query result pages

     resources

     retrieving query results

     security

     troubleshooting

     versions

PHP home page

php.ini file

PHP.net Web site

PHPBuilder Web site

phpMyAdmin software 2nd 3rd

phpWizard.net

.pl extension

Planet MySQL

$_POST array

PostgreSQL

POW() function 2nd

PPM (Pearl Package Manager) 2nd

prefix option 2nd

prepare() method

prepare() statement

prepared statements

     Java

     Perl

PreparedStatement type

PRIMARY KEY index

primary keys

     2NF compliancy and

     described

     establishing

     example of

     logical

     names

     NULL values and

     relational databases and

     relationships with foreign keys

     rules for

     updating and

PrintError 2nd

privileges [See also permissions; specific privileges.]

     administrative

     basic

     described

     displaying

     modifying

     newer versions

     revoking 2nd

     users 2nd

proc table

PROCESS privilege 2nd 3rd

programming

     cursors and

     debugging query problems

     performing transactions with Perl

     query result pages

     simple queries 2nd

     storing/retrieving binary data

     strict 2nd

pull-down menus 2nd