bspacer1 bspacer2
webmail hosting forum clients about

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98
Home PagePortal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloadsRegister

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > How to use MySQL stored procedures and routines?

How to use MySQL stored procedures and routines?

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

All CornerNET 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 answer helpful?

Add to Favourites
Print this Article

Also Read
How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)
I get syntax error when trying to run a MySQL query. (Views: 1061)
I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)
I have problems accessing my MySQL database remotely (Views: 5299)

Powered by WHMCompleteSolution


Copyright © 1994-2021 PJR Sales and Service All Rights Reserved