What are Stored Procedures in MySQL?

by lucinda.runolfsdottir , in category: Technology , a year ago

What are Stored Procedures in MySQL?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by graciela.bogisich , a year ago

@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.

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