Because of some bad reasons, most of the blog content will only send notes. This blog is only on my.oschina.net, do not make any commercial use!!
MySQL stored procedure: Defines a set of SQL statements that are grouped together in a database and stored in a MySQL server as a whole.
The main difference between a storage function and a stored one is that a parameter, such as a Recordset, can be returned for a stored procedure, and the function can only return values or table objects. A function can only return one variable, and a stored procedure may return multiple. My.oschina.net the storage function, the difference between the stored procedure and the storage function is listed. My.oschina.net
Basic form:
CREATE PROCEDURE procedure_name ([in | Out | INOUT] Name type)
[Characteristic ...] Routine_body
Detailed Description:
MySQL stored procedures Getting started and improved (third article)