SQL Antipatterns, Volume 1

Mini-Antipattern: Stored Procedures in MySQL

MySQL’s implementation of stored procedures was introduced in version 5.0 in 2005. There wasn’t much demand for improvements, because most developers who used MySQL during that time preferred to execute SQL queries from application code or ORM classes, instead of using stored procedures. Because of this history, using procedures in MySQL has some additional challenges, beyond those described in the preceding chapter. Even a developer who is accustomed to using stored procedures in other brands of SQL products should read the following points before deciding to use procedures extensively in MySQL.

Using Packages

MySQL’s stored procedures don’t have any support for packages, modules, or object-oriented ...