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