Mysql procedure toturial

http://www.mysqltutorial.org/mysql-if-statement/

DELIMITER $$
 
CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `hps_mosir`.`test`(IN countryName VARCHAR(255), OUT total INT)
 
 
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN
 
 
	SELECT COUNT(*) INTO total FROM `banners` WHERE `name` = countryName;
 
    END$$
 
DELIMITER ;
CALL test('G1', @total);
SELECT @total;