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

  • 189 Users Found This Useful
Was this answer helpful?

Related Articles

How do I order an IP address?

Due to the Global IP Address shortage and strict ARIN IP justification guidelines, we no longer...

What is the difference between public_html and www?

As far as you and your visitors will see there is no difference between the public_html and the...

How do I download my copy of WHMCS?

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

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