MySQL – DECLARE 에러

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

아래 코드는 오류가 발생한다.

CREATE DEFINER=`root`@`%` PROCEDURE `usp_xxxxxxxx`()
BEGIN
    set transaction isolation level read uncommitted;
    DECLARE p_roomname varchar(50);

DECLARE 는 BEGIN 바로 다음에 있어야 한다.

CREATE DEFINER=`root`@`%` PROCEDURE `usp_xxxxxxxx`()
BEGIN
    DECLARE p_roomname varchar(50);
    set transaction isolation level read uncommitted;