[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 Rai Perl DBI API [See rror attribute] Perl DBI error handling [See rror attribute]2nd [See rror attribute]3rd [See rror attribute]4th [See rror attribute]5th [See rror attribute]6th [See rror attribute] RAID CHUNKS option creating tables RAID CHUNKSIZE option creating tables RAID TYPE option creating tables RAND() PHP president quiz example retrieving results in random order 2nd RAND() function 2nd random order retrieving results in 2nd raw partitions in InnoDB tablespace 2nd RDBMSs (relational database management systems) 2nd READ COMMITTED option setting transaction isolation level READ LOCAL locks read locks 2nd READ locks read locks on all databases 2nd versus write locks READ UNCOMMITTED option setting transaction isolation level read_buffer_size variable 2nd 3rd 4th read_rnd_buffer_size variable rebuilding indexes 2nd record-level privileges lack of support for record_buffer variable record_rnd_buffer variable records deleting 2nd 3rd 4th 5th inserting 2nd 3rd 4th 5th 6th retrieving 2nd 3rd 4th calculating columns with expressions 2nd from multiple tables 2nd 3rd 4th 5th 6th 7th 8th 9th generating summaries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th limiting results 2nd 3rd NULL value 2nd 3rd pattern matching 2nd 3rd restriction criteria 2nd 3rd 4th 5th setting variables 2nd sorting results 2nd 3rd 4th with date values 2nd 3rd 4th 5th 6th 7th updating 2nd recovery. [See disaster recovery] references Perl DBI API REFERENCES clause creating tables REFERENCES keyword REFERENCES privilege 2nd 3rd referential integrity 2nd 3rd 4th 5th alternatives to foreign keys 2nd refresh command REGEXP pattern-matching operator 2nd 3rd 4th 5th 6th register globals configuration setting PHP API regular expression pattern matching 2nd 3rd 4th 5th regular expressions pattern matching 2nd rehash command relational database management systems (RDBMSs) 2nd relative updates versus absolute updates 2nd RELAY LOG FILE option replication servers RELAY LOG POS option replication servers relay logs replication RELEASE_LOCK() function 2nd 3rd reload command RELOAD privilege 2nd 3rd avoiding risks 2nd reloading grant tables 2nd 3rd relocated databases removing relocating data directory 2nd 3rd 4th 5th database relocation 2nd 3rd determining effect of 2nd InnoDB tablespace relocation 2nd status and log file relocation 2nd table relocation 2nd warning about removing relocated databases RENAME clause altering tables RENAME TABLE statement 2nd renaming databases 2nd log files 2nd 3rd tables 2nd 3rd REPAIR TABLE statement 2nd 3rd 4th 5th repair utilities. [See table repair utilities] repairing tables 2nd 3rd 4th 5th 6th 7th coordinating with server 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th with CHECK TABLE and REPAIR TABLE statements 2nd 3rd with myisamchk utility 2nd 3rd 4th 5th 6th 7th REPEAT() function REPEATABLE READ option setting transaction isolation level REPLACE statement 2nd 3rd REPLACE() function replication database replication administration duties REPLICATION CLIENT privilege 2nd 3rd replication options mysqld server 2nd 3rd 4th replication servers 2nd 3rd backing up databases 2nd parameters changing 2nd setting up master-slave relationship 2nd 3rd 4th REPLICATION SLAVE privilege 2nd 3rd 4th replication-related log files expiration 2nd reputation selecting ISPs REQUIRE clause granting privileges 2nd 3rd 4th 5th 6th require statement (PHP API) versus include statement (PHP API) require_once statement (PHP API) requirements Perl DBI API sample database 2nd selecting ISPs 2nd requirements. [See system requirements]2nd [See system requirements] resequencing AUTO_INCREMENT columns 2nd RESET MASTER LOGS statement RESET MASTER option flushing caches RESET MASTER statement RESET QUERY CACHE statement RESET SLAVE option flushing caches RESET statement 2nd resorting indexes resource consumption limiting 2nd resource management columns (grant tables) 2nd 3rd restarting server when unable to connect 2nd 3rd RESTORE TABLE statement 2nd 3rd 4th restoring tables 2nd 3rd 4th restoring. [See also disaster recovery] RESTRICT keyword dropping tables result buffer pointers troubleshooting result identifiers PHP API result set metadata 2nd 3rd 4th 5th Perl DBI API 2nd 3rd 4th 5th 6th result set processing functions C API 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th PHP API 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st result sets Perl DBI API counting rows fetched fetching complete result sets 2nd 3rd 4th 5th fetching rows 2nd 3rd 4th 5th 6th 7th 8th 9th fetching single rows 2nd 3rd result sets. [See also queries] results of queries processing (Perl DBI API) testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th without result set 2nd processing (PHP API) 2nd 3rd 4th testing for NULL values 2nd with result set 2nd 3rd 4th 5th 6th without result set 2nd retrieving records 2nd 3rd 4th calculating columns with expressions 2nd from multiple tables 2nd 3rd 4th 5th 6th 7th 8th 9th generating summaries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th limiting results 2nd 3rd NULL value 2nd 3rd pattern matching 2nd 3rd restriction criteria 2nd 3rd 4th 5th setting variables 2nd sorting results 2nd 3rd 4th with date values 2nd 3rd 4th 5th 6th 7th rows from tables 2nd 3rd 4th 5th 6th RETURNS clause creating functions REVERSE() function REVOKE statement 2nd 3rd 4th operational overview 2nd revoking privileges 2nd 3rd 4th Rich Text Format (RTF) document control language 2nd 3rd 4th RIGHT JOIN keyword retrieving rows from tables right joins 2nd 3rd 4th RIGHT() function RLIKE pattern-matching operator ROLLBACK statement 2nd 3rd 4th 5th 6th rollback() Perl DBI database handle method Perl DBI transactions 2nd rolling back transactions 2nd root account passwords, setting 2nd 3rd warning against running server as root accounts security implications in Windows root password resetting 2nd rotation of log files 2nd 3rd ROUND() function rounding floating-point numbers routines. [See functions] ROW FORMAT option creating tables row-fetching functions PHP API rows() Perl DBI result sets Perl DBI statement handle method RPAD() function rpl_recovery_rank variable RPM MySQL distributions 2nd installation 2nd 3rd RTF (Rich Text Format) document control language 2nd 3rd 4th RTRIM() function running Perl scripts 2nd running. [See starting] |