“MySQL: Visual QuickStart Guide” (2nd Edition) Table of Contents

MySQL: Visual QuickStart
Guide (2nd Edition)

  • Introduction
  • Chapter 1: Installing MySQL
    • General Installation Steps
    • Installing MySQL on Windows
    • Configuring MySQL on Windows
    • Installing MySQL on Macintosh
    • Installing MySQL on Linux
    • Basic Configuration Options
    • Upgrading MySQL
  • Chapter 2: Running MySQL
    • Running MySQL on Windows and Windows NT
    • Running MySQL on Mac OS X
    • Running MySQL on Linux and Unix
    • Using mysqladmin
    • Setting the Root User Password
    • Using the mysql Client
    • Users and Privileges
  • Chapter 3: Database Design
    • Normalization
    • Understanding Keys
    • Understanding Relationships
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
  • Chapter 4: Creating a MySQL Database
    • MySQL Data Types
    • Extra Column Characteristics
    • Introduction to Indexes
    • Finalizing a Table’s Design
    • Choosing a Storage Engine
    • Character Sets and Collations
    • Creating Databases
    • Creating Tables
    • Modifying Tables
  • Chapter 5: Basic SQL
    • Using Values in Queries
    • Inserting Dtaa
    • Selecting Data
    • Using Conditionals
    • Using LIKE and NOT LIKE
    • Performing Joins
    • Sorting Query Results
    • Limiting Query Results
    • Updating Data
    • Deleting Data
  • Chapter 6: MySQL Functions
    • Text Functions
    • Concatenation and Aliases
    • Numeric Functions
    • Date and Time Functions
    • Formatting the Date and Time
    • Encryption Functions
    • Grouping Functions
    • Other Functions
  • Chapter 7: MySQL and PHP
    • Connecting to MySQL and Selecting a Database
    • Executing Simple Queries
    • Retrieving Query Results
    • Using mysql_insert_id()
    • Error Handling
    • Security Considerations
  • Chapter 8: MySQL and Perl
    • Installing Perl with MySQL Support on Windows
    • Installing Perl Support for MySQL on Unix and Mac OS X
    • Testing Perl and MySQL
    • Connecting to MySQL
    • Retrieving Query Results
    • Executing Simple Queries
    • Retrieving the Insert ID
    • Error Handling
    • Security Considerations
    • Using Prepared Statements
  • Chapter 9: MySQL and Java
    • Installing Java Support for MySQL
    • Connecting to the Database
    • Executing Simple Queries
    • Retrieving Query Results
    • Retrieving the Insert ID
    • Using Prepared Statements
  • Chapter 10: Advanced SQL and MySQL
    • Performing Transactions
    • Full-Text Searching
    • Regular Expressions
    • User-Defined Variables
    • Introducing Unions
  • Chapter 11: MySQL 5 Features
    • Stored Routines
    • Using OUT Parameters
    • Triggers
    • Views
  • Chapter 12: Techniques for Programming
    • Storing and Retrieving Binary Data
    • Making Query Result Pages
    • Using Transactions with Perl
  • Chapter 13: MySQL Administration
    • The MySQL Administrator
    • Backing Up Databases
    • Importing Data
    • MySQL Logging
    • Database Maintenance
    • Improving Performance
    • Using Batch Files
  • Appendix A: Troubleshooting
    • Installation
    • Starting MySQL
    • Accessing MySQL
    • mysql.sock Problems
    • Queries That Return Strange Results
    • Authentication Protocol Problems
    • Resetting the Root Password
  • Appendix B: SQL and MySQL References
    • Basic SQL
    • ALTER Commands
    • SQL Clauses
    • MySQL Privileges
    • MySQL Data Types
    • MySQL Functions
    • Other References
  • Appendix C: Resources
    • MySQL-Specific
    • Third-Party MySQL Applications
    • SQL
    • PHP
    • Perl
    • Java
    • Other