MYSQL in a Nutshell (In a Nutshell (OReilly))

Index

[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]

RADIANS( ) function RaiseError attribute (Perl DBI)

RAND( ) function

--raw option (mysql) READ COMMITTED option (SET TRANSACTION) READ flag (LOCK TABLES) READ function (HANDLER) READ LOCAL flag (LOCK TABLES)

READ UNCOMMITTED option (SET TRANSACTION) --read-only option (myisamchk) REAL datatype 2nd 3rd 4th REAL_AS_FLOAT option

--recover option (myisamchk) 2nd 3rd

REFERENCES keyword (CREATE TABLE) REFERENCES privilege (GRANT/REVOKE) refresh command (mysqladmin)

REGEXP operator

--regexp option (mysqlhotcopy) relational operators

--relative option (mysqladmin) RELEASE_LOCK( ) function 2nd 3rd 4th --relnotes option (mysqlaccess)

reload command (mysqladmin)

RELOAD privilege (GRANT/REVOKE)

     description

     FLUSH statement and     LOAD DATA FROM MASTER statement

     LOAD TABLE...FROM MASTER statement

RENAME TABLE statement 2nd 3rd --repair option (mysqlcheck)

REPAIR TABLE statement 2nd 3rd 4th REPEAT( ) function REPEATABLE READ option (SET TRANSACTION)

REPLACE flag

     CREATE TABLE statement

     LOAD DATA INFILE statement 2nd

--replace option (mysqlimport)

REPLACE statement

     duplicate rows and

     example

     mysql_affected_rows( ) and

     syntax 2nd

     usefulness of

REPLACE( ) function

REPLICATION CLIENT privilege (GRANT/REVOKE)

REPLICATION SLAVE privilege (GRANT/REVOKE)

RESET MASTER statement 2nd 3rd 4th

RESET SLAVE statement 2nd 3rd 4th 5th

RESET statement --resetmaster option (mysqlhotcopy)

--resetslave option (mysqlhotcopy)

RESTORE TABLE statement 2ndRESTRICT flag     CREATE TABLE statement     DROP TABLE statement     DROP VIEW statement

--result-file option (mysqldump) REVERSE( ) function REVOKE statement 2nd 3rd RFC 1321

--rhost option (mysqlaccess)

RIGHT JOIN clause RIGHT( ) function 2nd 3rd RLIKE operator

--rollback option (mysqlaccess)

ROLLBACK statement     COMMIT statement and

     syntax 2nd     transactions and     unlocking tables

ROLLBACK TO SAVEPOINT statement

rollback( ) function (Perl DBI) 2nd 3rd 4th

ROUND( ) function 2nd

RowCacheSize attribute (Perl DBI)rows

     adding

     deleting 2nd 3rd 4th     duplicate

     grouping     inserting     limiting 2nd

     ordering

     repairing

     replacing

     selecting

rows attribute (Perl DBI)

rows( ) function (Perl DBI)

RPAD( ) function 2nd

RPM format 2nd

RTREE indexes 2nd 3rd

RTRIM( ) function