Chapter 2. MySQL Stored Programming Tutorial
MySQL stored programming is a complex topic. We offer this chapter to introduce you to the main and common tasks you will need to perform, including:
How to create a stored program
How to pass information in and out of the stored program
How to interact with the database
How to create procedures, functions, and triggers in the MySQL stored program language
We don't go into detail in this chapter. Our purpose is to get you started and to give you some appreciation of how stored programs work. Later chapters will explore in detail all of the topics touched on in this chapter.
What You Will Need
To follow along with the examples in this tutorial , you will need:
A MySQL 5 server
A text editor such as vi, emacs, or Notepad
The MySQL Query Browser
You can get the MySQL server and MySQL Query Browser from http://dev.mysql.com.