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

\r escape sequence (MySQL): 15.1.1. Literals

RADIANS( ) function: 17.2.2. General Functions

RaiseError attribute: 9.1.3. Error Handling and Attributes

RAND( ) function: 3.9.4. Functions

17.2.2. General Functions

range join type: 5.2.2.2. EXPLAIN SELECT

Rawat, Harish: 11.8. Where to Find Out More

READ COMMITTED transaction isolation level: 8.2.2.1. Transaction isolation levels

read local locks: 3.9.3. Table Locking

read locks: 3.9.3. Table Locking

READ UNCOMMITTED transaction isolation level: 8.2.2.1. Transaction isolation levels

REAL data type: 3.4. MySQL Data Types

16.1. Numeric Data Types

19.1. Data Types

return value for user-defined functions: 14.1.1.2. The main routine

REAL_RESULT type: 14.1.1.2. The main routine

--recover option: 4.6.2. Repairing a Table

recovery

from backups: 4.5. Recovery

from crashes: 4.6. Table Maintenance and Crash Recovery

recursive relationships: 7.2.3. Relationships

RedHat Package Manager (RPM)

adding PHP and MySQL support: 11.2.1. Getting Started Under Unix

installing MySQL using: 2.2.2. Binary (RPM) Distributions

mysql-log-rotate script: 4.3.4. Log Rotation

mysql.server script: 4.2.1.1. SVR4

redirecting web browsers: 11.5. Managing Sessions

11.6. Writing Data with PHP

redundancy in databases: 5.2.1. Host Application Tuning

7.1. Database Design Primer

7.2. Normalization

Reese, George: 13. Java

13.2.1. Queries and Result Sets

ref column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT

ref join type: 5.2.2.2. EXPLAIN SELECT

REFERENCES attribute: 15.2. SQL Commands

REFERENCES privilege: 6.1.2.1. GRANT and REVOKE

referencing database objects: 15.1.2. Identifiers

refreshing system operations: 19.2. Functions

REGEXP operator: 3.8.4. Pattern Matching

regular expressions in queries: 3.8.4. Pattern Matching

9.2.3. A Sample CGI/DBI Program

relational databases: 1.1. Relational Databases

history of: 3.1.1. The SQL Story

object-oriented applications and: 8.3. Object/Relational Modeling

relational joins: 1.1. Relational Databases

relationships for entities: 7.2.3. Relationships

refining: 7.2.6. Refining Relationships

translating into physical data model: 7.4.2. Foreign Keys

types of: 7.2.5. Kinds of Relationships

relationships involving aggregation or containment: 9.3.1. A Model for Relational Data

relative( ): 13.2.1. Queries and Result Sets

relative naming of database objects: 15.1.2. Identifiers

RELEASE_LOCK( ) function: 17.2.2. General Functions

relevance values of query results: 3.9.1.2. Relevance values

RELOAD privilege: 6.1.2.1. GRANT and REVOKE

remove method (Model class): 9.3.1. A Model for Relational Data

remove( ) (Publisher class): 9.3.2. Implementing the Model

9.3.2.2. Methods that build and execute SQL

RENAME statement: 15.2. SQL Commands

RENAME TABLE statement

ending transactions with: 3.9.2. Transactions

--repair option: 4.6.2. Repairing a Table

repairing table errors: 4.6.2. Repairing a Table

REPEAT( ) function: 17.2.2. General Functions

REPEATABLE READ transaction isolation level: 8.2.2.1. Transaction isolation levels

repeatable reads: 8.2.2.1. Transaction isolation levels

REPLACE( ) function: 17.2.2. General Functions

REPLACE keyword: 3.9.7.2. The LOAD command

REPLACE statement: 15.2. SQL Commands

reset routine (aggregate UDF): 14.1.2. Aggregate Functions

14.1.2.2. reset

resource protection by application servers: 6.3.1.2. Resource protection

resources

for Apache web servers: 11.8. Where to Find Out More

for PHP: 11.8. Where to Find Out More

result parameter (main routine): 14.1.1.2. The main routine

result sets and queries

JDBC: 13.2.1. Queries and Result Sets

MySQL C API: 12.1.2. Queries and Results

PHP: 11.3.3. Handling Results

scrollable result sets: 13.2.1. Queries and Result Sets

user-defined functions: 14.1. User-Defined Functions

ResultSet interface: 13.2.1. Queries and Result Sets

13.3.1. Metadata

ResultSetMetaData interface: 13.3.1. Metadata

return values

init routine: 14.1.1.1. The init routine

main routine: 14.1.1.2. The main routine

14.1.1.2. The main routine

REVERSE( ) function: 17.2.2. General Functions

REVOKE statement: 15.2. SQL Commands

privilege management and: 6.1.2.1. GRANT and REVOKE

RIGHT( ) function: 17.2.2. General Functions

RLIKE operator: 3.8.4. Pattern Matching

9.2.3. A Sample CGI/DBI Program

roles

multiple, on MySQL servers: 6.1.1. User Management

used in MySQL installations: 6.1.1. User Management

ROLLBACK command: 3.9.2. Transactions

rollback( ) (MySQLdb module): 20.1.4. Connection Methods

root access, installing MySQL with: 2.1. Preparation

3.1.3. Sending SQL to MySQL

root user: 6.1.1. User Management

assigning password to: 6.1.2.1. GRANT and REVOKE

network security issues: 6.2.3.3. Direct compromise

security risks and: 6.1.1. User Management

values from user table: 6.1.2.2. The security tables

rotating logs: 4.3.4. Log Rotation

ROUND( ) function: 3.9.4. Functions

17.2.2. General Functions

rowcount attribute (MySQLdb module): 20.1.5. Cursor Attributes

ROW_FORMAT option: 15.2. SQL Commands

rows

adding to tables: 3.6.1. Inserts

13.2. Simple Database Access

deleting: 3.6.5. Deletes

6.1.2.1. GRANT and REVOKE

fetching: 10.1.2. Cursors

11.3.3. Handling Results

12.2.2. Quote Retrieval

19.2. Functions

grouping: 3.7.3.3. Grouping

limiting query results: 3.7.4. Limiting Results

scrollable result sets and: 13.2.1. Queries and Result Sets

sequence generation for primary keys: 3.6.2. Sequence Generation

rows column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT

RPAD( ) function: 17.2.2. General Functions

RPM (RedHat Package Manager)

adding PHP and MySQL support: 11.2.1. Getting Started Under Unix

installing MySQL using: 2.2.2. Binary (RPM) Distributions

mysql-log-rotate script: 4.3.4. Log Rotation

mysql.server script: 4.2.1.1. SVR4

rpm utility, installing packages with: 2.2.2. Binary (RPM) Distributions

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

RTRIM( ) function: 17.2.2. General Functions

Copyright © 2003 O'Reilly & Associates, Inc. All Rights Reserved.