Jak cię złapią, to znaczy, że oszukiwałeś. Jak nie, to znaczy, że posłużyłeś się odpowiednią taktyką.
See Entity-Relationship Diagram
—extended-insert switch, mysqldump, 262, 265, 598 err( ) method, Perl Database Interface, 413–414 extended-status function, mysqladmin, 248, 251, 602 .err file extension, 374 extensible index type, 19 err-log option, MySQL configuration file, 374–375 extensions, MySQL, 13–16 error Access Denied, 99, 158–159, 333–334 F Invalid Option, 340 -F switch error log, 374 myisamcheck, 354 errstr( ) method, Perl Database Interface, 413–414 mysqlcheck, 354, 603 ESCAPE keyword, LIKE function, 219 mysqldump, 598 excel2mysql conversion tool, 27 -f switch exclusion constraint, logical design phase, 119–120 myisamcheck, 354, 361 —exec- prefix=DIR option, MySQL source mysql, 596 installation, 49 MySQL Command-Line Interface, 150 execute( ) method mysqladmin, 601 Java Database Connectivity, 515 mysqlcheck, 603 Perl Database Interface, 415–416 mysqldump, 598 —execute switch, MySQL Command-Line Interface, mysqlimport, 604 135, 596 —fast switch executeBatch( ) method, Java Database myisamcheck, 357 Connectivity, 515 mysqlcheck, 354, 603 executeQuery( ) method, Java Database fetchall_arrayref function, Perl Database Connectivity, 515 Interface, 417 executeUpdate( ) method, Java Database fetchrow( ) function, Perl Database Interface, 417 Connectivity, 515 fetchrow_array( ) function, Perl Database Interface, exit command, MySQL Command-Line Interface, 146 417–418 EXPLAIN command, 126, 386, 614 fetchrow_arrayref( ) function, Perl Database explain select statement, 14 Interface, 417–419 exploit, 305 fetchrow_hashref( ) function, Perl Database exporting data Interface, 417–419 comments, 260 Fibernet, 558 creating backup, 348–349 FIELD( ) string functions, 213, 219–220 dropping tables, 264–265 field padding, 235 dumping databases, 268–271 4932-4 Index.F 5/29/02 3:55 PM Page 668 668 Index ✦ F–G FIELDS ENCLOSED BY option, SELECT INTO OUTFILE FORMAT( ) function, 15, 210–211 statement, 271 FORMAT( ) system function, 641 FIELDS ESCAPED BY option, SELECT INTO OUTFILE forName( ) method, Java Database Connectivity, 514 statement, 271 /* (enclosing non-standard extensions in), 13 —fields switch, mysqldump, 267 FOUND_ROWS( ) system function, 641 FIELDS TERMINATED BY option, SELECT INTO fragmentation, repairing, 236 OUTFILE statement, 271 FreeBSD, 12, 23 —fields-enclosed-by= switch .frm extension, 350 mysqldump, 599 FROM argument, SHOW INDEX statement, 175 mysqlimport, 276, 605 from clause, SELECT statement, 17 —fields-escaped-by= switch FROM_DAYS( ) function, 15, 202, 207 mysqldump, 600 FROM_UNIXTIME( ) function, 202, 207 mysqlimport, 276, 605 front slash (/), 211 —fields-optionally-enclosed-by= switch FTP server, 308 mysqldump, 600 full join, 17 mysqlimport, 276, 605 FULL modifier, SHOW PROCESSLIST statement, 177 —fields-terminated-by= switch FULLTEXT, SHOW INDEX statement, 175 mysqldump, 599 mysqlimport, 276, 604 G FILE privilege, 222, 324, 533 -G, mysql, 596 file system, case-sensitive, 16 -g, mysql, 596 $filedes variable, 415 Gemini table type, 90–91 finish( ) method, Perl Database Interface, 423 gemini_buffer_cache= option, NuSphere MySQL firewall, 312 Advantage, 581, 590 first name, basic customer database information, 4 gemini_connection_limit= option, NuSphere First Normal Form (1NF), 120 MySQL Advantage, 581, 590 fixed-length column, 387 —gemini-flush-log-at-commit option, NuSphere FLOAT type, 647 MySQL Advantage, 581, 590 flow-control operator, 626 gemini_io_threads= option, NuSphere MySQL FLUSH (option) statement, 14, 618–619 Advantage, 581, 590 —flush switch, mysqld, 608 gemini_lock_table_size= option, NuSphere MySQL Flush tables parameter, status function, 250 Advantage, 581, 590 FLUSH TABLES WITH READ LOCK statement, MySQL gemini_lock_wait_timeout= option, NuSphere Command-Line Interface, 383 MySQL Advantage, 581, 590 flush-hosts function, mysqladmin, 253, 602 —gemini-recovery= option, NuSphere MySQL —flushlog switch, mysqlhotcopy program, 348 Advantage, 581, 590 flush-logs function, mysqladmin, 254, 602 —gemini-unbuffered-io option, NuSphere MySQL —flush-logs switch, mysqldump, 598 Advantage, 581, 590 flush-privileges function, mysqladmin, 255, get( ) method, Java Database Connectivity, 515 335, 602 getBoolean( ) method, JDBC, 515 flush-status function, mysqladmin, 254, 602 getByte( ) method, JDBC, 515 flush-tables function, mysqladmin, 254, 602 getColumnName( ) method, JDBC, 516 flush-threads, mysqladmin, 602 getColumnType( ) method, JDBC, 516 flush_time server variable, 283 getConnection( ) method, Java Database FORCE option, myisam-recover variable, 238–239 Connectivity, 514–515 —force switch getDate( ) method, JDBC, 515 myisamcheck, 357, 361 getDouble( ) method, JDBC, 515 mysql, 596 getFloat( ) method, JDBC, 515 MySQL Command-Line Interface, 150 getInt( ) method, JDBC, 515 mysqladmin, 601 GET_LOCK( ) system function, 642 mysqlcheck, 356, 603 getLong( ) method, JDBC, 515 mysqldump, 598 getMessage( ) method, Java Database mysqlimport, 604 Connectivity, 517 foreign key, 17, 19, 243 4932-4 Index.F 5/29/02 3:55 PM Page 669 Index ✦ G–I 669
|
Wątki
|