What are Stored Procedures in MySQL?

by lucinda.runolfsdottir , in category: Technology , 3 months ago

What are Stored Procedures in MySQL?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by graciela.bogisich , 3 months 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.


1
2
3
4
CREATE PROCEDURE show_employee
AS SELECT FirstName, LastName
    FROM employee;
EXEC show_employee;