文档介绍：MySQL Stored Procedures
MySQL New Features Series – Part 1
A MySQL® Technical White Paper
Peter Gulutzan
March, 2005
Copyright © 2005, MySQL AB
Table of Contents
Introduction ....................................................................................................3
A Definition and an Example ........................................................................3
Why Stored Procedures ................................................................................4
Why MySQL Statements are Legal in a Procedure Body...........................8
Characteristics Clauses ..............................................................................10
Parameters....................................................................................................13
The New SQL Statements ...........................................................................15
(Scope ...........................................................................................................16
Loops.............................................................................................................21
Error Handling ..............................................................................................29
Cursors .........................................................................................................35
Security .........................................................................................................41
Functions ......................................................................................................43
Metadata........................................................................................................44
Details ...........................................................................................................48
Style......................................