Stored Procedure Archives - ITFROMZERO

Mastering Stored Procedures and Cursors in MySQL: Safe Batch Processing and Error Handling

By IT From Zero October 29, 2026

A complete guide to writing MySQL Stored Procedures with Cursors for safe batch data processing, featuring Transaction wrapping, Exception Handlers, and database resource optimization.

MySQL

MySQL Stored Procedures and Functions: Optimizing Business Logic and Boosting Performance

By IT From Zero April 9, 2026

A practical guide to using Stored Procedures and Functions in MySQL, drawn from real-world experience. Learn how to optimize business logic, reduce latency, and improve the security of your database-backed systems.