Mysql your visual blueprint for creating open source databases- P16:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database. | MYSQL Your visual blueprint to open source database management RAND function 121 134 random numbers described 134 RDBMS relational database management systems 2-3. See also DBMSs database management systems READ locks 204-205 REAL column type 43 record s . See also rows delete 236-237 255 described 4 insert 234-235 238-239 254 Red Hat Linux. See also Linux install MySQL on 8 log files and 201 RPM format 8 10 REGEXP operator 142 regular expressions 142-143 243 relational databases described 2-3 relationships described 30 release notes 14 Reload MySQL option 226 remainder operator 134 219 242 RENAME command 55 RENAME TABLE command 74 192-193 REPEAT function 141 REPLACE command 76 REPLACE function 141 144 REPLACE keyword 156 Report tab 175 185 reports create 175 edit 185 print 185 return keyword 219 REVERSE function 141 REVOKE command 207 208 RIGHT function 140 146 RIGHT JOIN clause 131 RLIKE operator 142 143 ROLLBACK command 31 root users. See also usernames users create 22 DROP TABLE command and 52 installation and 13 22 MySQL server and 132 passwords for 23 207 ROUND function 97 135 round numbers 135 row s . See also records auto-increment columns and 65 combine into a single row 122 copy 88 count 124-125 delete 7 65 90-91 192 236-237 described 4 259 fixed-length 188 insert 7 78-79 82 88-89 limit the number of 37 110 modify 98-101 numbers for 118 replace existing 86-87 retrieve 7 specify columns for 80 update 7 86 96-97 102-103 variable-length 188 ROWS keyword 158 rpm command 8 10 RMP packages 8 10-11 13 201 244-245 RSA Data Security 155 RTRIM function 141 S safe_mysqld command 16 174 178 search and replace functions 141 SECOND function 148 secondary keys described 30. See also keys primary keys SEC_TO_TIME function 151 Secure Sockets Layer. See SSL Secure Sockets Layer security. See also passwords advanced 217 checksums and 155 encryption 155 207 224 firewalls 226 importance of 206 network access control 206 216 overview of .
