| | Copyright |
| | About the Author |
| | Introduction |
| | Part 1: MySQL Foundations |
| | | Lesson 1. Introducing MySQL |
| | | Database Basics |
| | | MySQL Components |
| | | Summary |
| | | Lesson 2. Using MySQL |
| | | The mysql Client |
| | | Executing SQL Statements |
| | | Creating the Sample Tables |
| | | Summary |
| | Part 2: Getting Started with SQL |
| | | Lesson 3. Retrieving Data |
| | | The SELECT Statement |
| | | Summary |
| | | Lesson 4. Filtering and Sorting Data |
| | | The WHERE Clause |
| | | The ORDER BY Clause |
| | | Summary |
| | | Lesson 5. Advanced Data Filtering |
| | | Combining WHERE Clauses |
| | | Limiting the Number of Rows Returned |
| | | Summary |
| | | Lesson 6. Numeric Operators and Functions |
| | | Numeric Operators |
| | | Numeric Functions |
| | | Conditional Functions |
| | | Summary |
| | | Lesson 7. String Operators and Functions |
| | | Using Operators with Strings |
| | | String Functions |
| | | Summary |
| | | Lesson 8. Date Operators and Functions |
| | | Date Operators |
| | | Date Functions |
| | | Summary |
| | | Lesson 9. Summarizing Data |
| | | Aggregate Functions |
| | | Grouping Data |
| | | Filtering Summary Data |
| | | Summary |
| | Part 3: Advance SQL |
| | | Lesson 10. Using Subqueries |
| | | Understanding Subqueries |
| | | Summary |
| | | Lesson 11. Joining Tables |
| | | Understanding Joins |
| | | Summary |
| | | Lesson 12. Creating Advanced Joins |
| | | The JOIN Keyword |
| | | Inner Joins |
| | | Joining Multiple Tables |
| | | Cross Joins |
| | | Self-Joins |
| | | Natural Joins |
| | | Outer Joins |
| | | Summary |
| | | Lesson 13. Combining Queries |
| | | Understanding Combined Queries |
| | | Other Compound Operations |
| | | Using Temporary Tables |
| | | Summary |
| | Part 4: Creating a New Database |
| | | Lesson 14. Creating and Modifying Tables |
| | | Creating a New Database |
| | | Character Sets and Collations |
| | | Altering a Database |
| | | Dropping a Database |
| | | Managing Tables |
| | | Temporary Tables |
| | | Using a Query to Create a Table |
| | | Storage Engines |
| | | Altering Tables |
| | | Dropping Tables |
| | | Summary |
| | | Lesson 15. Working with Data |
| | | The INSERT Statement |
| | | The DELETE Statement |
| | | The UPDATE Statement |
| | | The REPLACE Statement |
| | | Loading Data from a File |
| | | Why Use Transactions? |
| | | Transactions in MySQL |
| | | Autocommit Mode |
| | | Rolling Back a Transaction |
| | | Summary |
| | | Lesson 16. Designing Your Database |
| | | Relationships |
| | | Normalization |
| | | Naming Tables and Columns |
| | | Data Types |
| | | CHAR and VARCHAR |
| | | Summary |
| | | Lesson 17. Keys and Indexes |
| | | Understanding Keys and Indexes |
| | | Using Indexes in MySQL |
| | | Summary |
| | | Lesson 18. Managing User Access |
| | | Understanding MySQL Authentication |
| | | User Management |
| | | Using Wildcards |
| | | Summary |
| | Part 5: New Features in MySQL 5.0 |
| | | Lesson 19. Views |
| | | Understanding Views |
| | | Summary |
| | | Lesson 20. Stored Routines |
| | | Understanding Stored Routines |
| | | Summary |
| | | Lesson 21. Triggers |
| | | Understanding Triggers |
| | | Using Triggers |
| | | Summary |
| | Part 6: Interfacing with MySQL |
| | | Lesson 22. Using ODBC |
| | | Understanding ODBC |
| | | Connecting to MyODBC |
| | | Summary |
| | | Lesson 23. Using MySQL with C |
| | | The C Language API |
| | | Summary |
| | | Lesson 24. Using MySQL with PHP |
| | | Using the mysql API |
| | | Using the mysqli API |
| | | Summary |
| | | Lesson 25. Using MySQL with Perl |
| | | The Perl DBI |
| | | Using the MySQL DBD |
| | | Summary |
| | Part 7: Appendix |
| | | Appendix A. Installing MySQL |
| | | Obtaining MySQL |
| | | Linux/UNIX Installation |
| | | Windows Installation |
| | | Appendix B. Sample Table Scripts |
| | Index |