MySQL Stored Procedure Programming By Steven Feuerstein, Guy Harrison
Part I: Stored Programming Fundamentals:
Chapter 1. Introduction to MySQL Stored Programs:
Section 1.1. What Is a Stored Program?
Section 1.2. A Quick Tour
Section 1.3. Resources for Developers Using Stored Programs
Section 1.4. Some Words of Advice for Developers
Chapter 2. MySQL Stored Programming Tutorial:
Section 2.1. What You Will Need
Section 2.2. Our First Stored Procedure
Section 2.3. Variables
Section 2.4. Parameters
Section 2.5. Conditional Execution
Section 2.6. Loops
Section 2.7. Dealing with Errors
Section 2.8. Interacting with the Database
Section 2.9. Calling Stored Programs from Stored Programs
Section 2.10. Putting It All Together
Section 2.11. Stored Functions
Section 2.12. Triggers
Section 2.13. Calling a Stored Procedure from PHP
Chapter 3. Language Fundamentals:
Section 3.1. Variables, Literals, Parameters, and Comments
Section 3.2. Operators
Section 3.3. Expressions
Section 3.4. Built-in Functions
Section 3.5. Data Types
Section 3.6. MySQL 5 "Strict" Mode
Chapter 4. Blocks, Conditional Statements, and Iterative Programming:
Section 4.1. Block Structure of Stored Programs
Section 4.2. Conditional Control
Section 4.3. Iterative Processing with Loops
Chapter 5. Using SQL in Stored Programming:
Section 5.1. Using Non-SELECT SQL in Stored Programs
Section 5.2. Using SELECT Statements with an INTO Clause
Section 5.3. Creating and Using Cursors
Section 5.4. Using Unbounded SELECT Statements
Section 5.5. Performing Dynamic SQL with Prepared Statements
Section 5.6. Handling SQL Errors: A Preview
Chapter 6. Error Handling:
Section 6.1. Introduction to Error Handling
Section 6.2. Condition Handlers
Section 6.3. Named Conditions
Section 6.4. Missing SQL:2003 Features
Section 6.5. Putting It All Together
Section 6.6. Handling Stored Program Errors in the Calling Application
Part II: Stored Program Construction :
Chapter 7. Creating and Maintaining Stored Programs:
Section 7.1. Creating Stored Programs
Section 7.2. Editing an Existing Stored Program
Section 7.3. SQL Statements for Managing Stored Programs
Section 7.4. Getting Information About Stored Programs
Chapter 8. Transaction Management:
Section 8.1. Transactional Support in MySQL
Section 8.2. Defining a Transaction
Section 8.3. Working with Savepoints
Section 8.4. Transactions and Locks
Section 8.5. Transaction Design Guidelines
Chapter 9. MySQL Built-in Functions:
Section 9.1. String Functions
Section 9.2. Numeric Functions
Section 9.3. Date and Time Functions
Section 9.4. Other Functions
Chapter 10. Stored Functions:
Section 10.1. Creating Stored Functions
Section 10.2. SQL Statements in Stored Functions
Section 10.3. Calling Stored Functions
Section 10.4. Using Stored Functions in SQL
Chapter 11. Triggers:
Section 11.1. Creating Triggers
Section 11.2. Using Triggers
Section 11.3. Trigger Overhead
Part III: Using MySQL Stored Programs in Applications:
Chapter 12. Using MySQL Stored Programs in Applications:
Section 12.1. The Pros and Cons of Stored Programs in Modern Applications
Section 12.2. Advantages of Stored Programs
Section 12.3. Disadvantages of Stored Programs
Section 12.4. Calling Stored Programs from Application Code
Chapter 13. Using MySQL Stored Programs with PHP:
Section 13.1. Options for Using MySQL with PHP
Section 13.2. Using PHP with the mysqli Extension
Section 13.3. Using MySQL with PHP Data Objects
Chapter 14. Using MySQL Stored Programs with Java:
Section 14.1. Review of JDBC Basics
Section 14.2. Using Stored Programs in JDBC
Section 14.3. Stored Programs and J2EE Applications
Section 14.4. Using Stored Procedures with Hibernate
Section 14.5. Using Stored Procedures with Spring
Chapter 15. Using MySQL Stored Programs with Perl:
Section 15.1. Review of Perl DBD::mysql Basics
Section 15.2. Executing Stored Programs with DBD::mysql
Chapter 16. Using MySQL Stored Programs with Python:
Section 16.1. Installing the MySQLdb Extension
Section 16.2. MySQLdb Basics
Section 16.3. Using Stored Programs with MySQLdb
Section 16.4. A Complete Example
Chapter 17. Using MySQL Stored Programs with .NET:
Section 17.1. Review of ADO.NET Basics
Section 17.2. Using Stored Programs in ADO.NET
Section 17.3. Using Stored Programs in ASP.NET
Part IV: Optimizing Stored Programs:
Chapter 18. Stored Program Security:
Section 18.1. Permissions Required for Stored Programs
Section 18.2. Execution Mode Options for Stored Programs
Section 18.3. Stored Programs and Code Injection
Chapter 19. Tuning Stored Programs and Their SQL:
Section 19.1. Why SQL Tuning Is So Important
Section 19.2. How MySQL Processes SQL
Section 19.3. SQL Tuning Statements and Practices
Section 19.4. About the Upcoming Examples
Chapter 20. Basic SQL Tuning:
Section 20.1. Tuning Table Access
Section 20.2. Tuning Joins
Chapter 21. Advanced SQL Tuning:
Section 21.1. Tuning Subqueries
Section 21.2. Tuning "Anti-Joins" Using Subqueries
Section 21.3. Tuning Subqueries in the FROM Clause
Section 21.4. Tuning ORDER and GROUP BY
Section 21.5. Tuning DML (INSERT, UPDATE, DELETE)
Chapter 22. Optimizing Stored Program Code:
Section 22.1. Performance Characteristics of Stored Programs
Section 22.2. How Fast Is the Stored Program Language?
Section 22.3. Reducing Network Traffic with Stored Programs
Section 22.4. Stored Programs as an Alternative to Expensive SQL
Section 22.5. Optimizing Loops
Section 22.6. IF and CASE Statements
Section 22.7. Recursion
Section 22.8. Cursors
Section 22.9. Trigger Overhead
Chapter 23. Best Practices in MySQL Stored Program Development:
Section 23.1. The Development Process
Section 23.2. Coding Style and Conventions
Section 23.3. Variables
Section 23.4. Conditional Logic
Section 23.5. Loop Processing
Section 23.6. Exception Handling
Section 23.7. SQL in Stored Programs
Section 23.8. Dynamic SQL
Section 23.9. Program Construction
Section 23.10. Performance.Download