MYSQL equivalent query

[chillay]

Hello

Can anyone write a MYSQL query that is somewhat equivalent to the following?

CREATE PROCEDURE CountPhoneNumbers
AS
DECLARE @count INTEGER
SELECT @count = COUNT (*)
FROM Customer
WHERE HomePhone IS NOT NULL
Print @count



Thank you!

 

[jpadie]

DELIMITER //
CREATE PROCEDURE CountPhoneNumbers()
  BEGIN 
    SELECT  COUNT(*) 
    FROM    Customers
    WHERE   HomePhone IS NOT NULL;
  END //
DELIMITER ;

 

[chillay]

Thank you Jpadie.