“MySQL: Visual QuickStart Guide” Table of Contents

MySQL: Visual QuickStart Guide

  • Introduction
  • Chapter 1: Installing MySQL
    • Installing MySQL on Windows
    • Installing MySQL on Macintosh
    • Installing MySQL on Linux
    • Configuration Options
    • Upgrading MySQL
    • Patching MySQL
  • Chapter 2: Running MySQL
    • Starting MySQL
    • Stopping MySQL
    • Using mysqladmin
    • Using the mysql Client
    • Users and Privileges
  • Chapter 3: Database Design
    • Normalization
    • Keys
    • Relationships
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
    • MySQL Data Types
    • NULL and Default Values
    • Indexes
    • Final Design Steps
  • Chapter 4: SQL
    • Creating Databases and Tables
    • Inserting Dtaa
    • Selecting Data
    • Using Conditionals
    • Using LIKE and NOT LIKE
    • Performing Joins
    • Sorting Query Results
    • Limiting Query Results
    • Updating Data
    • Deleting Data
    • Modifying Tables
  • Chapter 5: 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 6: MySQL and PHP
    • Connecting to MySQL and Selecting a Database
    • Executing Simple Queries
    • Retrieving Query Results
    • Using mysql_insert_id()
    • Error Handling
    • Security
  • Chapter 7: 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
    • Executing Simple Queries
    • Retrieving Query Results
    • Retrieving the Insert ID
    • Security
  • Chapter 8: MySQL and Java
    • Installing Java Support for MySQL
    • Connecting to the Database
    • Executing Simple Queries
    • Retrieving Query Results
    • Using Property Files
  • Chapter 9: Database Programming Techniques
    • Storing and Retrieving Binary Data
    • Creating a Search Engine
    • Making Query Result Pages
    • Database Security
  • Chapter 10: MySQL Admiistration
    • MySQL Data Files
    • Backing Up Databases
    • Using Batch Files
    • Importing Data
    • Database Maintenance
    • Improving Performance
    • MySQL Logging
    • Security
  • Chapter 11: Advanced MySQL
    • Using InnoDB Tables
    • Transactions in MySQL
    • Locking Tables
    • Full-Text Searching
    • Regular Expressions
  • Appendix A: Troubleshooting
    • Installation
    • Starting MySQL
    • Accessing MySQL
    • mysql.sock Problems
    • Resetting the Root Password
    • Resetting the Auto Incrementation
    • Queries That Return Strange Results
  • Appendix B: SQL and MySQL References
    • Basic SQL
    • Administrative SQL
    • MySQL Privileges
    • MySQL Data Types
    • MySQL Functions
    • Other References
  • Appendix C: Resources
    • MySQL
    • Third-Party MySQL Applications
    • SQL
    • General Database
    • PHP
    • Perl
    • Java
    • Security
    • Other Resources