Pacific-Design.com

    
Home Index

1. SQL Language

2. 07 PROCEDURE

SQL Language / 07 PROCEDURE /

SQL Create Procedure

CREATE PROCEDURE p (OUT ver_param VARCHAR(25), INOUT incr_param INT)
BEGIN

  -- Set value of OUT parameter
  SELECT VERSION() INTO ver_param;

  -- Increment value of INOUT parameter
  SET incr_param = incr_param + 1;

END;


Reference: