Create stored procedures

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

Preamble

• "Stored procedures" & "stored routines" are not possible on Web hosting shared.

Understand stored procedures and routines

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

The stored procedures offer a powerful and efficient way to automate tasks and manage business logic at the database level, which can lead to more efficient applications and easier to maintain.

On Cloud Server, since the user has an administrator right on the MySQL database concerned, he has the permissions necessary to execute SQL instructions, including the command EXECUTE, which is used to execute existing stored procedures in the database.

It also has the privileges required to create new stored procedures Creating a stored procedure usually involves using a specific SQL syntax to define the instructions to execute, followed by recording this definition in the database.