Basics of MY SQL Stored Procedure

Hi Mates,

Today I'm going to share SQL stored procedures and how to implement this....

CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] routine_body
proc_parameter:
[ IN | OUT | INOUT ] param_name type
type:
Any valid MySQL data type
characteristic:
COMMENT 'string'
| LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
routine_body:
Valid SQL routine statement
To be continued in: http://bit.ly/1qxDf5e

A put away technique is a lot of Structured Query Language (SQL) explanations with an appointed name, which are put away in a social database the board framework as a gathering, so it tends to be reused and shared by different projects.