MySQL Stored Procedures

All Sun Server Hosting 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

 

** Please note you do not need to specify the DEFINER variable when running your code in PhpMyAdmin **

  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

Adjusting Server Time in PHP

All of our servers are configured to Eastern Time by default.  It is possible, however, for you...

Enabling SSH Access on Cloud Shared Hosting

Cloud HostingSecure Shell (SSH) Access is available free of charge on all cloud hosting...

Generating and Downloading a Full cPanel Backup

We suggest that you always have at least one copy of your data downloaded.  How often you'll want...

How do I choose a new PHP version?

From time to time your website may display a warning about the PHP version being out of date....

How do I order an IP address?

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