GoWebsite provides Domain Name Registration,
cPanel Hosting,
Website Security,
SEO, WordPress
Hosting, Email Accounts,
SSL Certificates,
Website Builder & other
Web Development Products.
Free setup! Speak with us anytime: 480-624-2500
Free setup! Speak with us anytime: 480-624-2500
Are stored procedures supported in MySQL?
Stored procedures are supported in MySQL 5.0. A stored procedure is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored procedure instead.
cPanel shared hosting accounts must use remote MySQL management tools, such as MySQL Workbench to use stored procedures.
An example of an allowed stored procedure:
DELIMITER $$
DROP PROCEDURE IF EXISTS `spGetSouls`$$
CREATE PROCEDURE `spGetSouls`()
DETERMINISTIC
BEGIN
SELECT * FROM soul;
END$$
DELIMITER ;
CALL spGetSouls();
DROP PROCEDURE IF EXISTS `spGetSouls`$$
CREATE PROCEDURE `spGetSouls`()
DETERMINISTIC
BEGIN
SELECT * FROM soul;
END$$
DELIMITER ;
CALL spGetSouls();
Be sure that your stored procedures are labeled as DETERMINISTIC
For more information on stored procedures, see the MySQL website and Stored Procedures Frequently Asked Questions.
More GoWebsite Articles
How many simultaneous connections can one MySQL database have?
Which MySQL features do you disable on hosting accounts?
How do you limit MySQL databases?
Connecting to a MySQL Database Using File DSN and ASP/ADO
Why do files in my icons directory not display?
What is a script?
Maintaining Your WordPress Websites
Domain Registration
Pay less for website domain names. Register your own .com, .net or .org for as low as $10.18 per year. We have everything you need to get online with your new domain.Website Builder
Build an amazing website in just under an hour with Website Builder. Take advantage of designs created just for your industry and then customize them to reflect your one-of-a-kind idea.Website Security
Protect your website and keep customers safe. Your comprehensive Website Security solution. Get peace of mind by securing your websites.cPanel Hosting
Everything needed to give your website the high-performance home it deserves. Protect transactions and secure your customer's data with a SSL Certificate
Copyright © 2005 - 2024. All rights reserved.
Privacy Policy