MySQL Crash Course

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]

range values

    checking

         with WHERE clauses 2nd

records

     compared to rows

referential integrity, maintaining 2nd

REGEXP

     compared to LIKE operator 2nd

     LIKE operator. [See also regular expression]

         making behave as. [See also regular expression]

regular expressions

    ^

         purpose of

     basic character matching 2nd

     limitations of 2nd

    matches/matching. [See matches (regular expressions)]

     OR matches 2nd

     overview 2nd

     ranges, defining

     testing. [See also REGEXP]

     whitespace metacharacters 2nd

relational tables

     overview 2nd

RENAME TABLE statement 2nd

REPAIR TABLE

REPEAT statements

     versus LOOP statements

repition metacharacters (regular expressions) 2nd

reserved words

REVOKE statements

     user rights

     user rights, setting 2nd

right outer joins

     overview 2nd

rollbacks

     definition of

     transactions, controlling 2nd 3rd

ROLLUP

     utilizing

root

     dangers of

rows

     compared to records

     complete rows, inserting 2nd 3rd 4th

     definition of

    dublicates

         eliminating/including with UNION 2nd

    limiting retrieve results

         with LIMIT 2nd

     multiple rows, inserting 2nd

    retrieving

         with DISTINCT 2nd 3rd

RTRIM() function 2nd 3rd