MySQL Stored Procedure Programming (2009)
Part I. Stored Programming Fundamentals
Chapter 1. Introduction to MySQL Stored Programs
Chapter 2. MySQL Stored Programming Tutorial
Chapter 3. Language Fundamentals
Chapter 4. Blocks, Conditional Statements, and Iterative Programming
Chapter 5. Using SQL in Stored Programming
Part II. Stored Program Construction
Chapter 7. Creating and Maintaining Stored Programs
Chapter 8. Transaction Management
Chapter 9. MySQL Built-in Functions
Part III. Using MySQL Stored Programs in Applications
Chapter 12. Using MySQL Stored Programs in Applications
Chapter 13. Using MySQL Stored Programs with PHP
Chapter 14. Using MySQL Stored Programs with Java
Chapter 15. Using MySQL Stored Programs with Perl
Chapter 16. Using MySQL Stored Programs with Python
Chapter 17. Using MySQL Stored Programs with .NET
Part IV. Optimizing Stored Programs
Chapter 18. Stored Program Security
Chapter 19. Tuning Stored Programs and Their SQL
Chapter 21. Advanced SQL Tuning
Chapter 22. Optimizing Stored Program Code
Chapter 23. Best Practices in MySQL Stored Program Development