Visual Quickstart Guide MySQL By Larry Ullman
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 Data
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
Chapter 7. MySQL and PHP:
Connecting to MySQL and Selecting a Database
Executing Simple Queries
Retrieving Query Results
Using mysqli_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.Download