This part of the book describes how you can use the elements described in Part I to build functional and useful stored programs. In Chapter 7 we outline the commands available for creating and modifying stored programs and provide some advice on how to manage your stored program source code. Chapter 8 outlines transaction handling in stored programs, while Chapter 9 details the built-in functions that can be used in stored programs. Chapters 10 and 11 detail two “special” types of stored programs: Chapter 10 shows how you can create and use stored functions; Chapter 11 describes triggers, which are stored programs that are invoked in response to DML executed on a database table.
Chapter 7, Creating and Maintaining Stored Programs
Chapter 8, Transaction Management
Chapter 9, MySQL Built-in Functions
Chapter 10, Stored Functions
Chapter 11, Triggers