Create stored procedures

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

Preface

• “Stored procedures” & “stored routines” are not possible on shared 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 lead to more performant and easier-to-maintain applications.

On Cloud Server, as long as the user has administrative rights on the relevant MySQL database, they have the necessary permissions to execute SQL statements, including the EXECUTE command, which is used to run existing stored procedures in the database.

They also have the required privileges to create new stored procedures. Creating a stored procedure generally involves using specific SQL syntax to define the instructions to be executed, followed by registering this definition in the database.