Stored Procedures in Mysql

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures, and applications such as Java, Python, PHP, etc.

Stored procedure also called subroutine which is stored in database and it has a name, parameter list, SQL statement.

(Image Source:- http://www.mysqltutorial.org/introduction-to-sql-stored-procedures.aspx)

stored procedures advantages

1. Typically stored procedures help increase the performance of the applications

2. Stored procedures help reduce the traffic between application and database server

3. Stored procedures are reusable and transparent to any applications

4. Stored procedures are secure.