MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
Defining and Calling Stored Procedures
Provides tutorial notes on store procedures. Topics include what is a stored procedure; creating a stored procedure; calling a stored procedure to run; passing data into and out of stored procedures.
Takeaways:
All notes and examples in chapter are tested with MySQL 5.7, 5.6, 5.0 and 4.0 servers.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
►Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
Installing MySQL Server on Linux