What are Stored Procedures in MySQL?

@lucinda.runolfsdottir Stored Procedure is Batch of SQL statements and saved in database. It also accepts parameters and can be triggered explicitly. It improves the traffic control and gives a modular structure to implement maintainability.

1
2
3
4

CREATE PROCEDURE show_employee
AS SELECT FirstName, LastName
    FROM employee;
EXEC show_employee;