MySQL 저장 프로시저

1 개요[ | ]

MySQL

Copy

DELIMITER //
CREATE PROCEDURE helloworld()
BEGIN
  SELECT "Hello World";
END
DELIMITER ;

MySQL

Copy

CALL helloworld()

MySQL

Copy

CREATE PROCEDURE simpleproc (OUT param1 INT)
BEGIN
  SELECT COUNT(*) INTO param1 FROM t;
END

MySQL

Copy

CALL simpleproc(@a);

MySQL

Copy

CREATE PROCEDURE country_hos (IN con CHAR(20))
BEGIN
  SELECT Name, HeadOfState FROM Country
  WHERE Continent = con;
END

MySQL

Copy

CALL country_hos('Europe');