MySQL Stored Procedure with IN, OUT parameters

// stored procedure:

CREATE TABLE mytable(
  id      INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name    VARCHAR(20)
);

INSERT INTO mytable (name) VALUES ('John Smith'), ('Tom Wright');
SELECT * FROM mytable;

DELIMITER $$

CREATE PROCEDURE MyProcedure(IN pId INT, OUT pName VARCHAR(20))
  BEGIN
    SELECT name INTO pName FROM mytable WHERE id=pId;
  END$$

DELIMITER ;