MySQL Forums
Forum List  »  Stored Procedures

Re: Error in MySQL when trying to execute a stored procedure
Posted by: Chandan Kumar
Date: June 30, 2015 07:19AM

Hi,
I guess you are new in MYSQL.
Try This
delimiter $$
Drop procedure if exists CountPhoneNumbers $$
CREATE PROCEDURE CountPhoneNumbers()
begin
DECLARE count INTEGER;
SELECT COUNT(*) into count
FROM Customer
WHERE HomePhone IS NOT NULL;
end $$
delimiter ;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error in MySQL when trying to execute a stored procedure
840
June 30, 2015 07:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.