CREATE PROCEDURE is used to create a stored procedure. See Chapter 23, "Working with Stored Procedures," for more information.
• Input
CREATE PROCEDURE procedurename( [parameters] ) BEGIN ... END;