Stored Routines
Next, let’s move on to stored routines.
A stored routine is a set of SQL statements that are grouped, named and stored together in the server. Do not worry if this does not make much sense to you at the moment. We’ll discuss it in greater depth later.
There are two types of stored routines - stored procedures and stored functions.
Stored Procedures
Let’s first look at stored procedures.
We can create a stored procedure using the syntax below:
DELIMITER $$
CREATE PROCEDURE name_of_procedure([parameters, if any])
BEGIN
-- SQL Statements
END $$
DELIMITER ;
Most of the syntax is pretty similar to the syntax for creating a trigger.
The main difference is, instead of using CREATE TRIGGER, we use CREATE PROCEDURE to create the stored procedure.
In addition, we have a pair of parentheses after the CREATE PROCEDURE keywords.
These parentheses...