Learn SQL Database Programming

Creating a stored procedure

Let's learn how to create a stored procedure. First, we'll go through the following syntax, which is used to create a stored procedure:

DELIMITER $$CREATE PROCEDURE storedprocname() BEGIN your sql statments go here;  END $$DELIMITER ;

In the previous code sample, we have the following:

• DELIMITER lets MySQL know that there may be lines in-between the delimiter statements that end in a semicolon.
• If you don't put DELIMITER around a stored procedure, you will get an error when MySQL hits the semicolon in your first SQL query, inside the stored procedure.

Let's work through an example of how to create a stored procedure. The following code will help you create a stored procedure:

USE lahmansbaseballdb;DELIMITER ...