Test.sql

CREATE DATABASE IF NOT EXISTS `test`;
USE `test`;

DELIMITER //
CREATE PROCEDURE `StoredProc`(
	IN `Param1` INT
)
    READS SQL DATA
    SQL SECURITY INVOKER
BEGIN
	SELECT `SecondInt` FROM `test` WHERE `FirstInt` = Param1;
END//
DELIMITER ;

CREATE TABLE IF NOT EXISTS `test` (
  `FirstInt` int(11) DEFAULT NULL,
  `SecondInt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `test` (`FirstInt`, `SecondInt`) VALUES
	(1, 1),
	(2, 2);