Thread: store procedure in mysql?

can you share something please.

A stored procedure, by definition, is a segment of declarative SQL code which is stored in the database catalog and can be invoked later by a program, a trigger or even a stored procedure.

Stored procedure increases performance of application. Once created, stored procedure is compiled and stored in the database catalog. It runs faster than uncompiled SQL commands which are sent from application.

Stored procedure is set of sql command, Once you are creating stored procedure in database it will stored in database and when you want to run than you can do it you don't have to write same sql commands repeat and repeat, in SQL and mySQL both, logic of stored procedure will be same, only syntax will differ.