MySQL Stored Procedures

All MDDHosting clients can use MySQL stored procedures and routines on their web hosting accounts.

To use stored procedures, you should first create a database and add a database user to it. Make sure that you select the "ALL PRIVILEGES" option when you add the user to the database.

Then you should open cPanel > PhpMyAdmin, navigate to your database, open the SQL tag and paste the stored procedure code.

Comprehensive details on MySQL stored procedures and their syntax can be found in the MySQL5 official documentation:

http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html

  • 193 Users Found This Useful
Was this answer helpful?

Related Articles

Are your Virtual Private Servers managed?

VPS server management is an optional add-on available to our VPS clients, and was previously...

Adjusting Server Time in PHP

All of our servers are configured to Eastern Time by default.  It is possible, however, for...

I have a reseller account at another provider... Will you transfer it for me?

We will always do our best to assist you as much as possible when it comes to migrating accounts...

I rebooted my VPS and now it's offline! Help!

With all Virtual Private Server solutions any reboot commands must be issued from the VPS Control...

What is the difference between a Virtual Private Server and Semi-Dedicated Hosting?

A Virtual Private Server is essentially a "slice" of a much larger server that is made available...