This first part of the book introduces the MySQL stored program language and provides a detailed description of the language structure and usage. Chapter 1 asks the fundamental questions: Where did the language come from? What is it good for? What are the main features of the language? Chapter 2 is a tutorial that is designed to get you started with the language as quickly as possible; it shows you how to create basic stored programs of each type and provides interactive examples of major language functions. Chapters 3 through 6 describe the MySQL stored program language in detail: how to work with variables, how to implement conditional and iterative control structures, how SQL can be used within the language, and how errors can be handled.
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