· 6 years ago · Jul 25, 2019, 06:58 PM
1CREATE DATABASE IF NOT EXISTS `test`;
2USE `test`;
3
4DELIMITER //
5CREATE PROCEDURE `StoredProc`(
6 IN `Param1` INT
7)
8 READS SQL DATA
9 SQL SECURITY INVOKER
10BEGIN
11 SELECT `SecondInt` FROM `test` WHERE `FirstInt` = Param1;
12END//
13DELIMITER ;
14
15CREATE TABLE IF NOT EXISTS `test` (
16 `FirstInt` int(11) DEFAULT NULL,
17 `SecondInt` int(11) DEFAULT NULL
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20INSERT INTO `test` (`FirstInt`, `SecondInt`) VALUES
21 (1, 1),
22 (2, 2);