Stored procedures Archives - Federico Razzoli

MySQL stored procedures: all ways to produce an output

Federico Razzoli June 6, 2019June 6, 2019 4 Comments

There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems.

Variable number of parameters and optional parameters in MySQL/MariaDB procedures

Federico Razzoli February 7, 2019June 5, 2019 11 Comments

MySQL and MariaDB don’t allow optional parameters for stored procedures, nor procedures accepting any number of parameters. However, these features can be emulated by passing JSON documents. Let’s see how.

Updating triggers online with MySQL and MariaDB

Federico Razzoli February 5, 2019June 10, 2019 5 Comments

Changing triggers in production is problematic, because for a short time triggers will be missing, or inconsistent with each other. This article proposes a solution to resolve the problem.