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]

R

 \r escape sequence (MySQL)

 RADIANS() function

 RaiseError attribute

 RAND() function , 2nd

 range join type

 Rawat, Harish

 READ COMMITTED transaction isolation level

 read local locks

 read locks

 READ UNCOMMITTED transaction isolation level

 REAL data type , 2nd  , 3rd

 return value for user-defined functions

 REAL_RESULT type

 --recover option

recovery

 from backups

 from crashes

 recursive relationships

RedHat Package Manager (RPM)

 adding PHP and MySQL support

 installing MySQL using

 mysql-log-rotate script

 mysql.server script

 redirecting web browsers , 2nd

 redundancy in databases , 2nd  , 3rd

 Reese, George , 2nd

 ref column (EXPLAIN SELECT command)

 ref join type

 REFERENCES attribute

 REFERENCES privilege

 referencing database objects

 refreshing system operations

 REGEXP operator

 regular expressions in queries , 2nd

 relational databases

 history of

 object-oriented applications and

 relational joins

 relationships for entities

 refining

 translating into physical data model

 types of

 relationships involving aggregation or containment

 relative naming of database objects

 relative()

 RELEASE_LOCK() function

 relevance values of query results

 RELOAD privilege

 remove method (Model class)

 remove() (Publisher class) , 2nd

 RENAME statement

RENAME TABLE statement

 ending transactions with

 --repair option

 repairing table errors

 REPEAT() function

 REPEATABLE READ transaction isolation level

 repeatable reads

 REPLACE keyword

 REPLACE statement

 REPLACE() function

 reset routine (aggregate UDF) , 2nd

 resource protection by application servers

resources

 for Apache web servers

 for PHP

 result parameter (main routine)

result sets and queries

 JDBC

 MySQL C API

 PHP

 scrollable result sets

 user-defined functions

 ResultSet interface , 2nd

 ResultSetMetaData interface

return values

 init routine

 main routine

 REVERSE() function

 REVOKE statement

 privilege management and

 RIGHT() function

 RLIKE operator , 2nd

roles

 multiple, on MySQL servers

 used in MySQL installations

 ROLLBACK command

 rollback() (MySQLdb module)

 root access, installing MySQL with , 2nd

 root user

 assigning password to

 network security issues

 security risks and

 values from user table

 rotating logs

 ROUND() function , 2nd

 ROW_FORMAT option

 rowcount attribute (MySQLdb module)

rows

 adding to tables , 2nd

 deleting , 2nd

 fetching , 2nd  , 3rd  , 4th

 grouping

 limiting query results

 scrollable result sets and

 sequence generation for primary keys

 rows column (EXPLAIN SELECT command)

 RPAD() function

RPM (RedHat Package Manager)

 adding PHP and MySQL support

 installing MySQL using

 mysql-log-rotate script

 mysql.server script

 rpm utility, installing packages with

 RSLock property (twz JDBC driver)

 RTRIM() function