Re: Error in MySQL when trying to execute a stored procedure

[Chandan Kumar]

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 ;