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

  • 198 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...

Can you enable "local-infile" for MySQL please?

Unfortunately this is an option that we will not enable in any of our shared environments such as...

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. ...