DELIMITER //
CREATE PROCEDURE foo_ct
BEGIN;
    SELECT COUNT(*) FROM foo;
END //
DELIMITER ;

CALL foo_ct();