Knowledgebase
Webinova Online Customer Support > Webinova Help Desk > Knowledgebase

Search help:


How to use MySQL stored procedures and routines?

Solution

MySQL stored procedures and stored routines are supported after MySQL 5.

All SiteGround 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

 
Was this article helpful? yes / no
Article details
Article ID: 210
Category: cPanel MySQL Databases
Date added: 2012-12-07 13:18:06
Views: 15
Rating (Votes): Article rated 3.0/5.0 (2)

 
« Go back

 
Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid