Index: A

Book Home

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: A

ABS( ) function: 17.2.2. General Functions

absolute( ): 13.2.1. Queries and Result Sets

absolute naming of database objects: 15.1.2. Identifiers

accessor methods: 9.3.1. A Model for Relational Data

ACOS( ) function: 17.2.2. General Functions

action.php script: 11.6. Writing Data with PHP

add routine (aggregate UDF): 14.1.2. Aggregate Functions

14.1.2.3. add

ADDDATE( ) function: 17.2.2. General Functions

addition operator (+): 3.8. SQL Operators

17.1.2. Arithmetic Operators

address book application: 8.3. Object/Relational Modeling

administration tasks: 4. Database Administration

AGAINST keyword: 3.9.1. Full Text Searching

aggregate functions: 17.2.1. Aggregate Functions

UDFs (user-defined functions): 14.1.2. Aggregate Functions

example of: 14.1.2.6. Aggregate example

aggregation relationship: 9.3.1. A Model for Relational Data

aliasing

database objects: 15.1.2. Identifiers
names in SQL statements: 3.7.2. Aliasing

ALL join type: 5.2.2.2. EXPLAIN SELECT

ALL keyword: 3.9.6. Unions

ALL PRIVILEGES privilege: 6.1.2.1. GRANT and REVOKE

ALTER privilege: 6.1.2.1. GRANT and REVOKE

ALTER TABLE statement: 3.4.2. Character Types

15.2. SQL Commands
ending transactions with: 3.9.2. Transactions

--analyze option (isamchk/myisamchk utilities): 5.2.2.3. Other options

ANALYZE TABLE statement: 15.2. SQL Commands

AND logical operator: 3.8. SQL Operators

17.1.4. Logical Operators

ANSI SQL

comments in: 15.1.3. Comments
extended by MySQL: 1.3. MySQL Design
primary keys/foreign keys: 3.5. Indexing

Apache web servers

checking for PHP support: 11.2.1. Getting Started Under Unix
document root of: 11.1. Introducing PHP
installation problems: 11.2.1.1. Installation problems
resources for: 11.8. Where to Find Out More
securing include files: 11.3.6. Include Files

apachectl script: 11.2.1.1. Installation problems

apilevel attribute (MySQLdb module): 20.1.1. Module Attributes

AppConfig model: 9.2.3. A Sample CGI/DBI Program

application logic

client/server architecture and: 8.1.1.1. Application logic
distributed architecture and: 8.1.2. Distributed Application Architecture
web architecture and: 8.1.3. Web Architecture

application servers

resource protection: 6.3.1.2. Resource protection
user management issues: 6.3.1.1. User management

applications

architecture issues: 8.1. Architecture
client/server architecture and: 8.1.1. Client/Server Architecture
connections and: 8.2.1. Connections
distributed architecture and: 8.1.2. Distributed Application Architecture
object/relational modeling and: 8.3. Object/Relational Modeling
performance tuning for: 5.2. Application Tuning
security: 6.3. Application Security
support for: 1.4. MySQL Features
transaction management and: 8.2.2. Transactions
web architecture and: 8.1.3. Web Architecture

architect role in MySQL installations: 6.1.1. User Management

architectures in database applications: 8.1. Architecture

Argerich, Luis: 11.8. Where to Find Out More

args parameter

init routine: 14.1.1.1. The init routine
main routine: 14.1.1.2. The main routine

arithmetic operators: 3.8. SQL Operators

17.1.2. Arithmetic Operators
PHP shortcuts: 11.1.1. A Short Language Primer

array definitions, editing in configuration file: 14.2.1. Simple Character Sets

arrays in PHP: 11.1.1. A Short Language Primer

mysql_fetch_array( ) and: 11.3.3. Handling Results

18.2. Functions

arraysize attribute (MySQLdb module): 20.1.5. Cursor Attributes

ASCII( ) function: 17.2.2. General Functions

Asher, David: 10. Python

ASIN( ) function: 17.2.2. General Functions

assign_stock( ) (MySQL C API example): 12.2.3. Adding Symbols

associative array access: 11.3.3. Handling Results

accessing user data: 11.4. Securing User Data
mysql_fetch_assoc( ) and: 18.2. Functions

asterisk (*)

in Boolean mode searches: 3.9.1.3. Boolean mode

extended regular expression: 3.8.4. Pattern Matching

multiplication operator: 3.8. SQL Operators

17.1.2. Arithmetic Operators

naming tables in ON clause: 6.1.2.1. GRANT and REVOKE

at sign (@)

function call prefix when using showerror( ): 11.3.5. Handling MySQL Errors
identifying users to MySQL: 6.1.2.1. GRANT and REVOKE

ATAN( ) function: 17.2.2. General Functions

attributes

accessing array data associatively: 11.3.3. Handling Results

of classes: 9.3.1. A Model for Relational Data

getter/setter methods and: 9.3.1. A Model for Relational Data

of entities: 7.1.2. Entity Attributes

choosing unique identifiers: 7.2.2. The Unique Identifier
translating into columns: 7.4. Physical Database Design

for error handling: 9.1.3. Error Handling and Attributes

of MySQLdb module: 20.1.1. Module Attributes

authentication tokens: 6.3.1.1. User management

autocommit mode in MySQL: 3.9.2. Transactions

AUTO_INCREMENT option: 3.3. Table Management

15.2. SQL Commands

is_auto_increment( ) and: 9.3.2.8. The mysql class

mysql_insert_id( ) and: 18.2. Functions

19.2. Functions

primary keys and: 3.6.2. Sequence Generation

9.3.2. Implementing the Model

autoReconnect property (GNU JDBC driver): 13.1.2.2. Driver manager connectivity

autoReX property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

AVG( ) function: 17.2.1. Aggregate Functions

grouping results: 3.7.3.3. Grouping

AVG_ROW_LENGTH option: 15.2. SQL Commands

Axmark, David: 1.2. The History of MySQL

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