Skip to content

Instantly share code, notes, and snippets.

@samredai

samredai/create_a_procedure.sql

Created December 10, 2018 00:05
Show Gist options
  • Save samredai/50d028e973eea9c1c5534d6037d15dc1 to your computer and use it in GitHub Desktop.
Save samredai/50d028e973eea9c1c5534d6037d15dc1 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Create a stored procedure
Raw
create_a_procedure.sql
delimiter #
DROP PROCEDURE IF EXISTS dataForSomeID;
CREATE PROCEDURE `dataForSomeID`(IN needThisID VARCHAR(20))
BEGIN
SELECT *
FROM sometable
LEFT JOIN anothertable
ON sometable.id = anothertable.id
WHERE id=needThisID;
END #
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment