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

  • 200 Users Found This Useful
Was this answer helpful?

Related Articles

How do I access my cPanel?

Accessing your cPanel directly You can get to your control panel by appending "/cpanel" on to...

ClipShare/phpMotion - Thumbnails generated but video not visible?

Q. I have configured the correct paths to ffmpeg and mencoder in my video sharing scripts, but it...

How do I download my copy of WHMCS?

To download your copy of WHMCS: Log into our support system at...

What are private nameservers and how do I set them up?

Private nameservers are just custom DNS and HOST records that point to our DNS Cluster IPs. ...

How quickly will my Virtual Private Server be provisioned?

We do our best to provision Virtual Private Servers within 1 to 2 hours from the time that the...