Jak cię złapią, to znaczy, że oszukiwałeś. Jak nie, to znaczy, że posłużyłeś się odpowiednią taktyką.
htaccess file, 317
group( ) function, PHP, 482 htdocs folder, 450 group by clause, SELECT statement, 95, 227, 636 .htm extension, 428 grouping functions, SELECT statement, 225 .html extension, 428 GUI. See Graphical User Interface —html switch, MySQL Command-Line Interface, 150, 596 H html variable, MySQL Command-Line Interface, 144 -H switch htpassword command, 318 mysql, 596 httpd command, 450 MySQL Command-Line Interface, 150 httpd.conf, 455 -h switch Hyptertext Markup Language (HTML) mysql, 596 <form> tag, 429 MySQL Command-Line Interface, 139–140 input form example, 431–434 mysqladmin, 601 <p> tag, 431 mysqlcheck, 352, 603 static web page example, 429–431 mysqld, 608 mysqldump, 598 I mysqlimport, 605 -i switch mysqlshow, 384 myisamcheck, 354 mysqltest, 606 mysql, 596 HANDLER statement, 614–615 mysqladmin, 601 have_bdb server variable, 283 mysqlimport, 605 have_gemini server variable, 283 mysqlshow, 600 have_innodb server variable, 283 -I switch, mysqlimport, 276 have_isam server variable, 283 IA64, 12 have_raid server variable, 283 IBM Informix, 11 have_ssl server variable, 283 Id column, processlist function, 251 HAVING keyword, SELECT statement, 225 identity thief, 5 HEAP table type, 90–91, 241–242 IF( ) function, 15, 223–224 —help switch if exists statement extension, 15 mysql, 596 if not exists keyword mysqladmin, 601 CREATE DATABASE, 88 mysqlcheck, 352, 603 CREATE TABLE statement, 90 mysqld, 607 if not exists statement extension, 15 mysqlimport, 604 IF operator, 626 mysqlshow statement, 384–385 IFNULL( ) function, 223–224 mysqltest, 606 IFNULL operator, 626 4932-4 Index.F 5/29/02 3:55 PM Page 670 670 Index ✦ I–J IGNORE keyword mysqldump, 262 ALTER TABLE statement, 90, 99, 185–186 syntax, 192 INSERT statement, 92–93, 195 value exceeds column size, 192–193 LOAD DATA INFILE statement, 274–275 INSERT test application, 294 ignore statement extension, 15 INSERT...VALUES... statement, 195 —ignore switch, mysqlimport, 276, 605 install command, 77 —ignore-space, mysql, 596 installation IGNORE_SPACE mode, 609 binary, Linux environment, 45–47 image recognition, 3 binary, Mac OS X, 74–75 implementation phase, database life cycle, 129–130 binary, Windows 2000, 63–68 importing data Java Database Connectivity, 511–514 LOAD DATA INFILE statement, 274–275 MySQL Database Driver, 398–402 MySQL Command-Line Interface, 273 Perl Database Interface, 394–397 mysqlimport, 276 RPM, Linux environment, 47–48 support, 26–28 source code, Linux, 48–52 in clause, SELECT statement, 20 source code, Mac OS X, 75–76 inactive connections, mysqladmin, 84–85 insurance company customer database, 3 include( ) function, PHP, 468, 479 INT type, 645 —includedir=DIR option, MySQL source Intel libc6, 12 installation, 49 interactive mode, MySQL Command-Line Interface index, sorting, 388–389 creating tab-delimited output, 150–151 INDEX privilege, 324 displaying results vertically, 148–149 index statement extension, 15 importance of, 134–135 indexing, physical design phase, 125–128 producing HTML output, 150 INET_ATON( ) system function, 642 saving output, 148–149 INET_NTOA( ) system function, 642 semicolon, terminating commands with, 147 Info column, processlist function, 252 startup, 147 —infodir=DIR option, MySQL source installation, 49 suppressing column names, 150 —information switch, myisamcheck, 357 working with large amounts of data, 147 Informix, 8, 11 interactive_timeout server variable, 283 inherited table, 19 Internet service provider (ISP) init.d directory, 35 accounting data, 6 —init-file=, mysqld, 608 customer database, 6 InnoDB table type, 12, 90–91, 242–245 database use compared to other industries, 5 innodb_additional_mem_pool_size variable, 245 user-preference database, 6 innodb_buffer_pool_size variable, 244 INTERVAL, 627 innodb_data_file_path parameter, 243 INTO keyword, INSERT statement, 92–93, 192 innodb_data_home_dir parameter, 243 into outfile statement extension, 15 innodb_flush_log_at_trx_commit variable, 244 Invalid Option error, 340 innodb_lock_wait_timeout variable, 245 inventory-input program, e-commerce Web site innodb_log_buffer_size variable, 244 example, 436–441 innodb_log_files_in_group variable, 244 IP address, tracking usage of, 6 innodb_log_file_size variable, 244 isam logfile, 374 innodb_log_group_home_dir parameter, 243 ISAM table type, 90–91, 194, 240–241 INSERT ... SELECT ... statement, 196–197 isamchk, 241
|
Wątki
|