Index: P
Symbols & Numbers
| 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
Index: P
- PACK_KEYS option: 15.2. SQL Commands
- param( ): 9.2.1. Introduction to Perl CGI
- parameterized SQL: 10.1.3. Parameterized SQL
- paramstyle attribute (MySQLdb module): 20.1.1. Module Attributes
- parentheses ( )
- in Boolean mode searches: 3.9.1.3. Boolean mode
- overriding precedence rules: 3.8.1. Logical Operators
- Parise, Jon: 11.8. Where to Find Out More
- parsing queries: 5.2.2.2. EXPLAIN SELECT
- PASSWORD( ) function: 17.2.2. General Functions
- authentication tokens and: 6.3.1.1. User management
- scrambling passwords in user table: 6.1.2.2. The security tables
- PASSWORD option: 15.2. SQL Commands
- password property
- GNU JDBC driver: 13.1.2.2. Driver manager connectivity
- twz JDBC driver: 13.1.2.2. Driver manager connectivity
- --password=my_password option: 4.1.2. File Content
- passwords
- assigning: 6.1.1. User Management
- authentication tokens and: 6.3.1.1. User management
- avoiding storage in memory: 6.3.1.2. Resource protection
- encrypting with crypt( ): 11.7. Using the HTML <form> Environment
- GRANT statement and: 6.1.2.1. GRANT and REVOKE
- handling, using character arrays: 6.3.1.2. Resource protection
- mysql_change_user( ) and: 18.2. Functions
- 19.2. Functions
- protecting, in client applications: 6.3.2. Client Applications
- in security tables: 6.1.2.2. The security tables
- pattern matching in queries: 3.8.4. Pattern Matching
- 9.2.3. A Sample CGI/DBI Program
- percent (%)
- modulo of two values: 17.1.2. Arithmetic Operators
- pattern matching character: 3.8.4. Pattern Matching
- 9.1.4. Introducing Bind Variables and Optimizations
- performance
- MySQL vs. other database engines: 1.4. MySQL Features
- retrieving all rows from statement handle: 9.1.4. Introducing Bind Variables and Optimizations
- transaction isolation levels and: 8.2.2.1. Transaction isolation levels
- performance tuning: 5. Performance Tuning
- database servers: 5.3. Database Server Tuning
- EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
- hardware: 5.4. Operating System/Hardware Tuning
- host applications: 5.2.1. Host Application Tuning
- operating systems: 5.4. Operating System/Hardware Tuning
- SQL queries: 5.2.2. SQL Query Tuning
- period (.), extended regular expression: 3.8.4. Pattern Matching
- PERIOD_ADD( ) function: 17.2.2. General Functions
- PERIOD_DIFF( ) function: 17.2.2. General Functions
- Perl: 9. Perl
- AppConfig module: 9.2.3. A Sample CGI/DBI Program
- CGI module: 9.2. DBI and CGI
- MVC methodology: 9.2.2. The Model/View/Controller Methodology
- sample program: 9.2.3. A Sample CGI/DBI Program
- DBI module: 9.1. Introduction to DBI
- basic example: 9.1.1. Basic Perl Example
- error handling and attributes: 9.1.3. Error Handling and Attributes
- Model layer
- creating: 9.3.1. A Model for Relational Data
- example of use: 9.3.3. Example of the Model's Use
- implementing: 9.3.2. Implementing the Model
- Template Toolkit module: 9.2.3. A Sample CGI/DBI Program
- permissions
- granting and revoking: 6.1.2.1. GRANT and REVOKE
- managing users with multiple roles: 6.1.1. User Management
- setting on data directories: 6.2.1. Operating System Security
- storing in separate table: 6.3.1.1. User management
- persistent connections, as performance tuning tool: 5.2.1. Host Application Tuning
- phantom reads: 8.2.2.1. Transaction isolation levels
- PHP: 11. PHP
- accessing MySQL DBMS with: 11.3. Accessing the MySQL DBMS with PHP
- arrays in: 11.1.1. A Short Language Primer
- begin/end tags: 11.1. Introducing PHP
- 11.1.1. A Short Language Primer
- comments in scripts: 11.1.1. A Short Language Primer
- conditionals in: 11.1.1. A Short Language Primer
- DSOs (dynamic shared objects) and: 11.2.1.1. Installation problems
- equality testing in: 11.1.1. A Short Language Primer
- include files: 11.3.6. Include Files
- installation problems: 11.2.1.1. Installation problems
- installing: 11.2. Installing PHP
- on Microsoft Windows systems: 11.2.2. Getting Started Under Microsoft Windows
- on Unix systems: 11.2.1. Getting Started Under Unix
- introduction to: 11.1. Introducing PHP
- MySQL API reference: 18. MySQL PHP API Reference
- MySQL library functions: 11.3.4. Frequently Used MySQL Library Functions
- opening/using database connections: 11.3.2. Opening and Using a Database Connection
- resources for: 11.8. Where to Find Out More
- sessions library: 11.5. Managing Sessions
- syntax of: 11.1.1. A Short Language Primer
- user data
- decoding: 11.1. Introducing PHP
- securing: 11.4. Securing User Data
- variables in: 11.1.1. A Short Language Primer
- writing data with: 11.6. Writing Data with PHP
- .php file extension: 11.1. Introducing PHP
- installation problems and: 11.2.1.1. Installation problems
- PHP-GTK extension, developing window-based applications: 11.2. Installing PHP
- php.ini configuration file: 11.4. Securing User Data
- 11.5. Managing Sessions
- physical database design: 7.4. Physical Database Design
- PI( ) function: 17.2.2. General Functions
- plus sign (+)
- addition operator: 3.8. SQL Operators
- 17.1.2. Arithmetic Operators
- in Boolean mode searches: 3.9.1.3. Boolean mode
- populate_publisher( ) (Publisher class): 9.3.2. Implementing the Model
- 9.3.2.6. Constructors
- port property (twz JDBC driver): 13.1.2.2. Driver manager connectivity
- portability, maintaining with properties files: 13.1.3. Maintaining Portability Using Properties Files
- POSITION( ) function: 17.2.2. General Functions
- possible_keys column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT
- POST method and $HTTP_POST_VARS array: 11.4. Securing User Data
- PostgresSQL vs. MySQL: 1.4. MySQL Features
- pound sign (#)
- comments in configuration files: 4.1.2. File Content
- one-line comments in C: 15.1.3. Comments
- one-line comments in PHP scripts: 11.1.1. A Short Language Primer
- POW( ) function: 17.2.2. General Functions
- POWER( ) function: 17.2.2. General Functions
- precedence rules for MySQL operators: 3.8. SQL Operators
- 17.1.1. Rules of Precedence
- prepare( ): 9.1.1. Basic Perl Example
- bind variables and: 9.1.4. Introducing Bind Variables and Optimizations
- presents.php script: 11.3.2. Opening and Using a Database Connection
- previous( ): 13.2.1. Queries and Result Sets
- PRIMARY KEY attribute: 15.2. SQL Commands
- 15.2. SQL Commands
- EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
- Primary Key utility: 9.3.1. A Model for Relational Data
- primary keys: 3.5. Indexing
- auto-incrementing: 3.6.2. Sequence Generation
- creating physical databases: 7.4. Physical Database Design
- getByPrimaryKey( ) (Publisher class): 9.3.2. Implementing the Model
- 9.3.2.5. Primary key select method
- 9.3.3. Example of the Model's Use
- increasing application performance: 8.2.2.2. Using READ UNCOMMITTED
- IS_PRI_KEY( ) macro: 19.1. Data Types
- security tables and: 6.1.2.2. The security tables
- print statement (PHP): 11.1.1. A Short Language Primer
- PrintError attribute: 9.1.3. Error Handling and Attributes
- printf( ): 10.1.3. Parameterized SQL
- 11.1.1. A Short Language Primer
- privileges
- GRANT statement and: 6.1.2.1. GRANT and REVOKE
- 9.1.2. Setting Up the Database and Program
- REVOKE statement and: 6.1.2.1. GRANT and REVOKE
- security issues for managing: 6.1.2. Privilege Management
- tables for storing information: 6.1.2.2. The security tables
- PROCEDURE clause: 15.2. SQL Commands
- PROCESS privilege: 6.1.2.1. GRANT and REVOKE
- production environment: 6.1.1. User Management
- <Emphasis>A Programmer's Introduction to PHP 4.0<Default Para Font>: 11.8. Where to Find Out More
- properties files
- maintaining portability using: 13.1.3.1. Properties files
- putting configuration information in: 13.1.2.2. Driver manager connectivity
- Publisher class
- implementing: 9.3.2. Implementing the Model
- initializing: 9.3.2.1. The Publisher class
- methods for building/executing SQL: 9.3.2.2. Methods that build and execute SQL
- methods for handling WHERE clause: 9.3.2.3. Methods that handle WHERE clauses
- Publisher.pm module: 9.3.2. Implementing the Model
- Python: 10. Python
- DB-API: 10.1. DB-API
- 20.1. Module: MySQLdb
- connecting to databases: 10.1.1. The Database Connection
- cursors in: 10.1.2. Cursors
- database applications using: 10.3. Applied DB-API
- encapsulating SQL data types: 10.1.4. Other Objects
- parameterized SQL and: 10.1.3. Parameterized SQL
- proprietary operations and: 10.2. Proprietary Operations
Symbols & Numbers
| 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
Copyright © 2003
O'Reilly & Associates, Inc.
All Rights Reserved.