| | Copyright |
| | About the Author |
| | Acknowledgments |
| | We Want to Hear from You! |
| | Introduction |
| | | Who Is This Book For? |
| | | Companion Website |
| | | Conventions Used in This Book |
| | Chapter 1. Understanding SQL |
| | | Database Basics |
| | | What Is SQL? |
| | | Try It Yourself |
| | | Summary |
| | Chapter 2. Introducing MySQL |
| | | What Is MySQL? |
| | | MySQL Tools |
| | | Summary |
| | Chapter 3. Working with MySQL |
| | | Making the Connection |
| | | Selecting a Database |
| | | Learning About Databases and Tables |
| | | Summary |
| | Chapter 4. Retrieving Data |
| | | The SELECT Statement |
| | | Retrieving Individual Columns |
| | | Retrieving Multiple Columns |
| | | Retrieving All Columns |
| | | Retrieving Distinct Rows |
| | | Limiting Results |
| | | Using Fully Qualified Table Names |
| | | Summary |
| | Chapter 5. Sorting Retrieved Data |
| | | Sorting Data |
| | | Sorting by Multiple Columns |
| | | Specifying Sort Direction |
| | | Summary |
| | Chapter 6. Filtering Data |
| | | Using the WHERE Clause |
| | | The WHERE Clause Operators |
| | | Summary |
| | Chapter 7. Advanced Data Filtering |
| | | Combining WHERE Clauses |
| | | Using the IN Operator |
| | | Using the NOT Operator |
| | | Summary |
| | Chapter 8. Using Wildcard Filtering |
| | | Using the LIKE Operator |
| | | Tips for Using Wildcards |
| | | Summary |
| | Chapter 9. Searching Using Regular Expressions |
| | | Understanding Regular Expressions |
| | | Using MySQL Regular Expressions |
| | | Summary |
| | Chapter 10. Creating Calculated Fields |
| | | Understanding Calculated Fields |
| | | Concatenating Fields |
| | | Performing Mathematical Calculations |
| | | Summary |
| | Chapter 11. Using Data Manipulation Functions |
| | | Understanding Functions |
| | | Using Functions |
| | | Summary |
| | Chapter 12. Summarizing Data |
| | | Using Aggregate Functions |
| | | Aggregates on Distinct Values |
| | | Combining Aggregate Functions |
| | | Summary |
| | Chapter 13. Grouping Data |
| | | Understanding Data Grouping |
| | | Creating Groups |
| | | Filtering Groups |
| | | Grouping and Sorting |
| | | SELECT Clause Ordering |
| | | Summary |
| | Chapter 14. Working with Subqueries |
| | | Understanding Subqueries |
| | | Filtering by Subquery |
| | | Using Subqueries As Calculated Fields |
| | | Summary |
| | Chapter 15. Joining Tables |
| | | Understanding Joins |
| | | Creating a Join |
| | | Summary |
| | Chapter 16. Creating Advanced Joins |
| | | Using Table Aliases |
| | | Using Different Join Types |
| | | Using Joins with Aggregate Functions |
| | | Using Joins and Join Conditions |
| | | Summary |
| | Chapter 17. Combining Queries |
| | | Understanding Combined Queries |
| | | Creating Combined Queries |
| | | Summary |
| | Chapter 18. Full-Text Searching |
| | | Understanding Full-Text Searching |
| | | Using Full-Text Searching |
| | | Summary |
| | Chapter 19. Inserting Data |
| | | Understanding Data Insertion |
| | | Inserting Complete Rows |
| | | Inserting Multiple Rows |
| | | Inserting Retrieved Data |
| | | Summary |
| | Chapter 20. Updating and Deleting Data |
| | | Updating Data |
| | | Deleting Data |
| | | Guidelines for Updating and Deleting Data |
| | | Summary |
| | Chapter 21. Creating and Manipulating Tables |
| | | Creating Tables |
| | | Updating Tables |
| | | Deleting Tables |
| | | Renaming Tables |
| | | Summary |
| | Chapter 22. Using Views |
| | | Understanding Views |
| | | Using Views |
| | | Summary |
| | Chapter 23. Working with Stored Procedures |
| | | Understanding Stored Procedures |
| | | Why Use Stored Procedures |
| | | Using Stored Procedures |
| | | Summary |
| | Chapter 24. Using Cursors |
| | | Understanding Cursors |
| | | Working with Cursors |
| | | Summary |
| | Chapter 25. Using Triggers |
| | | Understanding Triggers |
| | | Creating Triggers |
| | | Dropping Triggers |
| | | Using Triggers |
| | | Summary |
| | Chapter 26. Managing Transaction Processing |
| | | Understanding Transaction Processing |
| | | Controlling Transactions |
| | | Summary |
| | Chapter 27. Globalization and Localization |
| | | Understanding Character Sets and Collation Sequences |
| | | Working with Character Set and Collation Sequences |
| | | Summary |
| | Chapter 28. Managing Security |
| | | Understanding Access Control |
| | | Managing Users |
| | | Summary |
| | Chapter 29. Database Maintenance |
| | | Backing Up Data |
| | | Performing Database Maintenance |
| | | Diagnosing Startup Problems |
| | | Review Log Files |
| | | Summary |
| | Chapter 30. Improving Performance |
| | | Improving Performance |
| | | Summary |
| | Appendix A. Getting Started with MySQL |
| | | What You'll Need |
| | | Obtaining the Software |
| | | Installing the Software |
| | | Preparing for Your Chapters |
| | Appendix B. The Example Tables |
| | | Understanding the Sample Tables |
| | | Creating the Sample Tables |
| | Appendix C. MySQL Statement Syntax |
| | | ALTER TABLE |
| | | COMMIT |
| | | CREATE INDEX |
| | | CREATE PROCEDURE |
| | | CREATE TABLE |
| | | CREATE USER |
| | | CREATE VIEW |
| | | DELETE |
| | | DROP |
| | | INSERT |
| | | INSERT SELECT |
| | | ROLLBACK |
| | | SAVEPOINT |
| | | SELECT |
| | | START TRANSACTION |
| | | UPDATE |
| | Appendix D. MySQL Datatypes |
| | | String Datatypes |
| | | Numeric Datatypes |
| | | Date and Time Datatypes |
| | | Binary Datatypes |
| | Appendix E. MySQL Reserved Words |
| | Developer's Library |
| | Index |