Managing and Using MySQL, 2nd Edition

[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

 PACK_KEYS option

 param()

 parameterized SQL

 paramstyle attribute (MySQLdb module)

parentheses ()

 in Boolean mode searches

 overriding precedence rules

 Parise, Jon

 parsing queries

 PASSWORD option

password property

 GNU JDBC driver

 twz JDBC driver

 PASSWORD() function

 authentication tokens and

 scrambling passwords in user table

 --password=my_password option

passwords

 assigning

 authentication tokens and

 avoiding storage in memory

 encrypting with crypt()

 GRANT statement and

 handling, using character arrays

 mysql_change_user() and , 2nd

 protecting, in client applications

 in security tables

 pattern matching in queries , 2nd

percent (%)

 modulo of two values

 pattern matching character , 2nd

performance

 MySQL vs. other database engines

 retrieving all rows from statement handle

 transaction isolation levels and

 performance tuning

 database servers

 EXPLAIN SELECT command and

 hardware

 host applications

 operating systems

 SQL queries

 period (.), extended regular expression

 PERIOD_ADD() function

 PERIOD_DIFF() function

 Perl

 AppConfig module

CGI module

 sample program

DBI module

 error handling and attributes

Model layer

 implementing

 Template Toolkit module

permissions

 granting and revoking

 managing users with multiple roles

 setting on data directories

 storing in separate table

 persistent connections, as performance tuning tool

 phantom reads

 PHP

 accessing MySQL DBMS with

 arrays in

 begin/end tags

 comments in scripts

 conditionals in

 DSOs (dynamic shared objects) and

 equality testing in

 include files

 installation problems

installing

 on Unix systems

 introduction to

 MySQL API reference

 MySQL library functions

 opening/using database connections

 resources for

 sessions library

 syntax of

user data

 securing

 variables in

 writing data with

 .php file extension

 installation problems and

 PHP-GTK extension, developing window-based applications

 php.ini configuration file , 2nd

 physical database design

 PI() function

plus sign (+)

 addition operator , 2nd

 in Boolean mode searches

 populate_publisher() (Publisher class) , 2nd

 port property (twz JDBC driver)

 portability, maintaining with properties files

 POSITION() function

 possible_keys column (EXPLAIN SELECT command)

 POST method and $HTTP_POST_VARS array

 PostgresSQL vs. MySQL

pound sign (#)

 comments in configuration files

 one-line comments in C

 one-line comments in PHP scripts

 POW() function

 POWER() function

 precedence rules for MySQL operators , 2nd

 prepare()

 bind variables and

 presents.php script

 previous()

 PRIMARY KEY attribute , 2nd

 EXPLAIN SELECT command and

 Primary Key utility

 primary keys

 auto-incrementing

 creating physical databases

 getByPrimaryKey() (Publisher class)

 increasing application performance

 IS_PRI_KEY() macro

 security tables and

 print statement (PHP)

 PrintError attribute

 printf() , 2nd

privileges

 GRANT statement and , 2nd

 REVOKE statement and

 security issues for managing

 tables for storing information

 PROCEDURE clause

 PROCESS privilege

 production environment

 <Emphasis>A Programmer's Introduction to PHP 4.0<Default Para Font>

properties files

 maintaining portability using

 putting configuration information in

Publisher class

 implementing

 initializing

 methods for building/executing SQL

 methods for handling WHERE clause

 Publisher.pm module

 Python

DB-API

 parameterized SQL and

 proprietary operations and