Beginning MySQL -- About the Authors -- Credits -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Chapter 1: Introducing the MySQL Relational Database Management System -- Databases and Database Management Systems -- The SQL Framework -- Data-Driven Applications -- Summary -- Exercises -- Chapter 2: Installing MySQL -- Getting Started -- Installing MySQL -- Testing Your MySQL Installation -- Summary -- Exercises -- Chapter 3: Working with MySQL -- Understanding the MySQL Directory Structure -- Using the MySQL Programs -- Assigning Account Passwords -- Summary -- Exercises -- Chapter 4: Designing a Relational Database -- The Relational Model -- Data Normalization -- Relationships -- Creating a Data Model -- Designing the DVDRentals Database -- Summary -- Exercises -- Chapter 5: Managing Databases, Tables, and Indexes -- Managing Databases -- Managing Tables -- Managing Indexes -- Retrieving Information About Database Objects -- Summary -- Exercises -- Chapter 6: Manipulating Data in a MySQL Database -- Inserting Data in a MySQL Database -- Updating Data in a MySQL Database -- Deleting Data from a MySQL Database -- Summary -- Exercises -- Chapter 7: Retrieving Data from a MySQL Database -- The SELECT Statement -- The SELECT Statement Options -- The Optional Clauses of a SELECT Statement -- Summary -- Exercises -- Chapter 8: Using Operators in Your SQL Statements -- Creating MySQL Expressions -- Using Operators in Expressions -- Summary -- Exercises -- Chapter 9: Using Functions in Your SQL Statements -- Comparing and Converting Data -- Managing Different Types of Data -- Summarizing Data -- Performing System Operations -- Summary -- Exercises -- Chapter 10: Accessing Data in Multiple Tables.

Creating Joins in Your SQL Statements -- Creating Subqueries in Your SQL Statements -- Creating Unions That Join SELECT Statements -- Summary -- Exercises -- Chapter 11: Exporting, Copying, and Importing Data -- Exporting Data Out of a Table -- Copying Data into a Table -- Importing Data into a Table -- Summary -- Exercises -- Chapter 12: Managing Transactions -- Introducing Transactions -- Performing a Transaction -- Setting the Autocommit Mode and Transaction Isolation Level -- Locking Nontransactional Tables -- Summary -- Exercises -- Chapter 13: Administering MySQL -- Performing Administrative Tasks -- Managing System Variables -- Managing Log Files -- Summary -- Exercises -- Chapter 14: Managing MySQL Security -- The Access Privilege System -- MySQL Access Control -- Managing MySQL User Accounts -- Summary -- Exercises -- Chapter 15: Optimizing Performance -- Optimizing MySQL Indexing -- Optimizing SQL Queries -- Optimizing MySQL Tables -- Optimizing Your System's Cache -- Summary -- Exercises -- Chapter 16: Managing Backup, Recovery, and Replication -- Backing Up Your Database -- Restoring Your Database -- Replicating Your Database -- Summary -- Exercises -- Chapter 17: Connecting to MySQL from a PHP Application -- Introduction to PHP -- Building a Data-Driven PHP Application -- Summary -- Exercises -- Chapter 18: Connecting to MySQL from a Java/J2EE Application -- Introduction to Java/J2EE -- Building a Java/J2EE Web Application -- Summary -- Exercises -- Chapter 19: Connecting to MySQL from an ASP.NET/C# Application -- Introduction to ASP.NET/C# -- Building an ASP.NET/C# Application -- Summary -- Exercises -- Appendix A: Exercise Answers -- Chapter 1 -- Chapter 2 -- Chapter 3 -- Chapter 4 -- Chapter 5 -- Chapter 6 -- Chapter 7 -- Chapter 8 -- Chapter 9 -- Chapter 10 -- Chapter 11 -- Chapter 12 -- Chapter 13 -- Chapter 14 -- Chapter 15.

Chapter 16 -- Chapter 17 -- Chapter 18 -- Chapter 19 -- Appendix B: MySQL APIs -- Appendix C: MySQL 5 -- Stored Procedures -- Triggers -- Views -- Index.