MySQL Crash Course
- MySQL Crash Course
- Table of Contents
- 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
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W