Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0

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

radio_button() function 2nd RaiseError

RaiseError attribute 2nd 3rd 4th 5th 6th 7th 8th RaiseError attribute (Perl DBI API error handling) 2nd 3rd 4th

RaiseError handle attribute (Perl DBI) RAND() function 2nd

range_alloc_block_size 2nd

range_alloc_block_size system variable

ranges of 2nd 3rd 4th

RDBMS 2nd 3rd 4th 5th 6th 7th 8th RDBMS (relational database management systems) 2nd 3rd 4th 5th 6th RDBMS, comparing with other 2nd

re-executing binary log file statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

READ COMMITTED transaction isolation level 2nd

READ UNCOMMITTED transaction isolation level 2nd

read-only access 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th read-only access locks 2nd

read-only access locks (database maintenance) 2nd 3rd 4th

read/write access 2nd 3rd 4th 5th 6th 7th read/write access locks 2nd

read/write access locks (database maintenance) 2nd read_buffer_size 2nd

read_buffer_size system variable

read_buffer_size variable 2nd

read_file() method

read_only 2nd

read_only system variable

read_rnd_buffer_size 2nd

read_rnd_buffer_size system variable

readers guide to 2nd

reading options

reading options in

REAL_AS_FLOAT SQL mode value

REAL_AS_FLOAT value 2nd

reasons for 2nd 3rd 4th 5th 6th

reasons for, customized input handling 2nd 3rd 4th

reasons for, customized output 2nd 3rd 4th

reasons for, integration 2nd 3rd 4th 5th 6th 7th 8th reasons for, SQL constraint workarounds 2nd 3rd 4th reconfiguring shared tablespaces 2nd

reconnect command

records 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th 99th 100th 101st 102nd 103rd 104th 105th 106th 107th 108th 109th 110th 111th 112th 113th 114th 115th 116th 117th records, adding to tables 2nd 3rd

records, deleting 2nd 3rd 4th 5th 6th

records, updating 2nd 3rd 4th

recovering entire databases 2nd 3rd 4th

recovering individual tables 2nd 3rd 4th

recovering InnoDB tables with foreign key relationships 2nd 3rd 4th 5th 6th

reference manuals 2nd references [See also pointers]

REFERENCES 2nd 3rd 4th REFERENCES clause 2nd

REFERENCES privilege REFERENCES privileges (grant tables)

references, qualifying

refresh command

REGEXP operator 2nd

REGEXP pattern-matching operator 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th register_globals configuration setting 2nd register_globals configuration setting (PHP API)

rehash command

RELATED() function

relational integrity, maintaining without foreign keys 2nd

relationship functions 2nd 3rd 4th 5th 6th 7th 8th relative comparison operators 2nd 3rd

relative updates versus absolute updates

relay log file contents relay log files 2nd 3rd

relay log index files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th relay logs 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

relay logs, replication slave servers 2nd

relay_log_purge 2nd

relay_log_purge system variable

relay_log_space 2nd

relay_log_space system variable

RELEASE_LOCK() function 2nd

RELOAD 2nd 3rd 4th 5th 6th 7th

reload command

RELOAD privilege 2nd 3rd

RELOAD privileges (grant tables) 2nd

relocating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd

relocating in 2nd 3rd 4th

relocation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

remove_backslashes() function

RENAME clause

RENAME TABLE 2nd 3rd RENAME TABLE clause RENAME TABLE statement 2nd

RENAME USER 2nd 3rd

RENAME USER statement renaming 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

renaming databases 2nd

renaming log files 2nd

renaming tables 2nd 3rd 4th

REPAIR TABLE 2nd 3rd

REPAIR TABLE statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

REPAIR TABLE statements 2nd 3rd 4th 5th 6th REPAIR TABLE statments

repairing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th REPEAT 2nd 3rd

REPEAT statement REPEAT() function 2nd

REPEATABLE READ transaction isolation level 2nd 3rd

REPLACE 2nd 3rd 4th 5th 6th

REPLACE statement 2nd

REPLACE() function replicate-ignore-db option replicating databases

replication (databases) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

REPLICATION CLIENT 2nd

REPLICATION CLIENT OPTION

REPLICATION CLIENT privilege REPLICATION CLIENT privileges (grant tables)

replication options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

replication servers 2nd REPLICATION SLAVE 2nd 3rd

REPLICATION SLAVE privilege REPLICATION SLAVE privileges (grant tables)

replication slave servers 2nd 3rd 4th 5th 6th

REPLICATION SLAVE statement

replication slaves 2nd

replication slaves, creating via 2nd

