Error in MySQL when trying to execute a stored procedure

[Ken Bond]

Trying to execute a stored procedure. When it runs, it should simply count the number of customers that have a listed phone number in the column HomePhone. Instead I'm getting the message "Error 1064(42000). You have an error in your SQL syntax."

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