R
RAM
changing settings, 2324
HEAP tables, 57
query cache, 203
reallocating, 2324
status of, 210
usage of, 201
records. See also rows
described, 23
dynamic, 46
inserting, 9597
modifying, 9799
removing from database, 108117
REPAIR TABLE command, 305, 308
REPLACE function, 157158, 173
REPLACE INTO command, 9597, 102103
replication processes, 212
reporting
advanced, 141190
basic, 119139
data customization, 120125
GROUP BY clause, 176183
MySQL functions for, 142176
ORDER By clause, 176177, 181183
ordering/grouping data, 176183
refining data selection, 126138
report creation, 129138, 169176
SELECT command, 120125
SELECT...WHERE command, 129138
WHERE clause, 126129
reserved words, 54, 325327
resources
managing, 207
MySQL, 3537
PHP, 330
user , 207
restore procedure, 301311
RESTORE TABLE command, 302, 309
restoring items
databases, 301311
procedure for, 301311
settings for, 214215
tables, 302, 307311
RIGHT JOIN function, 185187, 190
root password
grant tables and, 204
resetting on Linux, 279
resetting on Windows, 278279
root user
Linux systems, 27
Windows systems, 14
rounding functions, 152153
rows. See also records
described, 23
fetching, 251254, 269
locking, 60