replication, establishing master-slave relationships 2nd 3rd 4th 5th 6th

replication, process overview 2nd

replication, support for 2nd

replication-related expiration 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

replication-related expiration (log files) 2nd 3rd 4th

representing 2nd

REQUIRE clause 2nd 3rd 4th 5th

REQUIRE clauses

REQUIRE NONE clause 2nd

REQUIRE SSL clause

REQUIRE X509 clause

require_once statement 2nd requiring secure connections 2nd 3rd 4th 5th 6th resequencing 2nd 3rd

resequencing columns 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

RESET 2nd 3rd 4th 5th 6th RESET MASTER LOGS statement 2nd

RESET statement 2nd

resetting 2nd 3rd 4th 5th 6th 7th

resource management columns 2nd 3rd

resource management columns (user tables) 2nd 3rd

resources 2nd 3rd 4th 5th 6th

restarting 2nd 3rd 4th RESTORE TABLE 2nd 3rd

RESTORE TABLE statement restricting permissions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

result set metadata 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th result set metadata usage example

result set processing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd

result set processing functions (C API) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th

result set returned SQL statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

result set returned statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th result set statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th result sets 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th

result sets, counting rows fetched

result sets, fetch loops 2nd 3rd 4th 5th 6th 7th 8th

result sets, fetching complete result sets 2nd 3rd 4th 5th

result sets, fetching single rows 2nd 3rd result sets, metadata 2nd 3rd 4th 5th 6th

result sets, NULL values 2nd

retrieving 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd retrieving BLOB/TEXT values

retrieving from multiple tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th retrieving from, calculating column values 2nd

retrieving from, date searches 2nd 3rd 4th 5th 6th 7th

retrieving from, generating summaries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

retrieving from, IS NOT NULL values 2nd

retrieving from, limiting query results 2nd 3rd

retrieving from, multiple tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

retrieving from, naming column values 2nd 3rd

retrieving from, NULL values 2nd 3rd 4th 5th

retrieving from, pattern matches 2nd

retrieving from, SELECT statements 2nd 3rd 4th

retrieving from, sorting query results 2nd 3rd 4th

retrieving from, specifying retrieval criteria 2nd 3rd 4th 5th

retrieving from, user-defined variables 2nd

RETURN 2nd 3rd

RETURN statement

REVERSE() function

REVOKE 2nd 3rd 4th 5th 6th REVOKE statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th REVOKE statements

revoking 2nd 3rd 4th

revoking privileges 2nd 3rd 4th 5th 6th rewriting subqueries as joins

rewriting subqueries as joins, matching value selections 2nd

rewriting subqueries as joins, nonmatching value selections 2nd

RIGHT JOIN clause 2nd

right joins 2nd 3rd 4th 5th 6th 7th 8th 9th

RIGHT() function

risks, avoiding 2nd 3rd 4th RLIKE pattern-matching operator

ROLLBACK 2nd 3rd 4th 5th 6th ROLLBACK statement 2nd 3rd

rollback() 2nd 3rd rollback() database handle method (Perl DBI)

rollback() method (PEAR DB module)

root accounts 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd

root accounts, database connections 2nd 3rd

root accounts, establishing in 2nd 3rd root accounts, establishing passwords 2nd 3rd 4th 5th 6th 7th 8th 9th root accounts, initial configuration of 2nd 3rd 4th 5th 6th

root accounts, privileges of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

rotate_fixed_logs.bat script

rotate_fixed_logs.sh script 2nd 3rd

rotating log files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th ROUND() function 2nd

ROUTINES

ROUTINES table (INFORMATION_SCHEMA) row fetching 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th

row storage format choices 2nd 3rd 4th 5th 6th ROW_COUNT() function

rows 2nd 3rd

rows()

rows() statement handle method (Perl DBI)

RPAD() function 2nd

rpl_recovery_rank 2nd

rpl_recovery_rank system variable

Rpl_status 2nd

Rpl_status status variable

RPM file 2nd 3rd 4th

RPM file distribution installation 2nd 3rd 4th

RPM file distributions 2nd 3rd 4th 5th 6th 7th 8th

RTF (Rich Text Format) 2nd 3rd 4th 5th 6th

RTF directories 2nd 3rd 4th

rtf_format_entry() function 2nd

RTRIM() function

running 2nd 3rd 4th 5th 6th 7th 8th running multiple servers running multiple servers, general issues of 2nd 3rd 4th 5th

running via unprivileged login accounts 2nd 3rd 4th 5th 6th 7th 8th

running, general issues of 2nd 3rd 4th 5th runtime configuration 2nd

runtime, setting at 2nd 3rd 4th