Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition Tim King, George Reese, Randy Yarger

Spis treści książki

• Managing and Using MySQL, 2nd Edition
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • Preface
    • Audience
    • Purpose
    • Using This Book
    • Conventions Used in This Book
    • Comments and Questions
    • Acknowledgments
      • From Randy Yarger
      • From George Reese
      • From Tim King
  • I. Introduction
    • 1. MySQL
      • 1.1. Relational Databases
      • 1.2. The History of MySQL
      • 1.3. MySQL Design
      • 1.4. MySQL Features
      • 1.5. MySQL Applications
      • 1.6. What You Get
    • 2. Installation
      • 2.1. Preparation
      • 2.2. Unix Installation
        • 2.2.1. Binary (Tarball) Distributions
        • 2.2.2. Binary (RPM) Distributions
        • 2.2.3. Source Distributions
      • 2.3. Windows Installation
        • 2.3.1. Windows 9x Startup
        • 2.3.2. Windows NT/2000 Startup
    • 3. SQL According to MySQL
      • 3.1. SQL Basics
        • 3.1.1. The SQL Story
        • 3.1.2. The Design of SQL
        • 3.1.3. Sending SQL to MySQL
      • 3.2. Database Creation
      • 3.3. Table Management
      • 3.4. MySQL Data Types
        • 3.4.1. Numeric Types
        • 3.4.2. Character Types
        • 3.4.3. Binary Data Types
        • 3.4.4. Enumerations and Sets
        • 3.4.5. Other Kinds of Data
      • 3.5. Indexing
      • 3.6. Managing Data
        • 3.6.1. Inserts
        • 3.6.2. Sequence Generation
        • 3.6.3. Updates
        • 3.6.4. The WHERE Clause
        • 3.6.5. Deletes
      • 3.7. Queries
        • 3.7.1. Joins
        • 3.7.2. Aliasing
        • 3.7.3. Ordering and Grouping
          • 3.7.3.1. Basic ordering
          • 3.7.3.2. Localized sorting
          • 3.7.3.3. Grouping
        • 3.7.4. Limiting Results
      • 3.8. SQL Operators
        • 3.8.1. Logical Operators
        • 3.8.2. Nulls Idiosyncrasies
        • 3.8.3. Membership Tests
        • 3.8.4. Pattern Matching
      • 3.9. Advanced Features
        • 3.9.1. Full Text Searching
          • 3.9.1.1. The Basics
          • 3.9.1.2. Relevance values
          • 3.9.1.3. Boolean mode
          • 3.9.1.4. Tips
        • 3.9.2. Transactions
        • 3.9.3. Table Locking
        • 3.9.4. Functions
          • 3.9.4.1. Date functions
          • 3.9.4.2. String functions
        • 3.9.5. Outer Joins
        • 3.9.6. Unions
        • 3.9.7. Batch Processing
          • 3.9.7.1. Command-line loads
          • 3.9.7.2. The LOAD command
          • 3.9.7.3. Pulling data from MySQL
    • 4. Database Administration
      • 4.1. Configuration
        • 4.1.1. File Locations
        • 4.1.2. File Content
      • 4.2. Server Startup and Shutdown
        • 4.2.1. Unix/Linux
          • 4.2.1.1. SVR4
          • 4.2.1.2. Other Unix
        • 4.2.2. Mac OS X
        • 4.2.3. Windows NT/2000
      • 4.3. Logging
        • 4.3.1. The Error Log
        • 4.3.2. The Binary Log
        • 4.3.3. The Slow Query Log
        • 4.3.4. Log Rotation
      • 4.4. Backup
        • 4.4.1. mysqldump
        • 4.4.2. mysqlhotcopy
      • 4.5. Recovery
        • 4.5.1. mysqldump Recovery
        • 4.5.2. mysqlhotcopy Recovery
      • 4.6. Table Maintenance and Crash Recovery
        • 4.6.1. Checking a Table
        • 4.6.2. Repairing a Table
        • 4.6.3. Scheduled Table Checking
  • II. MySQL Administration
    • 5. Performance Tuning
      • 5.1. An Approach to Performance Tuning
      • 5.2. Application Tuning
        • 5.2.1. Host Application Tuning
        • 5.2.2. SQL Query Tuning
          • 5.2.2.1. Index guidelines
          • 5.2.2.2. EXPLAIN SELECT
          • 5.2.2.3. Other options
      • 5.3. Database Server Tuning
      • 5.4. Operating System/Hardware Tuning
    • 6. Security
      • 6.1. Database Security
        • 6.1.1. User Management
        • 6.1.2. Privilege Management
          • 6.1.2.1. GRANT and REVOKE
          • 6.1.2.2. The security tables
        • 6.1.3. Recovering from Password and Permission Problems
      • 6.2. System Security
        • 6.2.1. Operating System Security
        • 6.2.2. Hardware Security
        • 6.2.3. Network Security
          • 6.2.3.1. Network topology
          • 6.2.3.2. Encryption
          • 6.2.3.3. Direct compromise
      • 6.3. Application Security
        • 6.3.1. The Application Server
          • 6.3.1.1. User management
          • 6.3.1.2. Resource protection
        • 6.3.2. Client Applications
    • 7. Database Design
      • 7.1. Database Design Primer
        • 7.1.1. Database Entities
        • 7.1.2. Entity Attributes
        • 7.1.3. Data Model
      • 7.2. Normalization
        • 7.2.1. First Normal Form
        • 7.2.2. The Unique Identifier
        • 7.2.3. Relationships
        • 7.2.4. Second Normal Form
        • 7.2.5. Kinds of Relationships
        • 7.2.6. Refining Relationships
        • 7.2.7. More 2NF
        • 7.2.8. Third Normal Form
      • 7.3. A Logical Data-Modeling Methodology
      • 7.4. Physical Database Design
        • 7.4.1. Tables and Columns
        • 7.4.2. Foreign Keys
  • III. MySQL Programming
    • 8. Database Applications
      • 8.1. Architecture
        • 8.1.1. Client/Server Architecture
          • 8.1.1.1. Application logic
          • 8.1.1.2. Fat and thin clients
        • 8.1.2. Distributed Application Architecture
        • 8.1.3. Web Architecture
      • 8.2. Connections and Transactions
        • 8.2.1. Connections
        • 8.2.2. Transactions
          • 8.2.2.1. Transaction isolation levels
          • 8.2.2.2. Using READ UNCOMMITTED
      • 8.3. Object/Relational Modeling
    • 9. Perl
      • 9.1. Introduction to DBI
        • 9.1.1. Basic Perl Example
        • 9.1.2. Setting Up the Database and Program
        • 9.1.3. Error Handling and Attributes
        • 9.1.4. Introducing Bind Variables and Optimizations
      • 9.2. DBI and CGI
        • 9.2.1. Introduction to Perl CGI
        • 9.2.2. The Model/View/Controller Methodology
        • 9.2.3. A Sample CGI/DBI Program
      • 9.3. A General Model for Maintainable Perl Programs
        • 9.3.1. A Model for Relational Data
        • 9.3.2. Implementing the Model
          • 9.3.2.1. The Publisher class
          • 9.3.2.2. Methods that build and execute SQL
          • 9.3.2.3. Methods that handle WHERE clauses
          • 9.3.2.4. Getter/setter methods
          • 9.3.2.5. Primary key select method
          • 9.3.2.6. Constructors
          • 9.3.2.7. The DB class
          • 9.3.2.8. The mysql class
          • 9.3.2.9. The Cache class
        • 9.3.3. Example of the Model's Use
    • 10. Python
      • 10.1. DB-API
        • 10.1.1. The Database Connection
        • 10.1.2. Cursors
        • 10.1.3. Parameterized SQL
        • 10.1.4. Other Objects
      • 10.2. Proprietary Operations
      • 10.3. Applied DB-API
    • 11. PHP
      • 11.1. Introducing PHP
        • 11.1.1. A Short Language Primer
      • 11.2. Installing PHP
        • 11.2.1. Getting Started Under Unix
          • 11.2.1.1. Installation problems
        • 11.2.2. Getting Started Under Microsoft Windows
      • 11.3. Accessing the MySQL DBMS with PHP
        • 11.3.1. The Wedding Gift Registry Database
        • 11.3.2. Opening and Using a Database Connection
        • 11.3.3. Handling Results
        • 11.3.4. Frequently Used MySQL Library Functions
        • 11.3.5. Handling MySQL Errors
        • 11.3.6. Include Files
      • 11.4. Securing User Data
      • 11.5. Managing Sessions
      • 11.6. Writing Data with PHP
      • 11.7. Using the HTML <form> Environment
      • 11.8. Where to Find Out More
    • 12. C API
      • 12.1. API Overview
        • 12.1.1. The Connection
        • 12.1.2. Queries and Results
        • 12.1.3. Closing the Connection
      • 12.2. The C API in Practice
        • 12.2.1. Support Functions
        • 12.2.2. Quote Retrieval
        • 12.2.3. Adding Symbols
      • 12.3. Advanced Issues
    • 13. Java
      • 13.1. The JDBC API
        • 13.1.1. The JDBC Architecture
        • 13.1.2. Connecting to MySQL
          • 13.1.2.1. Data source connectivity
          • 13.1.2.2. Driver manager connectivity
        • 13.1.3. Maintaining Portability Using Properties Files
          • 13.1.3.1. Properties files
          • 13.1.3.2. Data sources revisited
      • 13.2. Simple Database Access
        • 13.2.1. Queries and Result Sets
        • 13.2.2. Error Handling and Clean Up
      • 13.3. Dynamic Database Access
        • 13.3.1. Metadata
        • 13.3.2. Processing Dynamic SQL
      • 13.4. A Guest Book Servlet
    • 14. Extending MySQL
      • 14.1. User-Defined Functions
        • 14.1.1. Standard Functions
          • 14.1.1.1. The init routine
          • 14.1.1.2. The main routine
          • 14.1.1.3. The deinit routine
        • 14.1.2. Aggregate Functions
          • 14.1.2.1. init
          • 14.1.2.2. reset
          • 14.1.2.3. add
          • 14.1.2.4. main
          • 14.1.2.5. deinit
          • 14.1.2.6. Aggregate example
        • 14.1.3. Calling a UDF
      • 14.2. Alternative Character Sets
        • 14.2.1. Simple Character Sets
        • 14.2.2. Complex Character Sets
  • IV. MySQL Reference
    • 15. SQL Syntax for MySQL
      • 15.1. Basic Syntax
        • 15.1.1. Literals
        • 15.1.2. Identifiers
        • 15.1.3. Comments
      • 15.2. SQL Commands
        • ALTER TABLE
        • ANALYZE TABLE
        • CREATE DATABASE
        • CREATE FUNCTION
        • CREATE INDEX
        • CREATE TABLE
        • DELETE
        • DESCRIBE
        • DESC
        • DROP DATABASE
        • DROP FUNCTION
        • DROP INDEX
        • DROP TABLE
        • EXPLAIN
        • FLUSH
        • GRANT
        • INSERT
        • KILL
        • LOAD
        • LOCK
        • OPTIMIZE
        • REPLACE
        • REVOKE
        • SELECT
        • SET
        • SHOW
        • TRUNCATE
        • UNLOCK
        • UPDATE
        • USE
    • 16. MySQL Data Types
      • 16.1. Numeric Data Types
        • BIGINT
        • DEC
        • DECIMAL
        • DOUBLE
        • DOUBLE PRECISION
        • FLOAT
        • INT
        • INTEGER
        • MEDIUMINT
        • NUMERIC
        • REAL
        • SMALLINT
        • TINYINT
      • 16.2. String Data Types
        • BLOB
        • CHAR
        • CHARACTER
        • CHARACTER VARYING
        • LONGBLOB
        • LONGTEXT
        • MEDIUMBLOB
        • MEDIUMTEXT
        • NCHAR
        • NATIONAL CHAR
        • NATIONAL CHARACTER
        • NATIONAL VARCHAR
        • TEXT
        • TINYBLOB
        • TINYTEXT
        • VARCHAR
      • 16.3. Date Data Types
        • DATE
        • DATETIME
        • TIME
        • TIMESTAMP
        • YEAR
      • 16.4. Complex Data Types
        • ENUM
        • SET
    • 17. Operators and Functions
      • 17.1. Operators
        • 17.1.1. Rules of Precedence
        • 17.1.2. Arithmetic Operators
        • 17.1.3. Comparison Operators
        • 17.1.4. Logical Operators
      • 17.2. Functions
        • 17.2.1. Aggregate Functions
        • 17.2.2. General Functions
    • 18. MySQL PHP API Reference
      • 18.1. Data Types
      • 18.2. Functions
        • mysql_affected_rows
        • mysql_change_user
        • mysql_close
        • mysql_connect
        • mysql_create_db
        • mysql_data_seek
        • mysql_db_name
        • mysql_drop_db
        • mysql_errno
        • mysql_error
        • mysql_escape_string
        • mysql_fetch_array
        • mysql_fetch_assoc
        • mysql_fetch_field
        • mysql_fetch_lengths
        • mysql_fetch_object
        • mysql_fetch_row
        • mysql_field_flags
        • mysql_field_name
        • mysql_field_len
        • mysql_field_seek
        • mysql_field_table
        • mysql_field_type
        • mysql_free_result
        • mysql_get_client_info
        • mysql_get_host_info
        • mysql_get_proto_info
        • mysql_get_server_info
        • mysql_insert_id
        • mysql_list_dbs
        • mysql_list_fields
        • mysql_list_tables
        • mysql_num_fields
        • mysql_num_rows
        • mysql_pconnect
        • mysql_query
        • mysql_result
        • mysql_select_db
        • mysql_tablename
        • mysql_unbuffered_query
    • 19. C Reference
      • 19.1. Data Types
      • 19.2. Functions
        • mysql_affected_rows
        • mysql_change_user
        • mysql_character_set_name
        • mysql_close
        • mysql_connect
        • mysql_create_db
        • mysql_data_seek
        • mysql_debug
        • mysql_drop_db
        • mysql_dump_debug_info
        • mysql_eof
        • mysql_errno
        • mysql_error
        • mysql_escape_string
        • mysql_fetch_field
        • mysql_fetch_field_direct
        • mysql_fetch_fields
        • mysql_fetch_lengths
        • mysql_fetch_row
        • mysql_field_count
        • mysql_field_seek
        • mysql_field_tell
        • mysql_free_result
        • mysql_get_client_info
        • mysql_get_host_info
        • mysql_get_proto_info
        • mysql_get_server_info
        • mysql_info
        • mysql_init
        • mysql_insert_id
        • mysql_kill
        • mysql_list_dbs
        • mysql_list_fields
        • mysql_list_processes
        • mysql_list_tables
        • mysql_num_fields
        • mysql_num_rows
        • mysql_odbc_escape_string
        • mysql_odbc_remove_escape
        • mysql_options
        • mysql_ping
        • mysql_query
        • mysql_read_query_result
        • mysql_real_connect
        • mysql_real_escape_string
        • mysql_real_query
        • mysql_refresh
        • mysql_reload
        • mysql_row_seek
        • mysql_row_tell
        • mysql_select_db
        • mysql_send_query
        • mysql_shutdown
        • mysql_ssl_cipher
        • mysql_ssl_clear
        • mysql_ssl_set
        • mysql_stat
        • mysql_store_result
        • mysql_thread_id
        • mysql_thread_safe
        • mysql_use_result
    • 20. The Python DB-API
      • 20.1. Module: MySQLdb
        • 20.1.1. Module Attributes
          • apilevel
          • paramstyle
          • quote_conv
          • threadsafety
          • type_conv
        • 20.1.2. Module Methods
          • MySQL.connect()
        • 20.1.3. Connection Attributes
          • db
        • 20.1.4. Connection Methods
          • close()
          • commit()
          • cursor()
          • rollback( )
        • 20.1.5. Cursor Attributes
          • arraysize
          • description
          • rowcount
        • 20.1.6. Cursor Methods
          • callproc( )
          • Method: close( )
          • execute( )
          • executemany( )
          • Method: fetchall( )
          • fetchmany( )
          • fetchone( )
          • insert_id( )*
          • nextset( )
          • setinputsizes( )
          • setoutputsize( )
  • Index
  • About the Authors
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje