October 2022
Intermediate to advanced
380 pages
9h 35m
English
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.
MySQL’s stored procedures don’t have any support for packages, modules, or object-oriented ...