Mysql your visual blueprint for creating open source databases- P16

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.
Nội dung trích xuất từ tài liệu:
Mysql your visual blueprint for creating open source databases- P16 MYSQL: Your visual blueprint to open source database managementRAND function, 121, 134 round numbers, 135 SELECT commandrandom numbers, described, 134 row(s). See also records count rows with, 124–125RDBMS (relational database management auto-increment columns and, 65 described, 7, 110–111 systems), 2–3. See also DBMSs combine, into a single row, 122 display data with, 112–113 (database management systems) copy, 88 export data with, 158–159READ locks, 204–205 count, 124–125 GROUP BY clause and, 122REAL column type, 43 delete, 7, 65, 90–91, 192, 236–237 INSERT command and, 88–89record(s). See also rows described, 4, 259 INTO OUTFILE option, 156, 159, delete, 236–237, 255 fixed-length, 188 162, 165, 167 described, 4 insert, 7, 78–79, 82, 88–89 LIMIT clause and, 110, 118–119 insert, 234–235, 238–239, 254 limit the number of, 37, 110 math functions and, 136–137Red Hat Linux. See also Linux modify, 98–101 multiple clauses used with, 123 install MySQL on, 8 numbers for, 118 MySQLGUI and, 132 log files and, 201 replace existing, 86–87 Perl and, 253 RPM format, 8, 10 retrieve, 7 PHP and, 224, 230–231, 240, 241REGEXP operator, 142 specify columns for, 80 query syntax and, 21regular expressions, 142–143, 243 update, 7, 86, 96–97, 102–103 retrieve data from multiple tablesrelational databases, described, 2–3 variable-length, 188 with, 128–129relationships, described, 30 ROWS keyword, 158 security and, 209release notes, 14 rpm command, 8, 10 sort data with, 120–121Reload MySQL option, 226 RMP packages, 8, 10–11, 13, 201, 244–245 strings and, 142, 144–145remainder (%) operator, 134, 219, 242 RSA Data Security, 155 table locks and, 205RENAME command, 55 RTRIM function, 141 USE command and, 21RENAME TABLE command, 74, 192–193 SELECT keyword, 37REPEAT function, 141 S semicolon (;), 18, 24, 29, 35REPLACE command, 76 server(s). See also Apache Web server;REPLACE function, 141, 144 safe_mysqld command, 16, 174, 178 MySQL serverREPLACE keyword, 156 search and replace functions, 141 described, 3, 259Report tab, 175, 185 SECOND function, 148 list all databases on, 34reports secondary keys, described, 30. See also programming languages and, 3 keys; primary keys reconnection attempts, 25 create, 175 SEC_TO_TIME function, 151 software for, 3, 16–17 edit, 185 Secure Sockets Layer. See SSL (Secure status information, 17 print, 185 Sockets Layer)return keyword, 219 storage of tables on, 38 security. See also passwordsREVERSE function, 141 use of multiple, to insure data advanced, 217 availability, 30REVOKE command, 207, 208 checksums and, 155RIGHT function, 140, 146 version information, 19 encryption, 155, 207, 224 Server tab, 185RIGHT JOIN clause, 131 firewalls, 226RLIKE operator, 142, 143 Services control panel, 174, 180 importance of, 206 SESSION_USER function, 154ROLLBACK command, 31 network access control, 206, 216root users. See also usernames; users SET column type, 45, 48–49 overview of, 30, 207–217 SET keyword, 96, 98 create, 22 PHP and, 226 DROP TABLE command and, 52 SET PASSWORD command, 210–211, 215 privileges and, 207, 208–209, sets, described, 48–49 installation and, 13, 22 212–216, 234, 259 MySQL server and, 132 Setup Wizard, 246, 247 risks, 206 passwords for, 23, 207 setup.exe, 14 tab ...