Index R

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



MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net