In this video we’ll see:
WHAT IS STORED PROCEDURE 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.
Logic, functional and domain-specific languages = declarative paradigm
A stored procedure that calls itself is known as a recursive stored procedure. Most
database management systems support recursive stored procedures. However, MySQL does not
support it very well.
FEATURES OF USING STORED PROCEDURES:
1. stored procedures help increase the performance of the applications. Once created,
stored procedures are compiled and stored in the database.
2. Stored procedures help reduce the traffic between application and database server
because instead of sending multiple lengthy SQL statements, the…