1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Create stored procedures
This guide concerns MySQL on Infomaniak hosting, and its compatibility with stored procedures.
Stored Procedures and Routines
Stored procedures provide 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 execute existing stored procedures in the database.
They also have the required privileges to create new stored procedures. Creating a stored procedure typically involves using specific SQL syntax to define the statements to be executed, followed by saving this definition in the database.