Stored procedures:
is to put their common query, modify the database command encapsulated, saved in the database, made interface through the function of a call process
stored procedures are useful when you want to perform the same functions on different applications or platforms, or encapsulate specific functionality.
It allows control over how data is accessed.
(1). stored procedures enhance the SQL the function and flexibility of the language. Stored procedures can be written with flow control statements, with a strong flexibility to complete complex judgments and more complex operations.
(2). The stored procedure allows standard components to be programmed. After the stored procedure is created, it can be called multiple times in the program without having to rewrite the stored procedure's statement
(3). The stored procedure can achieve a faster execution speed
(5). stored procedures can be used as a security mechanism to make full use of them.
From for notes (Wiz)
MySQL stored procedures