MySQL: Essential Skills

R

RADIANS function, 149

RAM

changing settings, 2324

HEAP tables, 57

query cache, 203

reallocating, 2324

status of, 210

usage of, 201

RAND keyword, 154

random function, 154

random numbers , 154

random strings, 154

records. See also rows

described, 23

dynamic, 46

inserting, 9597

modifying, 9799

removing from database, 108117

recovery process, 301311

relational databases, 3

REPAIR TABLE command, 305, 308

REPEAT function, 161

REPLACE function, 157158, 173

REPLACE INTO command, 9597, 102103

replication options, 203

replication processes, 212

replication status, 212

Report tab, 18

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

resource parameter, 267

resource pointer, 248

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

result parameter, 251

REVERSE function, 161

REVOKE function, 281282

RIGHT function, 163164

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

ROUND keyword, 152153

rounding functions, 152153

rows. See also records

described, 23

fetching, 251254, 269

locking, 60

RPAD function, 161162

RTRIM function, 162163