midMySQL
Using Stored Procedures
Updated May 4, 2026
Short answer
Saved SQL code blocks that can be executed as a routine.
Deep explanation
They reduce network traffic and encapsulate logic. Procedures can accept parameters and return result sets.
Real-world example
A complicated end-of-day reconciliation script stored on the DB server.
Common mistakes
- Putting business logic in procedures that is better handled in the application layer.
Follow-up questions
- Can they return values?