create procedure

lucycodes42

This code creates a procedure called "&USER_INPUT:1:procedure_name" that takes two arguments: "&USER_INPUT:2:arg_name" and "&USER_INPUT:3:INT". The first argument is the name of the procedure, while the second and third arguments are the actual parameters.

Shortcut: s_proc


DROP PROCEDURE IF EXISTS `procedure_name`;
CREATE PROCEDURE `${1}`(
`arg_name` INT,
) BEGIN
  $
END;