DROP PROCEDURE IF EXISTS test;

DELIMITER //

CREATE PROCEDURE test()

BEGIN
    DECLARE Pvar INT;
    DECLARE @Gvar INT;
    SET Pvar = 2;
    SET @Gvar = 42;
    SELECT Pvar;
    SELECT @Gvar;

END//

DELIMITER ;

CALL test;