MySql Stored Procedure 생성 및 저장방법

MySql Stored Procedure 생성 및 저장방법

CREATE DEFINER=`root`@`%` PROCEDURE `스키마`.`프로시저명`(
 	in _param1 varchar(40) -- 파라미터
)
begin
    declare data1 int default 0;	-- 변수
     
	set session transaction isolation level read uncommitted;
     
    set data1 = (select count(*) from table1 where id = _param1);

	if data1 = 0 then
		call sp_name_1(data1);
	end if;

	if (data1 <= 0) then
		update 	table2 ta2
		set		ta2.regData = now()
		where 	id = _param1;
	else
		update 	table3 ta3
		set		ta3.regData = now()
		where 	id = _param1;
	end if;
     
	set session transaction isolation level read committed;
end

 

끗31$!@#$!#$