Stored Procedures
In this exercise, we will create a total of nine stored procedures. Before we start coding them, let’s first change the delimiter by adding the line
DELIMITER $$
to our sportsDB.sql file.
We’ll code all the stored procedures after this line; there is no need to change the delimiter back to a semi-colon after each procedure. We’ll change the delimiter back after we finish coding all the procedures and functions.
Ready?
insert_new_member
The first stored procedure is for inserting a new member into the members table.
If you study the structure of the members table, you can see that it has a total of 5 columns: id, password, email, member_since and payment_due.
As the last two columns have default values, we only need to provide values for the first three columns when inserting a new member.
To do that, let’s create a stored procedure called insert_new_member...