Mysql your visual blueprint for creating open source databases- P16

Chia sẻ: Cong Thanh | Ngày: | Loại File: PDF | Số trang:4

Thêm vào BST

Báo xấu

79
lượt xem 5
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

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.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Mysql your visual blueprint for creating open source databases- P16

MYSQL: Your visual blueprint to open source database management RAND function, 121, 134 round numbers, 135 SELECT command random numbers, described, 134 row(s). See also records count rows with, 124–125 RDBMS (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–159 READ locks, 204–205 count, 124–125 GROUP BY clause and, 122 REAL column type, 43 delete, 7, 65, 90–91, 192, 236–237 INSERT command and, 88–89 record(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–137 Red 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, 241 REGEXP operator, 142 specify columns for, 80 query syntax and, 21 regular expressions, 142–143, 243 update, 7, 86, 96–97, 102–103 retrieve data from multiple tables relational databases, described, 2–3 variable-length, 188 with, 128–129 relationships, described, 30 ROWS keyword, 158 security and, 209 release notes, 14 rpm command, 8, 10 sort data with, 120–121 Reload MySQL option, 226 RMP packages, 8, 10–11, 13, 201, 244–245 strings and, 142, 144–145 remainder (%) operator, 134, 219, 242 RSA Data Security, 155 table locks and, 205 RENAME command, 55 RTRIM function, 141 USE command and, 21 RENAME TABLE command, 74, 192–193 SELECT keyword, 37 REPEAT function, 141 S semicolon (;), 18, 24, 29, 35 REPLACE command, 76 server(s). See also Apache Web server; REPLACE function, 141, 144 safe_mysqld command, 16, 174, 178 MySQL server REPLACE keyword, 156 search and replace functions, 141 described, 3, 259 Report tab, 175, 185 SECOND function, 148 list all databases on, 34 reports 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 passwords REVERSE function, 141 use of multiple, to insure data advanced, 217 availability, 30 REVOKE command, 207, 208 checksums and, 155 RIGHT function, 140, 146 version information, 19 encryption, 155, 207, 224 Server tab, 185 RIGHT JOIN clause, 131 firewalls, 226 RLIKE operator, 142, 143 Services control panel, 174, 180 importance of, 206 SESSION_USER function, 154 ROLLBACK command, 31 network access control, 206, 216 root 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 tables, 214–215 ROUND function, 97, 135 set-variable command, 194, 195 seeds, specify, 134 SGI Irix, 9 SELECT clause, 76, 95 287
INDEX SHOW COLUMNS command, 40, 52, 53 functions, 140–141, 144–145 types of, 31, 36, 75 SHOW COLUMNS FROM command, 41 mysqladmin and, 259 update rows in, 102–103 SHOW command, 6 numeric comparisons and, 139 TABLE keyword, 96 SHOW DATABASES command, 6, 19, Perl and, 242 TAN function, 135 34–35, 217 search for, 147 .tar.gz file extension, 11 SHOW GRANTS command, 207, 212–213 sub-, 140, 146–147 Task Manager, 181 SHOW INDEX command, 72 view tables which match, 40 Task Scheduler, 157, 171 SHOW STATUS command, 196, 197 SUBDATE function, 149 TCP/IP (Transmission Control SHOW TABLE STATUS command, 32, 40, Submit button, 240 Protocol/Internet Protocol), 14,19, 41 SUBSTRING function, 140, 146 179, 181, 217 SHOW TABLES command, 7, 25, 27, 32, substrings, 140, 146–147. See also strings TEMPORARY keyword, 37 37, 40 temporary tables. See also tables subtraction (-) operator, 134, 219, 242 SHOW VARIABLES command, 195, 198 described, 37 SUM function, 126–127 shutdown command, 174, 178 heap tables used as, 31 Sun Sparc systems, 8 SIN function, 135 TERMINATE BY clause, 159 SYSDATE function, 148 single quote ('), 242 terminology, overview of, 4 SYSTEM_USER function, 154 Sleepycat Software, 31 test slow queries, 20, 197 slow_queries variable, 197 T MySQL installation, 17 phpMyAdmin, 222–223 SMALLINT column type, 42 tab characters, 156, 161, 165 utilities, 10, 15 Solaris, 9 tab-delimited format, 165 text. See also TEXT column type; sort data, 55, 93, 111, 120–121, 189 table(s). See also columns; rows; specific text files SOURCE command, 25, 157, 169, 172 types editors, 26–27, 160, 198–199 space characters, 141 add columns to, 56–57 fields, 46, 114 SPACE function, 141 add rows to, 78–79 strings, compare, 111 special characters. See also specific check, for errors, 190–191 values, combine, into strings, 113 characters combine, 110 TEXT column type in MySQL regular expressions, 143 copy data between, 76, 157 add, 56 in text files, 161 copy fields from, 37 create, 46–47 spreadsheets, export data from, 164–165 corrupt, 190–191 described, 44–45 SQL (Structured Query Language). create, 6, 36–39 indexes and, 59 See also queries delete, 6, 37, 52–53 length of, 46 described, 4, 6–7, 259 delete data from, 77 table design and, 188 development of, by IBM, 6 delete rows from, 90–92 text file(s). See also log files; text SQL Server (Microsoft), 5 described, 4, 259 ASCII, 133, 141 square brackets ([]), 242 design, 188 create, 160–161 src directory, 12 display, 27 import/export, 156, 158–163, 165–167 SSL (Secure Sockets Layer), 217, 259 display data from multiple, 128–129 formats, 156, 160–161 startup options, 217 drop, 36–37 Text Import Wizard, 165 STATUS command, 17, 20, 25, 174, 175, 176 information, view, 40–41 thread_cache_size variable, 195 status information, 20, 25, 174–176, joins, 110, 130–131, 189, 258 threads. See also processes 195–196, 226 lock/unlock, 189, 204–205 caches for, 195 STD function, 127 name/rename, 38, 55, 74 described, 20, 175 S/390 systems, 8 optimize/repair, 188, 192–193 display, 175 STRCMP function, 142 plan, 30 run, 197 string(s) specify options for, 37 threads_cached variable, 197 combine text values into, 113 structure of, 172, 173 threads_created variable, 197 comparisons, 111, 142–143 temporary, 31, 37 threads_running variable, 197 encryption of, 224 288
MYSQL: Your visual blueprint to open source database management time. See also dates myisamchk and, 190 users. See also root users; usernames add/subtract, 153 MySQL server and, 4, 27,178–179 configure, 22–23 convert, 151 Oracle and, 5 storage of, in security tables, 214–215 formats, 149–152 Perl and, 242 functions, 148–149 PostgreSQL, 5 V TIME column type, 45 ps command, 183 VARCHAR columns TIME function, 148–149 security and, 217 add, 56, 57 TIME_FORMAT function, 149, 152 sockets, 217 change definition of, 54 TIMESTAMP columns start MySQL monitor under, 18 described, 44 add, 62–63 text files and, 160, 163 indexes and, 50, 51, 59 described, 45, 62, 84–85 usernames and, 22, 23, 194 table design and, 188 update, 94, 97, 107 UNIX_TIMESTAMP function, 151 variable(s). See also specific variables TIMESTAMP function, 148–150 Unknown column error, 80 display, 175, 186–187, 195–197 TIME_TO_SEC function, 151 UNLOCK TABLES command, 189, 204–205 Perl and, 242 TINYBLOB column type, 44 UNSIGNED attribute, 42, 43, 64, 66 PHP and, 218 TINYINT column type, 38, 39, 42 update. See also UPDATE command variable-length columns, 37, 44, 46, 188 TINYTEXT column type, 44 columns, 97, 104–109 variables command, 17, 174, 175, 198 TO_DAYS function, 151 rows, 7, 86, 96–97, 102–103 Variables tab, 175, 185 totals, calculate, 126–127 UPDATE command version command, 174, 177 transactions described, 96–97 VERSION function, 154 BDB tables and, 31 increment column values with, 108–109 vi (text editor), 160, 198 described, 9, 31 modify rows with, 98–103 VIEW GRANTS command, 212–213 InnoDB tables and, 31 PHP and, 237 MyISAM tables and, 31 priority settings, 96, 100 W Transmission Control Protocol/Internet security and, 209, 215 Protocol. See TCP/IP wait_timeout variable, 195, 229 table locks and, 205 trigonometry functions, 135 WEEK function, 148 timestamp columns and, 85 TRIM function, 141 WEEKDAY function, 148 update columns with, 104–109 TRUNCATE command, 92 WHERE clause use math with, 109 TRUNCATE function, 135 combine conditions in, 111, 116–117 WHERE clause and, 7 TRUNCATE keyword, 77 DELETE command and, 7 UPPER function, 97, 102, 141, 237 TYPE keyword, 31, 36 described, 76, 77, 114–115 USE command TYPE= option, 75 division operator and, 109 described, 6, 25, 35 improve performance with, 189 INSERT query and, 78 U query syntax and, 21 joins and, 110, 131 LIMIT clause and, 118–119 underscore (_), 33, 34, 40, 114, 142 USER function, 154 ORDER BY clause and, 121 unique indexes, 36, 59–61, 64, 72–73, 259 username(s). See also users Perl and, 255 UNIQUE keyword, 36, 59, 61 character restrictions on, 211 PHP and, 236 UNISIGNED keyword, 42 configuration options and, 194 row updates and, 102 UNIX DROP TABLE command and, 52 SELECT command and, 7, 110, backups and, 157, 170 MySQL monitor and, 18, 19 111, 114, 128 configuration files, 194, 198 phpMyAdmin and, 223 select rows with, 89 DB2 and, 5 privileges and, 212 specify rows with, 90, 92–94, display current values for specify, 18, 19, 207 98, 100–101 variables with, 195 view current, 20 string comparisons and, 142 install MySQL under, 8, 9, 12–13 UPDATE command and, 7, 96, 98, install Perl under, 243–244 100–107, 108, 109 log files, 200 289
INDEX WHERE keyword, 7 EDIT command and, 26–27 X while loops, 230, 233, 240, 243, 253 install MySQL under, 8, 12, 14–15 wildcard characters install Perl under, 246–247 XML (eXtensible Markup Language), 5 asterisk (*), 7, 89, 124, 208, 243 install server software on, 3, 4 count rows with, 124–125 log files, 200 Y dollar sign ($), 243 myisamchk and, 190 YEAR column type, 45 percent sign (%), 34, 40, 114, MySQLGUI and, 28 YEAR function, 148, 150 142, 152, 208 Oracle and, 5 YEAR_MONTH keyword, 149 PHP and, 224 PHP for, 221 YEARWEEK function, 148 question mark (?), 243 service management features, 174, 180 security and, 208 start MySQL server under, 16, 174, Z underscore (_), 33, 34, 40, 114, 142 180–181 ZEROFILL attribute, 42, 43 WHERE clause and, 114–115 -style line breaks, 163 .zip files, 8, 14, 28, 221, 222 Windows (Microsoft) text files and, 163 administration utilities, 175 usernames, 22 backups and, 157, 171 WinMySQLadmin, 15, 16, 175, 181, configuration files, 194, 199 184–185, 199 DB2 and, 5 Winsock standard, 14, 181 display current values for WinZIP, 28 variables with, 195 WRITE locks, 204–205 290