Skip to content

Instantly share code, notes, and snippets.

@REPTILEHAUS

REPTILEHAUS/stored-proc.sql

Created February 25, 2017 15:26
Show Gist options
  • Save REPTILEHAUS/6a826f09db217300862bdab49b643837 to your computer and use it in GitHub Desktop.
Save REPTILEHAUS/6a826f09db217300862bdab49b643837 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stored-proc.sql
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getMemeber_sproc`(
IN `usersession` INT(11),
OUT `output_name` VARCHAR(25)
)
BEGIN
SELECT name INTO output_name FROM members WHERE id = usersession;
END$$
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment