This guide concerns MySQL on Infomaniak hosting and their compatibility with stored procedures.

Preamble

• “Stored procedures” & “stored routines” are not possible on Web Hosting.

Understanding stored procedures and routines

If stored procedures are essential to your project and you currently have a shared hosting plan, you might consider a VPS or dedicated server, where you will have more control and resources.

Stored procedures offer a powerful and efficient way to automate tasks and manage business logic at the database level, which can result in more performant and easier-to-maintain applications.

On Serveur Cloud, as soon as the user has administrator rights on the relevant MySQL database, they have the necessary permissions to execute SQL instructions, including the EXECUTE command, which is used to run existing stored procedures in the database.

He also has the required privileges to create new stored procedures. Creating a stored procedure typically involves using specific SQL syntax to define the instructions to be executed, followed by saving this definition in the database.