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

In most programming languages, a function can have optional parameters that can be passed or not. Or it can accept any number of parameters. I will globally call these features dynamic parameters
. In this article we’ll see if, and how, we can use dynamic parameters in MySQL and MariaDB stored procedures
. What dynamic parameters areBut first, let me write a paragraph for those who don’t know what I’ve talking about. Let’s see a couple of examples in the PHP language – I’ve chosen it beca