MySQL Stored Procedure Programming (2009)

MySQL Stored Procedure Programming (2009)

Preface

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

Chapter 6. Error Handling

Part II. Stored Program Construction

Chapter 7. Creating and Maintaining Stored Programs

Chapter 8. Transaction Management

Chapter 9. MySQL Built-in Functions

Chapter 10. Stored Functions

Chapter 11. Triggers

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 20. Basic SQL Tuning

Chapter 21. Advanced SQL Tuning

Chapter 22. Optimizing Stored Program Code

Chapter 23. Best Practices in MySQL Stored Program Development