A stored procedure is a collection of SQL statements that are stored in the database. A stored procedure can contain business logic, which is one of the key aspects that distinguish stored procedures from views. A stored procedure can accept parameters, and you can set variables, write IF statements, etc within a stored procedure.

A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can also pass parameters to a stored procedure so that the stored procedure can act based on the parameter value(s) that is passed.

Syntax

CREATE PROCEDURE sp_name(p_1 INT)
BEGIN
...code goes here...
END;

Example

Calling a Stored Procedure

We can use CALL keyword to invoke stored procedures.

CALL spGetPosts()