mysql 프로시져 생성, 호출

Professional | hongjae83 http://blog.naver.com/hongjae83/150034876380

test 테이블을 하나 생성합니다 (ex) -- create News table, be sure to be in a 'test' DB CREATE TABLE News (NewsID int auto_increment not null, Title varchar(32), primary key(NewsID)) ---------------------------------------- 프로시져 만드는 형식 DELIMITER $$ DROP PROCEDURE IF EXISTS sprocTest $$ CREATE PROCEDURE sprocTest () BEGIN END $$ DELIMITER ; ---------------------------------------- ---------------------------------------- 파라미터가 1개있는 select프로시져 DELIMITER $$ DROP PROCEDURE IF EXISTS sprocTest $$ CREATE PROCEDURE sprocTest (id int) BEGIN  SELECT * FROM News WHERE NewsID=id; END $$ DELIMITER ; ---------------------------------------- ---------------------------------------- 파라미터가 2개있는 select 프로시져 DELIMITER $$ DROP PROCEDURE IF EXISTS sprocTest $$ CREATE PROCEDURE sprocTest (id int, title varchar(32)) BEGIN  -- INSERT NEW RECORD IF PREEXISTING RECORD DOESNT EXIST  IF (id = 0) THEN    SET id = null;  END IF;  IF (id IS NOT NULL) AND (EXISTS (SELECT * FROM News WHERE NewsID=id))  THEN    UPDATE News SET Title=title WHERE NewsID=id;  ELSE    INSERT INTO News (Title) VALUES (title);  END IF; END $$ DELIMITER ; ---------------------------------------- ---------------------------------------- 호출방법 call 프로시져이름(파라미터) ----------------------------------------