Programming/MySQL

호박고구메 2015. 2. 9. 16:27

1. 생성


DELIMITER $$

create procedure 프로시저명(인자)

begin

내용

end $$


ex)

DELIMITER $$

create procedure show_gameuser()

begin

select * from gameuser;

end $$



2. 삭제


drop procedure 프로시저명;


ex)

drop procedure show_gameuser;